{"id":1014,"date":"2021-07-23T12:43:28","date_gmt":"2021-07-23T12:43:28","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/show-mysql-processes\/"},"modified":"2021-07-23T12:43:28","modified_gmt":"2021-07-23T12:43:28","slug":"show-mysql-processes","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/show-mysql-processes\/","title":{"rendered":"Show MySQL Processes"},"content":{"rendered":"<\/p>\n<div class=\"col-md-9\">\n<div class=\"flex-column flex-md-row article-header\">\n<div id=\"versioned-article-header\">\n<p class=\"valid-version-info\"><em>Valid for versions 82 through the latest version<\/em><\/p>\n<\/div>\n<div id=\"version-select-group\" aria-label=\"select versions\">\n<h4>Version:<\/h4>\n<h4>82<\/h4>\n<\/div><\/div>\n<hr>\n<h2 id=\"overview\">Overview<\/h2>\n<p>This interface lists all of the processes that currently run on any database on your server.<\/p>\n<h2 id=\"process-information\">Process information<\/h2>\n<p>The interface displays this information in the following columns:<\/p>\n<ul>\n<li>\n<p><em>Id<\/em> \u2014 The Process ID.<\/p>\n<ul>\n<li>Linux systems assign a unique process identification number to every process and application.<\/li>\n<\/ul>\n<\/li>\n<li>\n<p><em>User<\/em> \u2014 The user that executed the process on the database.<\/p>\n<\/li>\n<li>\n<p><em>Host<\/em> \u2014 The client\u2019s hostname and the port from which the process executed. For example, <em>Host:0000<\/em><\/p>\n<\/li>\n<li>\n<p><em>db<\/em> \u2014 The database on which the process runs.<\/p>\n<ul>\n<li>This column displays <em>NULL<\/em> if the process does not run on a database.<\/li>\n<\/ul>\n<\/li>\n<li>\n<p><em>Command<\/em> \u2014 The type of command that the system issued to the database.<\/p>\n<ul>\n<li>For more information, read MySQL\u2019s Examining Thread Information documentation.<\/li>\n<\/ul>\n<\/li>\n<li>\n<p><em>Time<\/em> \u2014 The time, in seconds, that the process has remained in its current state.<\/p>\n<\/li>\n<li>\n<p><em>State<\/em> \u2014 The action, state, or event of the process.<\/p>\n<ul>\n<li>This column displays <em>NULL<\/em> for the SHOW PROCESSLIST state.<\/li>\n<li>For more information, read MySQL\u2019s Examining Thread Information documentation.<\/li>\n<\/ul>\n<\/li>\n<li>\n<p><em>Info<\/em> \u2014 The text of the statement that the process currently executes.<\/p>\n<ul>\n<li>If the process does not execute a statement, this column displays <em>NULL<\/em>.<\/li>\n<li>This column may display a statement sent to the server, or an inner statement to execute other statements.<\/li>\n<\/ul>\n<\/li>\n<\/ul><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Valid for versions 82 through the latest version Version: 82 Overview This interface lists all of the processes that currently run on any database on your server. Process information The interface displays this information in the following columns: Id \u2014 The Process ID. Linux systems assign a unique process identification number to every process and &hellip;<\/p>\n","protected":false},"author":1,"featured_media":1015,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/1014"}],"collection":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/comments?post=1014"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/1014\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/1015"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=1014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=1014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=1014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}