MySQL uses different type of threads for running specific utilities like mysql_install_db, flushes MyISAM tables, Replication, TCP/IP sockets etc. All threads can run with four different priorities like Interrupt, connect, wait and query priorities. Different types of threads are: The main thread : This one is created by MySQL client normally, this will be one … Continue Reading   [Read more...]