Re: InnoDB CPU Spikes

[Sabari girish Viswanathan]

Experts,

I am still stuck with the same problem infact even with a simple query the CPU spikes here is the results

mysql> select count(*) from tblAuditLog where pkAuditLogId>418584199 and pkAuditLogId<422352023;
+----------+
| count(*) |
+----------+
| 1883911 |
+----------+
1 row in set (3.94 sec)

mysql> explain select count(*) from tblAuditLog where pkAuditLogId>418584199 and pkAuditLogId<422352023;
+----+-------------+-------------+-------+---------------+---------+---------+------+---------+--------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------------+-------+---------------+---------+---------+------+---------+--------------------------+
| 1 | SIMPLE | tblAuditLog | range | PRIMARY | PRIMARY | 8 | NULL | 1881720 | Using where; Using index |
+----+-------------+-------------+-------+---------------+---------+---------+------+---------+--------------------------+
1 row in set (0.00 sec)



Please guide