[kwlug-disc] mysql behaving badly

[Steven Stillaway]

What do the mysql error logs say?  If they show nothing then restart  
mysql in debug mode and run it again and see what it says.

Once you actually have some errors then you can start looking for a  
solution.

- Steven

On 1-Jun-09, at 11:41 PM, Chris Bruner wrote:

> Is mysql configured the same in all cases?
> Is mysql version the same in all cases?
>
> If a large database is dumped can it import it ok, (ie is it your  
> script or the mysql that's the problem).
>
> Those are the questions I'd be asking.
>
> Insurance Squared Inc. wrote:
>> 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.
>>
>> _______________________________________________
>> kwlug-disc_kwlug.org mailing list
>> kwlug-disc_kwlug.org at kwlug.org
>> http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org
>>
>
>
> _______________________________________________
> kwlug-disc_kwlug.org mailing list
> kwlug-disc_kwlug.org at kwlug.org
> http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://kwlug.org/pipermail/kwlug-disc_kwlug.org/attachments/20090603/3ba228bf/attachment.htm>