Bug #25176 Trying to set ndb_autoincrement_prefetch_sz always

• Submitted: 19 Dec 2006 13:35
• Modified: 14 Dec 2007 21:59
• Reporter: Hartmut Holzgraefe
• Status: Closed
• Category: Server: Cluster
• Severity: S3 (Non-critical)
• Version: 5.0bk, 5.1bk
• OS: Any
• Assigned to: Martin Skold
• Triage: D3 (Medium)

[19 Dec 2006 13:35] Hartmut Holzgraefe

Description:
No matter what value i try to set ndb_autoincrement_prefetch_sz to, 
the value it shows afterwards is always 1.

How to repeat:
mysql> show variables like 'ndb_autoincrement_prefetch_sz';
+-------------------------------+-------+
| Variable_name                 | Value |
+-------------------------------+-------+
| ndb_autoincrement_prefetch_sz | 32    | 
+-------------------------------+-------+
1 row in set (0.00 sec)

mysql> set local auto_increment_increment = 32;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'ndb_autoincrement_prefetch_sz';
+-------------------------------+-------+
| Variable_name                 | Value |
+-------------------------------+-------+
| ndb_autoincrement_prefetch_sz | 32    | 
+-------------------------------+-------+
1 row in set (0.00 sec)

[19 Dec 2006 18:53] Hartmut Holzgraefe

mysqltest test case

Attachment: bug25176.tgz (application/x-gtar, text), 822 bytes.

[3 May 2007 14:20] Tomas Ulin

since you're working in that area

[14 Dec 2007 17:08] Bugs System

Pushed into 5.1.23-rc

[14 Dec 2007 17:09] Bugs System

Pushed into 5.0.56

[14 Dec 2007 17:10] Bugs System

Pushed into 6.0.5-alpha

[14 Dec 2007 21:59] Jon Stephens

Thank you for your bug report. This issue has been committed to our source repository of
that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available
version, including the bug fix. More information about accessing the source trees is
available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bufix in 5.0.56, 5.1.23, and 6.0.5 changelogs.