[lug] MySQL work queue problem

[Sean Reifschneider]

On Mon, Oct 09, 2006 at 12:26:47PM -0600, Jason Vallery wrote:
>just to increment some sort of counter) you can use the "LOW_PRIORITY"
>keyword on the UPDATE statement.  This will cause MySQL to delay the update
>until no clients are reading the table:

I doubt that would have helped here, because the table was pretty
much always being read.  If the load was light enough that there were
frequently times when there wasn't reads, there wouldn't have been a
problem in the first place.

It might have helped, but splitting it off to a different table, that was
read much less frequently and updated the majority of the time, solved it
quite nicely.

Thanks,
Sean
-- 
 I love the smell of napalm in the morning.  It smells like...  Victory.
               -- _Apocalypse_Now_
Sean Reifschneider, Member of Technical Staff <jafo at tummy.com>
tummy.com, ltd. - Linux Consulting since 1995: Ask me about High Availability