14,959
edits
Linux commands: Difference between revisions
Jump to navigation
Jump to search
→Show the MySQL process list & kill the process
| Line 153: | Line 153: | ||
=== Show the MySQL process list & kill the process === | === Show the MySQL process list & kill the process === | ||
Show the MySQL process list & kill the process<ref>[http://dev.mysql.com/doc/refman/5.1/en/show-processlist.html MySQL :: MySQL 5.1 Reference Manual :: 13.7.5.31 SHOW PROCESSLIST Syntax]</ref> | Show the MySQL process list & kill the process (especial for SLOW query command)<ref>[http://dev.mysql.com/doc/refman/5.1/en/show-processlist.html MySQL :: MySQL 5.1 Reference Manual :: 13.7.5.31 SHOW PROCESSLIST Syntax]</ref> | ||
# {{kbd | key=mysql -h HOST -u ACCOUNT -p }} And keyin the PASSWORD for your MySQL ACCOUNT to connect the MySQL server. | # {{kbd | key=mysql -h HOST -u ACCOUNT -p }} And keyin the PASSWORD for your MySQL ACCOUNT to connect the MySQL server. | ||
# {{kbd | key=SHOW FULL PROCESSLIST\G}} to show the process list | # {{kbd | key=SHOW FULL PROCESSLIST\G}} to show the process list | ||