If all your queries are on columns that are indexed (query by key),
then all your data for your query may actually fit into cache. If you
are only pulling data from a "key" field, then MySQL doesn't need to
actually access the whole table, just the index.
You usually see high disk usage when you
On Mon, Jun 21, 2004 at 06:57:51PM +0200, Leonardo Francalanci wrote:
> I'm doing some tests on a 16.000.000 rows table.
> Doing a simple "SELECT SUM(MYFIELD) FROM MYTABLE" I noticed
> that disks are at 0.1%, while cpu arrives up to 80%.
> How is that possible? My HDs are IDE. MySql has around
> 30
