14,959
edits
Linux commands: Difference between revisions
Jump to navigation
Jump to search
m
→Show the MySQL process list & kill the process
(→import MySql sql file: add --default_character_set utf8 --force) |
|||
| Line 162: | Line 162: | ||
=== Show the MySQL process list & kill the process === | === Show the MySQL process list & kill the process === | ||
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> | 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. The first character will be changed to ''mysql>'' from ''$'' or ''#'' | ||
# {{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=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. | |||
== system operation == | == system operation == | ||