Archive for August, 2007
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 »