Bug #36600 SHOW STATUS takes a lot of CPU in buf_get_latched_pages_number
Submitted: 8 May 2008 19:20 Modified: 25 Sep 17:20
Reporter: Mark Callaghan
Status: Closed
Category:Server: InnoDB Severity:S1 (Critical)
Version:5.0, 5.1 OS:Any
Assigned to: Timothy Smith Target Version:5.0+
Tags: STATUS, show, performance, innodb
Triage: D2 (Serious)

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-36600.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[19 May 2008 17:40] Vasil Dimov 
patch for 5.0 that removes the offending variable from SHOW STATUS

Attachment: bug36600-5.0.diff (application/octet-stream, text), 5.01 KiB.
[25 Sep 16:48] Anh Nguyen 
'show innodb status' output

Attachment: status.out (application/octet-stream, text), 127.85 KiB.
[25 Sep 17:08] Anh Nguyen 
my.cnf

Attachment: my.cnf (application/octet-stream, text), 1.59 KiB.