Re: Unable to analyse thread level information in MySQL server

[Afaque Ahmad Siddiqui]

Thank you very much James,

I have studied about the performance schema but that can not solve my problem.
Yes,I agree with you "Each connection directly uses only one thread ".My question is "does only that one thread(connection thread) is responsible for complete processing of query also? or any extra worker thread involve to process the query?if so,how many extra threads can work as worker threads? "

Actually I need complete sequence diagram to trace all the server threads.
I need to know a complete sequence of query flow like what are the thread involving to process a query.