[EMAIL PROTECTED] wrote:
Hi,
There is a problem with CPU utlization when using INNODB. The CPU
utilization goes to 100% in a dual processor solaris box. With the same
setup, myISAM uses only 60% of the CPU.
As I said before, stuff like 'count(*)' queries cannot use an index in
innodb - if you are doing a lot of those type of queries, it will cause
a problem. Others include max(), min() (any aggregate function actually).
http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html
The easiest way to work out what queries are causing the problem is to
enable the slow-log and go through that, 'explain'ing each query and
adding indexes where necessary.
http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
