Bug #20352 Make ibuf_contract_for_n_pages tunable

• Submitted: 9 Jun 2006 9:43
• Modified: 21 Jun 2010 13:20
• Reporter: Heikki Tuuri
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S4 (Feature request)
• Version: 5.2
• OS: Any (All)
• Assigned to: Calvin Sun
• CPU Architecture: Any
• Triage: Triaged: D5 (Feature request)

[9 Jun 2006 9:43] Heikki Tuuri

Description:
Add a my.cnf option for ibuf_contract_for_n_pages

For discussion, see:
http://forums.mysql.com/read.php?22,94338

How to repeat:
N/A

[20 Jun 2006 18:15] Miguel Solorzano

Thank you for the bug report.

[21 Aug 2006 14:01] Heikki Tuuri

Assigning this to Sunny. This is a simple change. We also want to increase the default value since Mark noticed the insert buffer probably performs a lot better with a larger default value.

[12 Jul 2007 18:02] Timothy Smith

Queued to 5.1-maint team tree; however, the option is not configurable from my.cnf, because it requires changes to the plugin API which will not be available in MySQL 5.1.

Putting this back to Verified, awaiting the additional changes which will make this visible to users.

[19 Jul 2007 15:48] Bugs System

Pushed into 5.1.21-beta

[4 Mar 2008 16:04] Heikki Tuuri

This is a feature request.

[5 May 2010 15:13] Bugs System

Pushed into 5.1.47 (revid:[e-mail]-20100505145753-ivlt4hclbrjy8eye) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[6 May 2010 2:15] Paul Dubois

Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug.

Changing back to Need Merge.

[28 May 2010 5:54] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100524190136-egaq7e8zgkwb9aqi) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (pib:16)

[28 May 2010 6:23] Bugs System

Pushed into 6.0.14-alpha (revid:[e-mail]-20100524190941-nuudpx60if25wsvx) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[28 May 2010 6:51] Bugs System

Pushed into 5.5.5-m3 (revid:[e-mail]-20100524185725-c8k5q7v60i5nix3t) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[17 Jun 2010 11:55] Bugs System

Pushed into 5.1.47-ndb-7.0.16 (revid:[e-mail]-20100617114014-bva0dy24yyd67697) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[17 Jun 2010 12:34] Bugs System

Pushed into 5.1.47-ndb-6.2.19 (revid:[e-mail]-20100617115448-idrbic6gbki37h1c) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[17 Jun 2010 13:21] Bugs System

Pushed into 5.1.47-ndb-6.3.35 (revid:[e-mail]-20100617114611-61aqbb52j752y116) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[20 Jun 2010 17:20] Paul Dubois

What was done here? Is this the innodb_io_capacity variable that was added to InnoDB
Plugin?

[21 Jun 2010 6:25] Calvin Sun

Paul - yes, please see my Sep 12, 2009 comments.

[21 Jun 2010 13:20] Paul Dubois

Okay, thanks. This has been documented since 5.1.38 at:

http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_io_capacity