Interface Tools:Msql Workbench http://www.mysql.com/products/workbench sqlyog http://www.webyog.com phpMyAdmin http://sourcefor Ge.net/projects/phpmyadmin [Not recommended] adminer phpMyAdmin better alternatives, http://www.adminer.org[not recommended for public access]
command-line toolset:Percona toolkit:mysql Administrator-required toolkit. Includes many tools for similar log analysis, replication integrity detection, data synchronization, schema and index distractions, query suggestions, and data archiving purposes. The first thing to do is to be the key tool: Pt-mysql-summary\pt-able-checksum\pt-tabble-sync\pt-query-digest. Reference official website: Http://www.percona.com/software Maatkit and Aspersa: has been incorporated into Percona toolkit inside the Openark kit:http://code.ope Nark.org/forge/openark-kit python script that can be used to do some class management tasks MySQL Workbenche toolset: http://launchpad.net/mysql-utileties
SQL Usage Set:Free add-ons and utility sets built into the server itself Common_schema: A set of powerful code and views for server scripting and management, Http://code.openark.org/forge/common_schema Mysql-sr-li B: Stored procedure code base, Http://nongnu.org/mysql-sr-lib mysql UDF repository: Custom Function collection, http://www.mysqludf.org MySQL Forge: Community contributed programs, Scripts, code snippets, utility sets and tricks and traps http://forge.mysql.com
Monitoring tools:
Health monitoring tools--detection of abnormal alarms--and tools for recording indicators for trends, diagnostics, troubleshooting, capacity planning, and more. Open source monitoring tools: nagios:http://www.nagios.org Z Abbix: http://www.zabbix.com Zenoss: http://www.zenoss.com [ Use SNMP to collect data from remote servers by default] Hyperic HQ: Java-based monitoring system, cumbersome http://www.hyperic.com & nbsp OpenNMS: Java development as well. Target high performance, scalable, automated and flexible http://opennms.org Groundwork Open source:http://www.gwos.com You can integrate Nagios and several other tools into one system with just the interface.  RRD focuses on collecting metrics and drawing and visualizing, rather than performing performance monitoring checks . Mrtg:multi Router traffic Grapher HTTP://OSS.OETIKER.CH/MRTG . CACTI for recording network traffic: the most popular RRDtool-based system www.cacti.net MySQL templates: http://code.google.com/p/mysql-cacti-templates ganglia:http:// Ganglia.sourceforge.net is designed for monitoring clusters and network systems, and can be aggregated to view more servers ' data   Munin:rrdtool The data, then creates a data graph with a different amount of effort. graphite:http://graphite.wikidot.com
Commercial Monitoring system:MySQL Enterprise Monitor: Included in the MySQL Support service for Oracle. Features such as monitoring, metrics, and drawing, consulting services, and query analysis are integrated into one tool. Http://www.mysql.com/products/enterprise/monitor.html Monyog:http://www.webyog.com is a browser-based, agent-free monitoring system running on the desktop. New Relic:saas Services, providing a full range of analysis, application performance, code, database, system and other aspects http://newrelic.com circonus:https://circonus.com through Gaent collection The indicator is forwarded to Circonus, which is viewed through browser instrumentation. Monitis:http://monitis.com Sass's monitoring system. Free version: http://mon.itor.us splunk:http://www.splunk.com log collector and search engine. Pingdom:http://www.pingdom.com
innotop command-line monitoringInnotop:http://code.google.com/p/innotop mtop:http://mtop.sourceforge.net mytop:http://jeremy.zawodny.com/mysql/ The Innotop features written by Mytop Balon Schwartz include: The transaction list can display InnoDB the current list of all transaction queries can display the current running query can display a list of current locks and lock waits to display the server state in relative value and the summary information of the variable can be used to display InnoDB internal information, such as buffer, deadlock, foreign key errors, I/O activity, row operations, semaphores and so on replication monitoring, the primary server and the status from the server display any server variable mode server group can be more Easy to organize abortion server can use non-interactive mode under command-line scripting
The "16th MySQL user tool" Summary of high performance MySQL
