AjaxMyTop is a Web-based tool featuring an AJAX user interface for monitoring a MySQL server. Installing and configuring is fairly simple which you can done it within 2 minutes.
AjaxMyTop currently requires PHP5 and it may not work properly with php 4.x versions. Get it to the exact web root directory which you want to run ajaxMyTop. In my case it is /var/www/html
- # cd /var/www/html
- # wget http://downloads.sourceforge.net/project/ajaxmytop/ajaxmytop/ajaxMyTop-0.7.2/ajaxMyTop-0.7.2.tar.gz
- # tar zxvf ajaxMyTop-0.7.2.tar.gz
- # mv ajaxMyTop mytop# cd mytop
You can configure ajaxMyTop by editing the config.php file.
The db settings are straightforward, simply give the host (i.e., ‘localhost’), user (i.e., ‘ajaxmytop’), and password (i.e., ‘ajaxmytop’) for your MySQL server. The filters array is simply a variable used internally to make filtering code simpler(?). You do not need to modify it.
MySQL: It is highly recommended that you create a new user for ajaxMyTop with the SUPER and PROCESS privileges rather than configure ajaxMyTop with an admin user.
- GRANT SUPER, PROCESS ON *.* to ‘ajaxmytop’@’localhost’ identified by ‘ajaxmytop’;
GRANT SUPER, PROCESS ON *.* to ‘ajaxmytop’@’%’ identified by ‘ajaxmytop’;
Apparently you must also grant the SELECT privilege to the ajaxmytop user for all databases in which you may want to explain threads.
- GRANT USAGE, SELECT ON test.* to ‘ajaxmytop’@’localhost’ identified by ‘ajaxmytop’;
- GRANT USAGE, SELECT ON test.* to ‘ajaxmytop’@’%’ identified by ‘ajaxmytop’;
Edit the config.php and enter the user-name and password setting which you have setup. Access it via your server ip or domain based on your installation location.
Make sure you have .htaccess folder permission enabled on the mytop folder or else everyone can access and view your mysql query usages etc.
SHORTCUT KEYS: / or ? : toggle shortcut key display space bar : clear filter values s : change refresh interval c : Command filter d : db filter h : Host filter i : toggle idle threads k : kill thread u : User filter