From: Rik Wasmus
Date: October 6 2011 2:09pm
Subject: Re: 4 minute slow on select count(*) from table - myisam type
List-Archive: http://lists.mysql.com/mysql/225936
Message-Id: <201110061609.41420.rik@grib.nl>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit

> thanks for the response - but do not believe queries are the issue
> because - Like I said - i have other websites doing the same exact
> queries as I am doing on the site with the 9gig table.

Contrary to popular believe, size DOES matter... And having a table large 
enough so it doesn't fit in memory could require another approach entirely for 	
query optimization.

Another good start would be to examine the output of mysqlreport, it will tel 
you a lot.
-- 
Rik Wasmus