MySQL process won't leave me alone

RJ2

Registered
Jun 6, 2003
4
0
151
I have a MySQL process that runs non-stop. I can kill it using

mysqladmin kill <id#>

But it returns just moments later under a new ID.


When I do " mysqladmin processlist " it shows the process as Sleeping :

| 6056 | welsh_single | localhost | welsh_single | Sleep | 697

The process eats up a lot of server resources and I have to keep killing it, but for the life of me I can't find out what script is causing this? The odd thing is the user's site is extremely low usage. He run a singles site with less than 20 users.

I've rebooted, but it comes back.

Where can I find the prob??
 

RJ2

Registered
Jun 6, 2003
4
0
151
More of the same. Any help on where I should look? Why would a MySQL process do this?

+-------+-----------------+-----------+--------------+---------+-------+-------+--------
----------+
| Id | User | Host | db | Command | Time | State | Info
|
+-------+-----------------+-----------+--------------+---------+-------+-------+--------
----------+
| 9831 | welsh_single | localhost | welsh_single | Sleep | 12887 | |
|
| 10281 | welsh_single | localhost | welsh_single | Sleep | 14713 | |
|
| 10373 | welsh_single | localhost | welsh_single | Sleep | 7310 | |
|
| 11147 | welsh_single | localhost | welsh_single | Sleep | 12419 | |
|
| 12632 | welsh_single | localhost | welsh_single | Sleep | 7244 | |
|
| 12656 | welsh_single | localhost | welsh_single | Sleep | 7147 | |
|
| 13923 | welsh_single | localhost | welsh_single | Sleep | 3328 | |
|
| 14924 | root | localhost | | Query | 0 | | show pr
ocesslist |
+-------+-----------------+-----------+--------------+---------+-------+-------+--------
----------+

cPanel.net Support Ticket Number: