15,039
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
→Show the MySQL process list & kill the process
| Line 77: | Line 77: | ||
# {{kbd | key=mysql -h HOST -u ACCOUNT -p }} | # {{kbd | key=mysql -h HOST -u ACCOUNT -p }} | ||
# And keyin the PASSWORD of your MySQL ACCOUNT. The first character will be changed to ''mysql>'' from ''$'' or ''#'' | # And keyin the PASSWORD of your MySQL ACCOUNT. The first character will be changed to ''mysql>'' from ''$'' or ''#'' | ||
# mysql> {{kbd | key=SHOW FULL PROCESSLIST\G}} to show the process list | # mysql> | ||
#* {{kbd | key=SHOW FULL PROCESSLIST\G}} to show the process list | |||
#* {{kbd | key=SHOW PROCESSLIST\G}} to show the brief process list | |||
# mysql> {{kbd | key=kill 101;}} to kill the process with Id number: 101 | # mysql> {{kbd | key=kill 101;}} to kill the process with Id number: 101 | ||
# mysql> {{kbd | key=exit;}} to leave the MySQL command. | # mysql> {{kbd | key=exit;}} to leave the MySQL command. | ||
=== Troubleshooting of MySQL === | === Troubleshooting of MySQL === | ||