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??
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??