What is he doing MySQL?
9 giugno 2008, 13:37 MySQL , Open Source , Tips & Tricks June 9, 2008, 13:37
If we want to obtain flight information on what you're doing our MySQL database without having to resort to graphical user interfaces or web applications, the command line as there is always help.
Besides the usual `show processlist` - but it must be launched from the interface's text-mysql - here are two simple but holds essential for the proper monitoring of the mysqld daemon from a shell:
-
extracts information at a glance the status of the db:
mysqladmin -u root -p -i 5 status -
obtained specific information about the status of the db:
mysqladmin -u root -p -i 5 extended-status -r | grep Com_select
In this case, we extracted the number of select current. Changing the grep you can get over 200 different information!
Attention! In both cases you will be prompted for the password of the user `root` MySQL.
