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 30Mb of ram, I thought it should read a lot from disk.
Even doing lots of queries by key I get only high cpu usage, not disk reads. Is that normal? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
