{"id":3895,"date":"2016-05-12T15:02:14","date_gmt":"2016-05-12T15:02:14","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2016\/05\/12\/show-mysql-processes\/"},"modified":"2021-10-11T16:26:47","modified_gmt":"2021-10-11T20:26:47","slug":"show-mysql-processes","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/","title":{"rendered":"How to Show MySQL Processes"},"content":{"rendered":"<p>If you are running a MySQL database on your <a href=\"https:\/\/www.inmotionhosting.com\/dedicated-servers\">Dedicated Hosting server<\/a>, you may want to see its status in terms of the processes that it is currently running. This will give you an idea of the load on the database server which is important if you have a large database or several databases being served on your server. It is also useful to help pinpoint problems with queries running on the server.<\/p>\n\n\n\n<p>You will need to have <a href=\"\/support\/amp\/obtain-root-access\/\">root access<\/a> to the server in order to use either of these reports.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"jetpack-video-wrapper\"><div class=\"yt-NzMtNP3lQuQ\">\n\t<a class=\"play-video-NzMtNP3lQuQ\" style=\"position: relative; display: flex; flex-wrap: wrap; align-items: center; cursor: pointer;\">\n\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i.ytimg.com\/vi_webp\/NzMtNP3lQuQ\/maxresdefault.webp\" width=\"1280\" height=\"720\" alt=\"How to Show Running MySQL Processes in WHM &amp; cPanel\" style=\"width: 100%; height: auto;\">\n\t\t<span class=\"fa fa-imh-play-circle imh-ds-icon play-circle\" style=\"position: absolute; display:block; font-size:150px; color: #c52228; opacity:0;\"><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><figcaption>Don\u2019t have time to read our full guide on how to show MySQL processes? Watch our walk-through video.<\/figcaption><\/figure>\n\n\n<h2>Using WHM to Show MySQL Processes<\/h2>\n<ol class=\"article_list\">\n<li><a href=\"\/support\/edu\/whm\/log-into-whm\/\">Login to the WHM<\/a><\/li>\n<li><a href=\"\/support\/images\/stories\/mysql-processes\/show-mysqlprocesses-whm.jpg\" rel=\"lightbox-0\"><img decoding=\"async\" class=\"std_ss\" style=\"float: right; margin: 0px 0px 15px 15px;\" src=\"\/support\/images\/stories\/mysql-processes\/show-mysqlprocesses-whm.jpg\" alt=\"Show MySQL processes\" width=\"200\" align=\"right\"><\/a>\n<p>Click on <b>Show MySQL Processes<\/b> in the menu at left.<\/p>\n<div style=\"clear: both;\">\u00a0<\/div>\n<\/li>\n<\/ol>\n<p>You will see table showing the existing processes for your dedicated hosting server. These items are detailed below:<\/p>\n<table class=\"table table-striped\">\n<tbody>\n<tr>\n<th>ID<\/th>\n<td>This is the identification number of the running process<\/td>\n<\/tr>\n<tr>\n<th>User<\/th>\n<td>User running the process in the database<\/td>\n<\/tr>\n<tr>\n<th>DB<\/th>\n<td>Database being used with the process<\/td>\n<\/tr>\n<tr>\n<th>Command<\/th>\n<td>Command currently being executed in the process<\/td>\n<\/tr>\n<tr>\n<th>Time<\/th>\n<td>Time taken by the process<\/td>\n<\/tr>\n<tr>\n<th>state<\/th>\n<td>State of the process<\/td>\n<\/tr>\n<tr>\n<th>Info<\/th>\n<td>Information about the process<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>You can also <a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/kill-mysql-processes-phpmyadmin\/\">kill MySQL processes<\/a>.<\/p>\n<h2>Show MySQL Processes in SSH<\/h2>\n<p>If you are familiar with using MySQL in command line, you can also get the report on running processes there. The following instructions show how to access it. Note that you will need the appropriate access in SSH in order to use the MySQL command for this report.<\/p>\n<ol class=\"article_list\">\n<li><a href=\"\/support\/server\/ssh\/how-to-login-ssh\/\">Login to SSH<\/a>.<\/li>\n<li>Type in <b>MYSQL<\/b> to get into the mysql command line.<\/li>\n<li><a href=\"\/support\/images\/stories\/mysql-processes\/show-process-list-commandline.jpg\" rel=\"lightbox-0\"><img decoding=\"async\" class=\"std_ss\" style=\"float: right; margin: 0px 0px 15px 15px;\" src=\"\/support\/images\/stories\/mysql-processes\/show-process-list-commandline.jpg\" alt=\"Show MySQL processes in command line\" width=\"200\" align=\"right\"><\/a>\n<p>Type <b>show processlist;<\/b> in order to see current processes on the server.<\/p>\n<div style=\"clear: both;\">\u00a0<\/div>\n<\/li>\n<\/ol>\n<p><em><strong>Do you find that you just don\u2019t have the time to manage your servers yourself? Our <a href=\"https:\/\/www.inmotionhosting.com\/vps-hosting\">Managed VPS Hosting<\/a> is the perfect solution.<\/strong><\/em><\/p>","protected":false},"excerpt":{"rendered":"<p>If you are running a MySQL database on your Dedicated Hosting server, you may want to see its status in terms of the processes that it is currently running. This will give you an idea of the load on the database server which is important if you have a large database or several databases being<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/\"> Read More ><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4305],"tags":[],"class_list":["post-3895","post","type-post","status-publish","format-standard","hentry","category-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Show MySQL Processes | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"An important diagnostic used to show the operation of your MySQL server is to see the running processes. This report will show to see the processes in WHM or using the command line.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Show MySQL Processes | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"An important diagnostic used to show the operation of your MySQL server is to see the running processes. This report will show to see the processes in WHM or using the command line.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-12T15:02:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-11T20:26:47+00:00\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b\"},\"headline\":\"How to Show MySQL Processes\",\"datePublished\":\"2016-05-12T15:02:14+00:00\",\"dateModified\":\"2021-10-11T20:26:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/\"},\"wordCount\":315,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"articleSection\":[\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/\",\"name\":\"How to Show MySQL Processes | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"datePublished\":\"2016-05-12T15:02:14+00:00\",\"dateModified\":\"2021-10-11T20:26:47+00:00\",\"description\":\"An important diagnostic used to show the operation of your MySQL server is to see the running processes. This report will show to see the processes in WHM or using the command line.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Show MySQL Processes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/arn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Show MySQL Processes | InMotion Hosting","description":"An important diagnostic used to show the operation of your MySQL server is to see the running processes. This report will show to see the processes in WHM or using the command line.","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:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/","og_locale":"en_US","og_type":"article","og_title":"How to Show MySQL Processes | InMotion Hosting","og_description":"An important diagnostic used to show the operation of your MySQL server is to see the running processes. This report will show to see the processes in WHM or using the command line.","og_url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2016-05-12T15:02:14+00:00","article_modified_time":"2021-10-11T20:26:47+00:00","author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b"},"headline":"How to Show MySQL Processes","datePublished":"2016-05-12T15:02:14+00:00","dateModified":"2021-10-11T20:26:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/"},"wordCount":315,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"articleSection":["Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/","url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/","name":"How to Show MySQL Processes | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"datePublished":"2016-05-12T15:02:14+00:00","dateModified":"2021-10-11T20:26:47+00:00","description":"An important diagnostic used to show the operation of your MySQL server is to see the running processes. This report will show to see the processes in WHM or using the command line.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/show-mysql-processes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Show MySQL Processes"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/arn\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/3895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=3895"}],"version-history":[{"count":4,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/3895\/revisions"}],"predecessor-version":[{"id":89827,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/3895\/revisions\/89827"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=3895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=3895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=3895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}