Glad you got to the bottom of it Joey.
On 7 Oct 2011 01:23, "Joey L" <mjh2...@gmail.com> 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
> processlist.
>
> I saw the full queries and the main thing was that it was doing a
> query about 20 miles long.
>
> thanks again!!!!
> mjh
>
> On Thu, Oct 6, 2011 at 7:48 PM, Jan Steinman <j...@bytesmiths.com> wrote:
>>> From: Joey L <mjh2...@gmail.com>
>>>
>>> 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=mjh2...@gmail.com
>>
>>
