Understand Query Processing Basic Before tuning your slow query, you better understand how your database process your query first. Here are the steps: Each client connections gets its own thread within the server process (MySQL). The connetion’s queries execute within that single thread, which in turn resides on one core or CPU. The database server [...]