How to monitor Database

[jdaano]

Hi guys.. im just a level 1 IT support
Just ask if how to know if our Database is running good..
Were using Vicibox
what i do is running the HTOP command to show the load and memory.
is there anything aside from that. to know our database is at good performance.
thanks all

[covarrubiasgg]

Try with mtop , it will display in red all the queries that are taking too long.

[williamconley]

Code: Select all

mysql -u cron -p1234 asterisk -e"show processlist"

Which shows the same stuff as mtop and mytop, but does not fail to configure itself properly as those other packages often do. LOL.

If you want to "keep an eye on it" for a while:

Code: Select all

watch -n 1 "mysql -u cron -p1234 asterisk -e'show processlist' | grep Sleep -v"

Trust me, if the server starts sweating, you'll notice it. LOL

[covarrubiasgg]

Trust me, if the server starts sweating, you'll notice it. LOL

xD thats when the fun starts xD .