>>>>> "Wari" == Wari Wahab <wari@stripped> writes:
>> Yes I have this problem as well. I use basically the same solution as you.
>> I noticed though that a lot of INSERTS will lockup the system (actually
>> slow it down significantly). Using INSERT DELAYED seems to alleviate the
>> problem because in the latter case only one thread is doing the inserting.
Wari> Hmmm, OK, this is new ;).. But, my problem occurs only when the site is on
Wari> an idle state (3 am or so).. When the site is heavily hit, mysql just
Wari> chugs along... hmm, curioser and curioser..
When you have problems that mysqld hangs, or becomes unresponsible you
should definitely look at the following MySQL entries:
PLEASE read the above before reposting your question, this will save us all
a lot of time! To be able to help you when mysqld is hanging we
usually need enough information to be able to duplicate the problem to
be able to help you!
Sorry for the short answer, but as we get a couple of hundred mails/day
we don't have time to answer questions that are already documented
or doesn't contain all information needed to give a quick exact answer.