If your server’s mysql always in high resources or down, I suggest you use this command to trace out which database that eat up your MySql resource
- /usr/bin/mysqladmin proc stat
- /usr/bin/watch -n 5 ‘mysqladmin proc stat’
Every 5.0s: mysqladmin proc stat Sat Aug 28 02:05:06 2010
+------+----------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+----------+-----------+----+---------+------+-------+------------------+
| 1404 | da_admin | localhost | | Query | 0 | | show processlist |
+------+----------+-----------+----+---------+------+-------+------------------+
Uptime: 1408 Threads: 1 Questions: 32688 Slow queries: 1 Opens: 218 Flush tables: 1 Open table
s: 211 Queries per second avg: 23.215
This will show up your MySql running resources every 5 seconds.
Some people search for:
- mysqladmin proc
- watch mysqladmin proc
- check mysql resources
- mysqladmin proc stat
- mysql proc stat
- mysql execute every 5 sec
- mysql view resources
- watch -n1 mysqladmin proc stat
- mysqladmin proc stat in windows
- mysqladmin proc version
- mysqladmin proc watch
- show mysql resource
- mysqladmin proc doesnt show queries
- mysqladmin proc commands
- mysqladmin proc command in linux
- mysqladmin proc slow query
- mysql view resource
- how to chceck mysql resource
- how to check resources mysql using on linux
- how to check the resources of the mysql admin
- how to check what resources mysql is using
- how to check which use mysql resources
- how to use watch \mysqladmin proc\
- linux mysql stat watch
- mysql proc stat command
- mysql proc stat opens
- mysql procstat
- /usr/bin/mysqladmin -u root --password
If you enjoyed this article, please consider sharing it!
[...] [root@server ~]# /usr/bin/watch -n 5 ‘mysqladmin proc stat’ [...]