Guys - I wanted to thank you all very much for your help!!!!
I found the offending code on the website !!!!!
thank you very very very much...
what did it for me was a combination of show processlist and show full
I saw the full queries and the main thing was that it was doing a
query about 20 miles long.
On Thu, Oct 6, 2011 at 7:48 PM, Jan Steinman <Jan@stripped> wrote:
>> From: Joey L <mjh2000@stripped>
>> i did google search - myisam is faster...i am not really doing any
>> transaction stuff.
> That's true for read-only. But if you have a mix of reads and writes, MYISAM locks
> tables during writes, which could be blocking reads.
> In a museum in Havana, there are two skulls of Christopher Columbus; one when he was
> a boy and one when he was a man. -- Mark Twain
> :::: Jan Steinman, EcoReality Co-op ::::
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1