18/07/2014
5 Good Tools For Admins
( can make good use of the popular with these tools...)
1.tcprstat
is a free, open-source TCP analysis tool that watches network traffic and computes the delay between requests and responses. From this it derives response-time statistics and prints them out. The output is similar to other Unix -stat tools such as vmstat, iostat, and mpstat.
2.openark kit
The is a set of utilities for MySQL. They solve everyday maintenance tasks, which may be complicated or time consuming to work by hand. All tools are coded in Python, and require Python 2.3 or newer, and the python-mysqldb driver. Some tools require MySQL 5.0 or higher.
3.Shard-Query
Shard-Query is a massively parallel processing middleware solution for MySQL. It provides high performance cross-shard aggregation, transparent sharding and intra-query parallelism for queries over partitioned and sharded tables.
4.mycheckpoint
Lightweight, SQL oriented monitoring for MySQL. It can be configured to monitor both MySQL and server metrics: InnoDB buffer pool flushes, temporary tables, operating system load, etc.
5.Percona Toolkit for MySQL
Percona Toolkit for MySQL is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex to perform manually.