3 messages in com.mysql.lists.mysqlidentify process that created the con...
FromSent OnAttachments
Rithish Saralaya27 Jul 2006 08:18 
Ravi Prasad LR27 Jul 2006 21:05 
Rithish Saralaya02 Aug 2006 07:50 
Subject:identify process that created the connection
From:Rithish Saralaya (rith@tallysolutions.com)
Date:07/27/2006 08:18:10 AM
List:com.mysql.lists.mysql

Hello people.

Is it possible to find the process that invoked the mysql thread, given a mysql thread id?

We have a web application that runs on Linux-Apache-MySQL-PHP; and I sometimes see numerous mysql threads in sleeping mode when I run mytop. I think the sleeping mysql threads could be due to the fact that some of my web-page(s) have obtained a mysql connection, executed their queries, but have not terminated(and have not released the mysql connection also). If I could know the httpd processes that have created these connections, I would be able to find out the pages that are the culprit.

Regards, Rithish.