mysql数据库工具

mysqlreport

mysqlreport makes a friendly report of important MySQL status values.

 

mysqlidxchk

mysqlidxchk (MySQL Index Checker) checks MySQL databases/tables for unused indexes. Given one or more slow, general, or "raw" log files, mysqlidxchk reports which indexes in the database schema are not used by the queries in the log files.

 

mysqlsla  

数据报表,非常有利于分析慢查询的原因, 包括执行频率, 数据量, 查询消耗

 

MMM (Multi-Master Replication Manager for MySQL)

a set of flexible scripts to perform monitoring/failover and management of MySQL master-master replication configurations (with only one node writable at any time).

 

 

innodb-tools  

 

mysqlsniffer

a  clone specifically for dumping/sniffing/watching MySQL network protocol traffic over TCP/IP networks. mysqlsniffer is coded in C using the pcap library and works with MySQL version 4.0 and newer. mysqlsniffer is the only MySQL-specific network sniffer.