Glad you got to the bottom of it Joey.
On 7 Oct 2011 01:23, "Joey L" <mjh2000@stripped> wrote:
> 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.
> thanks again!!!!
> 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