How to view MySql running resources

TheCompWiz · Oct 2, 2016

If your server's mysql always in high resources or down, what commands or tools can I use to trace out which database that eat up your MySql resource?
Please share your suggestions. Thanks!

sh-admin · Oct 2, 2016

Very first thing is to check the mysql version that you are running , make sure its upto date ..MariaDB is the perfect replacement for mysql so it would fix all the resource usages ... further use mysqladmin proc command to see which database is being queries , which are the slow queries and what they are doing...

the command will give you all the process list...

LJSHost · Oct 2, 2016

Login to your mysql console:

mysql -u root -p

SHOW PROCESSLIST;

Look in the time field for any processes that have been running for a long time.
Also check your slow query log /var/log/mysql/mysql-slow.log (file location depends on distribution and configuration)

You many also need to enable the slow query log.

UWH-David · Oct 5, 2016

Code:

mytop

is a great command to view the top mysql processes live.

How to view MySql running resources

TheCompWiz

Well-known member

sh-admin

Active member

steitieh

Well-known member

LJSHost

Well-known member

UWH-David

Member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud