innodb_ibuf_active_contract shows up in 5.5.22 even though the changelog says it was renamed to innodb_ibuf_active_merge

Bug #997619 reported by Jay Janssen
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
High
Hrvoje Matijakovic
5.5
Fix Released
High
Hrvoje Matijakovic

Bug Description

The doc says it should be innodb_ibuf_active_merge:

http://www.percona.com/doc/percona-server/5.5/scalability/innodb_insert_buffer.html

and that it defaults to '0'. However, I have this server:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 417422
Server version: 5.5.22-55 Percona Server (GPL), Release rel25.2, Revision 237

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show variables like 'innodb_ibuf%';
+-----------------------------+-------------+
| Variable_name | Value |
+-----------------------------+-------------+
| innodb_ibuf_accel_rate | 100 |
| innodb_ibuf_active_contract | 1 |
| innodb_ibuf_max_size | 53687009280 |
+-----------------------------+-------------+
3 rows in set (0.00 sec)

where it is named innodb_ibuf_active_contract and apparently defaulting to 1.

The changelog is the only place I could find mention of innodb_ibuf_active_contract:

http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.8-20.0.html

Tags: doc

Related branches

Revision history for this message
Alexey Kopytov (akopytov) wrote :

Yes, the variable name is innodb_ibuf_active_contract, it was never renamed to *_merge, and its default value is 1.

So technically the fix for bug #695906 was incomplete. But, since we can't rename it now in a stable release, we should update docs and release notes instead.

Changed in percona-server:
status: New → Confirmed
tags: added: doc
Changed in percona-server:
assignee: nobody → Hrvoje Matijakovic (hrvojem)
Changed in percona-server:
status: Confirmed → In Progress
Changed in percona-server:
status: In Progress → Fix Committed
Revision history for this message
Volans (volans) wrote :

The documentation in the "Configurable Insert Buffer" ( http://www.percona.com/doc/percona-server/5.5/scalability/innodb_insert_buffer.html ) page is mixed, for the "innodb_ibuf_accel_rate" variable only the name is correct, in the variable description is always used the "innodb_ibuf_merge_rate" name.

Revision history for this message
Alexey Kopytov (akopytov) wrote :

Yes, so the fix for this bug was incomplete. I'm reopening the bug. Thanks for letting us know!

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-555

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.