{"id":4363,"date":"2011-10-08T14:14:14","date_gmt":"2011-10-08T08:44:14","guid":{"rendered":"http:\/\/www.tothenew.com\/blog\/?p=4363"},"modified":"2017-02-12T19:21:08","modified_gmt":"2017-02-12T13:51:08","slug":"mysql-top-just-like-we-have-top-command-in-linux","status":"publish","type":"post","link":"https:\/\/www.tothenew.com\/blog\/mysql-top-just-like-we-have-top-command-in-linux\/","title":{"rendered":"Mysql top just like we have top command in Linux"},"content":{"rendered":"
Once in my grails project i was facing the problem of freeze of server.When this happens tomcat becomes unresponsive.Later on by\u00a0analyzing\u00a0the thread dump we found that this problem might be due to the database and tomcat communication. So as to analyse how many connection are active at mysql end we found a query.<\/div>\n

Show processlist;<\/p>\n

Which gives us the result as:
\nOutput:
\n+—–+——+———–+———————+———+——+——-+——————+<\/p>\n

| Id \u00a0| User | Host \u00a0 \u00a0 \u00a0| db \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| Command | Time | State | Info \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n

+—–+——+———–+———————+———+——+——-+——————+<\/p>\n

| 242 | root | localhost | \u00a0 \u00a0 \u00a0test_db \u00a0 \u00a0| Query \u00a0 | \u00a0 \u00a00 | NULL \u00a0| show processlist |<\/p>\n

+—–+——+———–+———————+———+——+——-+——————+<\/p>\n

The output shows how many connections are active and their properties.
\nBut for this you need to run the query again and again to analyse the connections information. For a better experience we can use mytop \u00a0which is very easy to install and just like the top in linux, simple steps need to be followed to make it work.<\/p>\n

Step 1:Install mytop using the following command.<\/p>\n

anuj@intelligrape:~$ sudo apt-get install mytop
\nStep 2:
\nAfter installation we need make a configuration file .mysqlconfig any where
\ne.g
\nanuj@intelligrape:~$ vim .mysqlconfig
\nuser=<\/p>\n

pass=<\/p>\n

host=localhost<\/p>\n

db=db_name<\/p>\n

delay=5<\/p>\n

port=330<\/p>\n

6socket=<\/p>\n

batchmode=0<\/p>\n

header=1<\/p>\n

color=1<\/p>\n

idle=1<\/p>\n

For more option you can refer to documentation of mytop .
\nStep 3:
\nNow just need run this command to see the mysqltop working.
\nanuj@intelligrape:~$ mytop ~\/.mysqlconfig
\noutput:<\/p>\n

Thats it ! Internally it runs the query “show processlist” and is very elegant for analysing mysql connections.<\/p>\n

This helps me! Hope this helps you guys!
\nAnuj Aneja<\/p>\n

Intelligrape Software<\/p>\n","protected":false},"excerpt":{"rendered":"

Once in my grails project i was facing the problem of freeze of server.When this happens tomcat becomes unresponsive.Later on by\u00a0analyzing\u00a0the thread dump we found that this problem might be due to the database and tomcat communication. So as to analyse how many connection are active at mysql end we found a query. Show processlist; […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":11},"categories":[7],"tags":[260,76],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/4363"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=4363"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/4363\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=4363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=4363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=4363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}