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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
