[kwlug-disc] mysql behaving badly

Insurance Squared Inc. gcooke at insurancesquared.com
Mon Jun 1 18:52:01 EDT 2009


I've got a script that's importing pages into a wordpress (website) 
database.  The script is not behaving consistently and the culprit seems 
to be mysql.  The inconsistency is what's puzzling.  I've experienced 
the same consistent inconsistency across two machines now.

For example I imported 6 blocks of 500 pages each without any problem.  
It imported and ran fast.  Then I deleted the database and recreated it 
(due to unrelated issues).  I then imported 2 of the same blocks again 
and it was dead slow importing each page.  The third block I imported, 
the script output looked like it barfed the mysql database all over my 
terminal session :).  Restarting mysql regularly doesn't seem to fix it.

I have noticed that it will tend to die earlier and earlier.  i.e. if it 
dies on page 100 and I don't restart mysql but delete the pages and 
start again, it'll die on page 97 next time, then page 92 if I try it 
again, and so on.  That's as consistent as I've got.  It seems to die at 
different places even if I try to keep inputs the same.

Any ideas what would cause mysql to do this? Perhaps something's not 
getting flushed or a cache?  I did the last run on my desktop so there 
really wasn't much else running on the machine.    Our developer spent 
2-3 days and decided that mysql was timing out (I don't think so :) ) 
and this seems to be so vague that Google doesn't even know where to start.


g.



More information about the kwlug-disc_kwlug.org mailing list