Archive for August, 2007
Friday, August 24th, 2007
MK-PARALLEL-DUMP
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-parallel-dump - Dump sets of MySQL tables in parallel.
SYNOPSIS
mk-parallel-dump
mk-parallel-dump --tab --basedir /path/to/backups/
mk-parallel-dump --sets order,profile,session --settable meta.backupset
DESCRIPTION
mk-parallel-dump connects to a MySQL server, finds database and table names,
and dumps them in parallel for speed. It can ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-VISUAL-EXPLAIN
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-visual-explain - Format EXPLAIN output as a tree.
SYNOPSIS
mk-visual-explain <file_containing_explain_output>
mk-visual-explain -c <file_containing_query>
mysql -e "explain select * from mysql.user" | mk-visual-explain
DESCRIPTION
mk-visual-explain reverse-engineers MySQL's EXPLAIN output into a query
execution plan, which it then formats as a left-deep tree --- the same ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-QUERY-PROFILER
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-query-profiler - Execute SQL statements and print statistics, or measure
activity caused by other processes.
SYNOPSIS
mk-query-profiler can profile the (semicolon-terminated, blank-line
separated) queries in a file:
mk-query-profiler queries.sql
cat queries.sql | mk-query-profiler
mk-query-profiler -vv queries.sql
mk-query-profiler ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-SLAVE-PREFETCH
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-slave-prefetch - Pipeline relay logs on a MySQL slave to pre-warm caches.
SYNOPSIS
mk-slave-prefetch
mk-slave-prefetch --statistics > /path/to/saved/statistics
mk-slave-prefetch /path/to/saved/statistics
DESCRIPTION
mk-slave-prefetch reads the slave's relay log slightly ahead of where the
slave's SQL thread is reading, converts statements into "SELECT", and
executes them. In ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-ARCHIVER
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-archiver - Archive rows from a MySQL table into another table or a file.
SYNOPSIS
mk-archiver --source h=oltp_server,D=test,t=tbl --dest h=olap_server \
--file '/var/log/archive/%Y-%m-%d-%D.%t' --limit 1000 --commit-each
DESCRIPTION
mk-archiver is the tool I use to archive tables as described in
<http://www.xaprb.com/blog/2006/05/02/how-to-write-efficient-archiving-and-purging-jobs-in-sql/>.
The goal is ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-CHECKSUM-FILTER
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-checksum-filter - Filter checksums from mk-table-checksum.
SYNOPSIS
mk-checksum-filter checksums.txt
mk-table-checksum host1 host2 | mk-checksum-filter
mk-checksum-filter db1-checksums.txt db2-checksums.txt --ignoredb
OVERVIEW
This program takes the unsorted, verbose output from mk-table-checksum and
sorts it, then filters it so you only see lines ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-PARALLEL-RESTORE
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-parallel-restore - Load files into MySQL in parallel.
SYNOPSIS
mk-parallel-restore /path/to/files
mk-parallel-restore --tab /path/to/files
DESCRIPTION
mk-parallel-restore is a way to load SQL or delimited-file dumps into MySQL
in parallel at high speed. It is especially designed for restoring files
dumped by mk-parallel-dump. ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-SLAVE-FIND
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-slave-find - Find MySQL replication slaves and execute commands on them.
SYNOPSIS
mk-slave-find
DESCRIPTION
mk-slave-find connects to a MySQL replication master and finds its slaves.
Currently the only thing it can do is print a tree-like view of the replication
hierarchy.
DOWNLOADING
You can download Maatkit from the ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-SHOW-GRANTS
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-show-grants - Canonicalize and print MySQL grants so you can effectively
replicate, compare and version-control them.
SYNOPSIS
mk-show-grants
mk-show-grants --separate --revoke | diff othergrants.sql -
DOWNLOADING
You can download Maatkit from the Sourceforge website at
<http://sourceforge.net/projects/maatkit>, or you can get any of ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-FIND
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-find - Find MySQL tables and execute actions, like GNU find.
DESCRIPTION
mk-find looks for MySQL tables that pass the tests you specify, and executes
the actions you specify. The default action is to print the database and table
name to STDOUT.
mk-find is simpler ...
Posted in Uncategorized | No Comments »