Trouble with mysql query and processlist
I am having trouble with MySQL processlist. I have a query which is a bit slow in nature. I takes around 90 seconds for it to execute. The trouble is, when I look into MySQL processlist, it shows 2 instances for the same query as processes. Initially, the query is treated as a single process. But after some time, say 30-40 seconds, when I refresh the process list, I could see another process created for the same query. There is absolutely no problem with the back end code. The code is written to execute the query only once.
Trouble with mysql query and processlist
===

I am having trouble with MySQL processlist. I have a query which is a bit slow in nature. I takes around 90 seconds for it to execute. The trouble is, when I look into MySQL processlist, it shows 2 instances for the same query as processes. Initially, the query is treated as a single process. But after some time, say 30-40 seconds, when I refresh the process list, I could see another process created for the same query. There is absolutely no problem with the back end code. The code is written to execute the query only once.