[MP2] Strange slow MySQL queries

2003-09-08 Thread Erlend Simonsen
I run a site with a few million MySQL requests a day, but I've run into a strange problem which I'm trying to slove. The server is running Apache 2.0.47, mod_perl2-1.99r09, DBI 1.38 and DBD-mysql 2.1026 on a FreeBSD 4.8 machine. About once or twice a day, I get a bunch of slow queries that

Re: [MP2] Strange slow MySQL queries

2003-09-08 Thread Patrick Mulvany
Hi, This looks more like a MySQL problem than a specific MP2 issue. However here are a couple of pointers. All the queries below are updates on the same table this would indicate to me you may be having a locking issue. What you need to do is locate the locking transaction it may be as simple