MySQL FAQs

From Hostek.com Wiki
Revision as of 22:44, 12 December 2012 by Jakeh (Talk | contribs) (Created page with "==How do I see all running processes in MySQL?== #Open up a command prompt on your server #Log into MySQL with this command: <pre>mysql -u root -p</pre> #Enter your root MySQL...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

How do I see all running processes in MySQL?

  1. Open up a command prompt on your server
  2. Log into MySQL with this command: 
    mysql -u root -p
  3. Enter your root MySQL password when prompted
  4. Issue this command: 
    SHOW FULL PROCESSLIST\G

MySQL will display a full list of running processes along with the state of the query and the SQL being ran at that time.

Retrieved from "https://wiki.hostek.com/index.php?title=MySQL_FAQs&oldid=1028"