We can kill the processes with the help of the ‘kill’ command. SHOW PROCESSLIST shows which threads are running. If you have the PROCESS privilege, you can see all threads.
How can I found the process list, and process ids of MySql and kill them ? How do I kill all the processes in. The shutdown process is initiated.
This can occur initiated several ways. For example, a user with the SHUTDOWN privilege can execute a mysqladmin shutdown command. Remember that that linux will share unmodified memory pages between processes , so if your server is freshly started most of that memory would all be shared.
In fact, since mysql is threaded there will only probably be even less memory allocated per thread. However, when you wind up with a really feisty process , the kill command is the way to go. Learn more about Linux through the free “Introduction to Linux ” course from The Linux Foundation and edX.
Every Process in Linux , have a pid. The first process that starts when Linux System is booted is – init process , hence it is assigned a value of ‘1‘ in most of the cases.
It has proven its stability.



