The MySQL + PHP mode often causes a large number of zombie processes in MySQL under high concurrency pressure, resulting in service downtime. In order to automatically kill these processes, a script is created and automatically executed on the
1 seconds to kill business analysis
Normal e-business process
(1) Inquiry goods, (2) Create Order, (3) deduct inventory, (4) Update order, (5) payment, (6) Seller issue
The characteristics of the second kill business
(1) Low price, (2) Large
Batch kill SQL statements that run for a long time in mysql, killmysql
KILL syntax
KILL [CONNECTION | QUERY] thread_idEach connection to mysqld runs in an independent thread. You can use the show processlist statement to check which threads are
Linux kill usage, killall, pkill, and xkill
Linux kill usage, killall, pkill, and xkill
1. Kill, killall, pkill, and xkill tools for terminating Processes
Terminate a process or terminate a running program, usually through kill, killall, pkill,
Kill syntax
KILL [CONNECTION | QUERY] thread_idEach connection to the mysqld runs in a separate thread, and you can use the show Processlist statement to see which threads are running and terminate a thread with the kill thread_id statement.
Kill
The following is from the MySQL manual:13.5.5.3. Kill syntaxKILL [CONNECTION | QUERY] thread_idEach connection to the mysqld is run in a separate thread, and you can use the show Processlist statement to see which threads are running and terminate a
The following is from the MySQL manual:13.5.5.3. Kill syntaxKILL [CONNECTION | QUERY] thread_idEach connection to the mysqld is run in a separate thread, and you can use the show Processlist statement to see which threads are running and terminate a
1. kill, killall, pkill, and xkill tools for terminating Processes Terminate a process or terminate a running program, usually through kill, killall, pkill, xkill, etc. For example, if a program is dead but cannot exit, you should consider using
Turn from: think-run long sql in bulk kill MySQLThe following is from the MySQL manual:13.5.5.3. Kill syntaxKILL [CONNECTION | QUERY] thread_idEach connection to the mysqld is run in a separate thread, and you can use the show Processlist statement
The following is from the MySQL manual:13.5.5.3. Kill syntaxKILL [CONNECTION | QUERY] thread_idEach connection to the mysqld is run in a separate thread, and you can use the show Processlist statement to see which threads are running and terminate a
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.