huhuegg 发表于 2009-12-07 11:33

mysql数据库工具


mysqlreport
mysqlreport makes a friendly report of important MySQL status values.
http://hackmysql.com/mysqlreport

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.
http://hackmysql.com/mysqlidxchk


mysqlsla
数据报表,非常有利于分析慢查询的原因, 包括执行频率, 数据量, 查询消耗
http://hackmysql.com/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).
http://mysql-mmm.org/


innotop


The best top clone for MySQL, with special attention paid to InnoDB

http://code.google.com/p/innotop/

innodb-tools

Data Recovery Toolkit for InnoDB - set of tools for checking InnoDB tablespaces and recovering data from damaged tablespaces or from dropped/truncated InnoDB tables.

http://code.google.com/p/innodb-tools/

mysqlsniffer
a
tcpdump
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.
http://hackmysql.com/mysqlsniffer



本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/8897/showart_2112645.html
页: [1]
查看完整版本: mysql数据库工具