Hi All, this document deals with how to check the number of threads connected to MySQL.
Mysql is a single process application which supports multithreading. For each and every connections a thread is created in MySQL server. Thread gets destroy once the operation is done in MySQL server which leads to closing the connection to MySQL server.
you can use SHOW PROCESSLIST command in MySQL to see about what’s going on in your SQL server.
This is the sample output of the above command.
Use the below command to see how many threads are connected. This will be very useful when you undergo with the performance test.
© 2018, Techrunnr. All rights reserved.