From: Jan Steinman Date: October 6 2011 11:48pm Subject: Re: 4 minute slow on select count(*) from table - myisam type List-Archive: http://lists.mysql.com/mysql/225951 Message-Id: <57474A58-D81C-4B72-8152-413AAF9AC21C@Bytesmiths.com> MIME-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable > From: Joey L >=20 > 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 ::::