From: Andrew Moore Date: October 7 2011 12:24am Subject: Re: 4 minute slow on select count(*) from table - myisam type List-Archive: http://lists.mysql.com/mysql/225953 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=000e0cd51dc457401504aeaa77d6 --000e0cd51dc457401504aeaa77d6 Content-Type: text/plain; charset=ISO-8859-1 Glad you got to the bottom of it Joey. On 7 Oct 2011 01:23, "Joey L" 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 wrote: >>> From: Joey L >>> >>> 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=mjh2000@stripped >> >> --000e0cd51dc457401504aeaa77d6--