Jon,
an update statement is supposed to return the # of rows updated, so the
client must wait for a response, which means the client will wait if you
low_priority your updates. But if they are insert delayed then the
client gets a return immediately. This behavior limits the usefullness
of low
Dathan Vance Pattishall wrote:
log-bin=/var/opt/mysql/db2-binlog
skip-innodb
log-error=/var/opt/mysql/db2-errlog
This is on a separate drive?
yes, the database is the only thing on the high speed RAID. everything
else is on the other drive (also a RAID but only RAID0 with 2 drives).
any ideas
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] On Behalf Of Jon Drukman
> Sent: Thursday, May 13, 2004 3:21 PM
> To: [EMAIL PROTECTED]
> Subject: avoiding "Locked" threads
>
> I've got a very high traffic discussion forum database that is
/var/opt/mysql/db2-errlog
here's a sample of some of the locked threads at the moment:
INSERT INTO MSGPOST VALUES (NULL, '931046', 'leon
is...(SPOILERS)--- |
INSERT INTO MSGPOST VALUES (NULL, '943738', 'All I got is from the
British. It should be the same th |
I
Hi guys,
Do you have any thoughts on how to track down a locked thread/query?
Basically we've had instances where a query locks up and causes a
cascade of locked queries and the db freezes up. By the time it's had
enough of an effect for us to see the symptoms (no new queries run)
there are a bun
First, an update. After waiting a few days for a FULLTEXT index to build on
a 3.23.5* database, I updated the database server to MySQL 4.0.10 on advice
from Sergei Golubchik on this list:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:132146:200302:cdpckkcecgnggcboabda
The index rebuild took 'o
for some reason when things get busy, we get a whole ton of locked threads
(see processlist below...), and at some point when there are enough threads,
the whole thing bogs down to a crawl. EVEN after i kill the process that's
holding it all up, it still stays all stuck up. I've s
