This is htop, an interactive process viewer for Linux. It is a text-mode application (for console or X terminals) and requires ncurses. Tested with Linux 2.4 and 2.6.
Needed RPMForge Repo for easy installation.
yum install htop
Monitors a MySQL server showing the queries which are taking the most amount of time to complete. Features include ‘zooming’ in on a process to show the complete query, ‘explaining’ the query optimizer information for a query and ‘killing’ queries. In addition, server performance statistics, configuration information, and tuning tips are provided.
Needed RPMForge Repo for easy installation:
yum install mtop
Create file .mtoprc in own Home.
cd ~ vim .mtoprc
Add the following line in this file:
--dbuser=root --password=mypass --seconds=1
Save and Quit.
Run this comand:
To be Continued…