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 »
Friday, August 24th, 2007
MK-DUPLICATE-KEY-CHECKER
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-duplicate-key-checker - Find possible duplicate indexes and foreign keys on
MySQL tables.
DESCRIPTION
This program examines the output of SHOW CREATE TABLE on MySQL tables, and if
it finds indexes that cover the same columns as another index in the same
order, or cover an exact ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-PROFILE-COMPACT
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-profile-compact - Compact the output from mk-query-profiler.
SYNOPSIS
To view queries 2, 4 and 6 side by side:
mk-profile-compact -q 2,4,6 profile-results.txt
To view summaries from two runs side by side:
mk-profile-compact -m SUMMARY results-1.txt results-2.txt
DESCRIPTION
mk-profile-compact slices and aligns the ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-HEARTBEAT
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-heartbeat - Monitor MySQL replication delay.
SYNOPSIS
mk-heartbeat -D test --update -h master-server
mk-heartbeat -D test --monitor -h slave-server
mk-heartbeat -D test --monitor -h slave-server --dbidriver Pg
DESCRIPTION
mk-heartbeat is a two-part MySQL and PostgreSQL replication delay monitoring
system that doesn't require the slave to ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-DEADLOCK-LOGGER
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-deadlock-logger - Extract and log MySQL deadlock information.
SYNOPSIS
The following examples will print deadlocks, store deadlocks in a database
table, and daemonize and check once every 30 seconds for 4 hours,
respectively:
mk-deadlock-logger --print
mk-deadlock-logger --source u=user,p=pass,h=server --dest D=test,t=deadlocks
mk-deadlock-logger --dest D=test,t=deadlocks --daemonize -m ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-TABLE-SYNC
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-table-sync - Synchronize MySQL tables efficiently.
SYNOPSIS
It is a good idea to back up your data and run "mk-table-sync" with ``--test''
first, to see what will happen. If you want to see which rows are different
without changing the tables, use ``--print'' instead ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-TABLE-CHECKSUM
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-table-checksum - Perform an online replication consistency check, or
checksum MySQL tables efficiently on one or many servers.
SYNOPSIS
mk-table-checksum --replicate=mydb.checksum master-host
... time passses, replication catches up ...
mk-table-checksum --replicate=mydb.checksum --replcheck 2 master-host
Or,
mk-table-checksum ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-SLAVE-RESTART
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-slave-restart - Watch and restart MySQL replication after errors.
SYNOPSIS
mk-slave-restart --verbose
DESCRIPTION
mk-slave-restart watches one or more MySQL replication slaves and tries to skip
statements that cause errors. It polls slaves intelligently with an
exponentially varying sleep time. You can specify errors to ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-SLAVE-DELAY
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-slave-delay - Make a MySQL slave server lag behind its master.
SYNOPSIS
To hold slavehost one minute behind its master for ten minutes:
mk-slave-delay --delay 1m --interval 15s --time 10m slavehost
DESCRIPTION
"mk-slave-delay" watches a slave and starts and stops its replication SQL
thread as necessary ...
Posted in Uncategorized | No Comments »
Friday, August 24th, 2007
MK-SLAVE-MOVE
Section: User Contributed Perl Documentation (1)Updated: 2008-06-01Index
Return to Main Contents
NAME
mk-slave-move - Move a MySQL slave around in the replication hierarchy.
SYNOPSIS
mk-slave-move slave --sibling-of-master
mk-slave-move slave --slave-of-sibling sibling
mk-slave-move slave --slave-of-uncle uncle
DESCRIPTION
This tool knows how to disconnect and reconnect slaves to each other, compare
replication positions, and so on. This makes ...
Posted in Uncategorized | No Comments »
Tuesday, August 21st, 2007
NAME
info - read Info documents
SYNOPSIS
info
[OPTION]... [MENU-ITEM...]
DESCRIPTION
Read documentation in Info format.
OPTIONS
--apropos=STRING
look up STRING in all indices of all manuals.
-d, --directory=DIR
add DIR to INFOPATH.
--dribble=FILENAME
remember user keystrokes in FILENAME.
-f, --file=FILENAME
specify Info file to visit.
-h, --help
display this help and exit.
--index-search=STRING
go to node pointed by index entry STRING.
-n, --node=NODENAME
specify nodes in first visited Info file.
-o, ...
Posted in Uncategorized | No Comments »
