MySQL is among the well-liked RDBMS (relational database management system) considering the prevailing statistics. Increased admins/developers are utilizing this database in online application. Below, we introduce to you 5 MySQL utilities that will assist in proper utilization of the database.
Tcprstat
This open source and free TCP analysis utility evaluates traffic in a network and computes delay between requests and response. Using this, the utility draws statistics on response-time and publishes them. This output is akin to other stat tool in UNIX like vmstat, mpstat and iostat.
Openark Kit
This functions like a utility set for MySQL. The utilities solve daily maintenance tasks that may be complex or consume much time when using manual means. The tools are developed in Python making them need Python2.3 or newer as well as drivers for python-mysqldb. Other tools necessitate MySQL5.0 or newer.
Shard-Query
This middleware solution in MySQL is a hugely parallel processing utility. Shard-Query offers enhanced performance, transparent sharding, cross-shard aggregation and intra-query parallelism useful in queries over sharded and partitioned tables.
Mycheckpoint
This is a minimalist and SQL monitoring tool for MySQL. My checkpoint allows configurations for monitoring both server and MySQL metrics: temporary tables, InnoDB buffer pool flushes, OS load etc.
Percona Toolkit for MySQL
This is a compilation of superior command-line tool for performing various MySQL server as well as system tasks, which are very complicated or complex to carryout manually.
I find MONyog- MySQL monitoring tool, a complete package in this regard. It gives me access to slow query log, realtime queries, 600+ monitors and also mail notification alerts for these monitors. As a part of my job to monitor the MySQL server performance, this tool made my job easier. Earlier I use to write cron jobs which queries the performance_schema database of MySQL for various performance metrics.