Bug #20352 Make ibuf_contract_for_n_pages tunable
Submitted: 9 Jun 2006 9:43 Modified: 21 Jun 2010 13:20
Reporter: Heikki Tuuri Email Updates:
Status: Closed Impact on me:
None 
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:joro@sun.com-20100505145753-ivlt4hclbrjy8eye) (version source revid:vasil.dimov@oracle.com-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:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (pib:16)
[28 May 2010 6:23] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100524190941-nuudpx60if25wsvx) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[28 May 2010 6:51] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100524185725-c8k5q7v60i5nix3t) (version source revid:vasil.dimov@oracle.com-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:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-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:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:vasil.dimov@oracle.com-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:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-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