MySQL Forums
Forum List  »  Performance

Re: InnoDB CPU Spikes
Posted by: Sabari girish Viswanathan
Date: March 19, 2009 03:47AM

Create Table
CREATE TABLE `tblAuditLog` (
`pkAuditLogId` bigint(20) NOT NULL AUTO_INCREMENT,
`fldInvokeId` varchar(6) DEFAULT NULL,
`fldCreatedDate` datetime DEFAULT NULL,
`fldDialogId` varchar(6) DEFAULT NULL,
`fldExternalSystemInfo` varchar(80) DEFAULT NULL,
`fldShortCode` varchar(10) DEFAULT NULL,
`fldUSSDRequestTimestamp` datetime DEFAULT NULL,
`fldUSSDResponseTimestamp` datetime DEFAULT NULL,
`fldMsisdnnumber` varchar(14) DEFAULT NULL,
`fldESRequesttimestamp` datetime DEFAULT NULL,
`fldESResponsetimestamp` datetime DEFAULT NULL,
`fldEngineName` varchar(10) DEFAULT NULL,
`fldExternalSystem` varchar(50) DEFAULT NULL,
`fldRegionName` varchar(10) DEFAULT NULL,
`fldResponsetype` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`pkAuditLogId`)
) ENGINE=InnoDB AUTO_INCREMENT=283207068 DEFAULT CHARSET=utf8


--------------------------------
Explain Plan

Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
tblAuditLog InnoDB 10 Compact 18788293 156 2940239872 0 0 0 283207068 2009-01-22 07:51:03 NULL NULL utf8_general_ci NULL


--------------------------------

---
LOG
---
Log sequence number 40 1664215394
Log flushed up to 40 1664215394
Last checkpoint at 40 1664215394
0 pending log writes, 0 pending chkp writes
19598342 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 1148222540; in additional pool allocated 802432
Dictionary memory allocated 231328
Buffer pool size 65536
Free buffers 0
Database pages 65391
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 40967384, created 265954, written 1074092
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout


--------------------------------

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.1.23-rc |
+-----------+
1 row in set (0.00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
7416
March 18, 2009 02:43AM
2750
March 18, 2009 03:08AM
2619
March 18, 2009 08:29PM
2574
March 19, 2009 04:48AM
2728
March 19, 2009 10:46AM
Re: InnoDB CPU Spikes
2503
March 19, 2009 03:47AM
2653
March 19, 2009 03:55AM
2521
March 19, 2009 04:49AM
2492
March 19, 2009 10:20AM
2195
March 30, 2009 01:25AM
2270
March 30, 2009 07:13PM
2295
March 31, 2009 02:31AM
2520
March 31, 2009 08:12AM
2193
April 01, 2009 03:27AM
2243
April 01, 2009 10:01AM
2351
April 01, 2009 10:22AM
2224
April 01, 2009 03:45AM
2507
April 01, 2009 11:57PM
2402
April 06, 2009 01:23AM
2364
April 06, 2009 08:01PM
2145
April 07, 2009 12:14AM
2297
April 08, 2009 04:36PM
2315
April 16, 2009 07:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.