{"id":2036,"date":"2015-05-15T05:36:50","date_gmt":"2015-05-15T05:36:50","guid":{"rendered":"https:\/\/cpanelplesk.com\/wp62\/?p=2036"},"modified":"2021-02-09T12:14:58","modified_gmt":"2021-02-09T12:14:58","slug":"how-to-check-mysql-process-list-on-a-cpanel-server","status":"publish","type":"post","link":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/","title":{"rendered":"How to check MySQL process list on a cPanel server:"},"content":{"rendered":"

From cPanel server we can check MySQL process list with the different ways.As we all know for most of\u00a0the production servers it is necessary to check MySQL process list for monitoring the currently running\u00a0queries and to discovering queries that slow down the website loading speed.<\/p>\n

From command line we can check MySQL process list with the following ways:<\/p>\n

Go to MySQL by using the following command:<\/p>\n

\n
mysql<\/pre>\n<\/div>\n
After that enter the command:<\/p>\n
\n
show processlist;<\/pre>\n<\/div>\n
mysql> show processlist;<\/p>\n
+——–+————–+———–+————–+———+——+——-+——————+<\/p>\n
| Id \u00a0\u00a0\u00a0\u00a0| User \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Host \u00a0\u00a0\u00a0\u00a0\u00a0| db \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Command | Time | State | Info |<\/p>\n
+——–+————–+———–+————–+———+——+——-+——————+<\/p>\n
| \u00a0\u00a07605 | eximstats \u00a0\u00a0\u00a0| localhost | eximstats \u00a0\u00a0\u00a0| Sleep \u00a0\u00a0| \u00a0296 | \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| NULL |<\/p>\n
| 218382 | modsec \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| localhost | modsec \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Sleep \u00a0\u00a0| 4181 | \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| NULL |<\/p>\n
| 219303 | leechprotect | localhost | leechprotect | Sleep \u00a0\u00a0| 3926 | \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| NULL |<\/p>\n
| 219552 | root \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| localhost | NULL \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Query \u00a0\u00a0| \u00a0\u00a0\u00a00 | NULL \u00a0| show processlist |<\/p>\n
+——–+————–+———–+————–+———+——+——-+——————+<\/p>\n
4 rows in set (0.00 sec)<\/p>\n
Another way from the command line to check the result of process list during a specific interval of time is as follows:<\/p>\n
\n
mysqladmin -i 4 processlist<\/pre>\n<\/div>\n
It will display as:<\/p>\n
—————+<\/p>\n
| Id \u00a0\u00a0\u00a0\u00a0| User \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Host \u00a0\u00a0\u00a0\u00a0\u00a0| db \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Command | Time | State | Info |<\/p>\n
+——–+————–+———–+————–+———+——+——-+——————+<\/p>\n
| 7605 \u00a0\u00a0| eximstats \u00a0\u00a0\u00a0| localhost | eximstats \u00a0\u00a0\u00a0| Sleep \u00a0\u00a0| 196 \u00a0|<\/p>\n
| 218382 | modsec \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| localhost | modsec \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Sleep \u00a0\u00a0| 4081 |<\/p>\n
| 219303 | leechprotect | localhost | leechprotect | Sleep \u00a0\u00a0| 3826 |<\/p>\n
| 219544 | root \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| localhost | \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Query \u00a0\u00a0| 0 \u00a0\u00a0\u00a0| \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| \u00a0\u00a0show processlist |<\/p>\n
+——–+————–+———–+————–+———+——+——-+——————+<\/p>\n","protected":false},"excerpt":{"rendered":"
From cPanel server we can check MySQL process list with the different ways.As we all know for most of\u00a0the production servers it is necessary to check MySQL process list for monitoring the currently running\u00a0queries and to discovering queries that slow down the website loading speed. […]<\/p>\n
Continue Reading…<\/a><\/p>\n","protected":false},"author":2,"featured_media":1031,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2036","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel"],"yoast_head":"\nHow to check MySQL process list on a cPanel server: - cPanel Plesk<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"How to check MySQL process list on a cPanel server: - cPanel Plesk\" \/>\n<meta name=\"twitter:description\" content=\"From cPanel server we can check MySQL process list with the different ways.As we all know for most of\u00a0the production servers it is necessary to check MySQL process list for monitoring the currently running\u00a0queries and to discovering queries that slow down the website loading speed. [...]Continue Reading...\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2014\/12\/MySQL-Error.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Seemab Saleem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/\"},\"author\":{\"name\":\"Seemab Saleem\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\"},\"headline\":\"How to check MySQL process list on a cPanel server:\",\"datePublished\":\"2015-05-15T05:36:50+00:00\",\"dateModified\":\"2021-02-09T12:14:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/\"},\"wordCount\":214,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"image\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2014\/12\/MySQL-Error.jpg\",\"articleSection\":[\"Cpanel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/\",\"name\":\"How to check MySQL process list on a cPanel server: - cPanel Plesk\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2014\/12\/MySQL-Error.jpg\",\"datePublished\":\"2015-05-15T05:36:50+00:00\",\"dateModified\":\"2021-02-09T12:14:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#primaryimage\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2014\/12\/MySQL-Error.jpg\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2014\/12\/MySQL-Error.jpg\",\"width\":372,\"height\":136},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cpanelplesk.com\/wp62\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to check MySQL process list on a cPanel server:\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/\",\"name\":\"cPanel Plesk\",\"description\":\"Blog on famous hosting control panels\",\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\",\"name\":\"Farooq Omer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"width\":300,\"height\":44,\"caption\":\"Farooq Omer\"},\"logo\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\",\"name\":\"Seemab Saleem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"caption\":\"Seemab Saleem\"},\"description\":\"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!\",\"sameAs\":[\"https:\/\/cpanelplesk.com\/wp62\"],\"url\":\"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to check MySQL process list on a cPanel server: - cPanel Plesk","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/","twitter_card":"summary_large_image","twitter_title":"How to check MySQL process list on a cPanel server: - cPanel Plesk","twitter_description":"From cPanel server we can check MySQL process list with the different ways.As we all know for most of\u00a0the production servers it is necessary to check MySQL process list for monitoring the currently running\u00a0queries and to discovering queries that slow down the website loading speed. [...]Continue Reading...","twitter_image":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2014\/12\/MySQL-Error.jpg","twitter_misc":{"Written by":"Seemab Saleem","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#article","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/"},"author":{"name":"Seemab Saleem","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648"},"headline":"How to check MySQL process list on a cPanel server:","datePublished":"2015-05-15T05:36:50+00:00","dateModified":"2021-02-09T12:14:58+00:00","mainEntityOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/"},"wordCount":214,"commentCount":0,"publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"image":{"@id":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#primaryimage"},"thumbnailUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2014\/12\/MySQL-Error.jpg","articleSection":["Cpanel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/","url":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/","name":"How to check MySQL process list on a cPanel server: - cPanel Plesk","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#primaryimage"},"image":{"@id":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#primaryimage"},"thumbnailUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2014\/12\/MySQL-Error.jpg","datePublished":"2015-05-15T05:36:50+00:00","dateModified":"2021-02-09T12:14:58+00:00","breadcrumb":{"@id":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#primaryimage","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2014\/12\/MySQL-Error.jpg","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2014\/12\/MySQL-Error.jpg","width":372,"height":136},{"@type":"BreadcrumbList","@id":"https:\/\/cpanelplesk.com\/wp62\/how-to-check-mysql-process-list-on-a-cpanel-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cpanelplesk.com\/wp62\/"},{"@type":"ListItem","position":2,"name":"How to check MySQL process list on a cPanel server:"}]},{"@type":"WebSite","@id":"https:\/\/cpanelplesk.com\/wp62\/#website","url":"https:\/\/cpanelplesk.com\/wp62\/","name":"cPanel Plesk","description":"Blog on famous hosting control panels","publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13","name":"Farooq Omer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","width":300,"height":44,"caption":"Farooq Omer"},"logo":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/"}},{"@type":"Person","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648","name":"Seemab Saleem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","caption":"Seemab Saleem"},"description":"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!","sameAs":["https:\/\/cpanelplesk.com\/wp62"],"url":"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/"}]}},"_links":{"self":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/2036","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/comments?post=2036"}],"version-history":[{"count":0,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/2036\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media\/1031"}],"wp:attachment":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media?parent=2036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/categories?post=2036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/tags?post=2036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}