一些对Mysql DBA有用的脚本
时间:2008-12-07 来源:Coolriver
A collection of scripts for making your daily MySQL DBA responsibilities easier.
mt-backup-parallel -> runs mysql backups in parallel super fast, has lots of reporting features mt-check-replication -> script to report on replication status for slave servers mt-rhcluster-check-filesystems -> reports on redhat cluster filesystems (for mysql active/passive clustering) mt-rhcluster-script-wrapper -> wrapper script for running any of these scripts on a redhat cluster, chooses the active node to run the script on mt-connections-log -> logs connections to mysql to disk, reports on threshold overages mt-flush-tables-sequence -> runs through schema.tables to flush in sequence before global flush mt-rotate-logs -> rotates general and slow query logs on periodic basis mt-my.cnf_xG -> MySQL configuration file for a particular RAM size installation 下载地址: http://code.google.com/p/monolith-toolkit/ 另外sf.net也有很多有用的脚本,当需要写什么的时间。可以去搜一下,这样就不用从头开始了。
mt-backup-parallel -> runs mysql backups in parallel super fast, has lots of reporting features mt-check-replication -> script to report on replication status for slave servers mt-rhcluster-check-filesystems -> reports on redhat cluster filesystems (for mysql active/passive clustering) mt-rhcluster-script-wrapper -> wrapper script for running any of these scripts on a redhat cluster, chooses the active node to run the script on mt-connections-log -> logs connections to mysql to disk, reports on threshold overages mt-flush-tables-sequence -> runs through schema.tables to flush in sequence before global flush mt-rotate-logs -> rotates general and slow query logs on periodic basis mt-my.cnf_xG -> MySQL configuration file for a particular RAM size installation 下载地址: http://code.google.com/p/monolith-toolkit/ 另外sf.net也有很多有用的脚本,当需要写什么的时间。可以去搜一下,这样就不用从头开始了。
相关阅读 更多 +