Bug #25176 Trying to set ndb_autoincrement_prefetch_sz always
Submitted: 19 Dec 2006 14:35 Modified: 14 Dec 2007 22:59
Reporter: Hartmut Holzgraefe
Status: Closed
Category:Server: Cluster Severity:S3 (Non-critical)
Version:5.0bk, 5.1bk OS:Any
Assigned to: Martin Skold Target Version:
Triage: D3 (Medium)

[19 Dec 2006 14: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 19:53] Hartmut Holzgraefe 
mysqltest test case

Attachment: bug25176.tgz (application/x-gtar, text), 822 bytes.
[3 May 2007 16:20] Tomas Ulin 
since you're working in that area
[14 Dec 2007 18:08] Bugs System 
Pushed into 5.1.23-rc
[14 Dec 2007 18:09] Bugs System 
Pushed into 5.0.56
[14 Dec 2007 18:10] Bugs System 
Pushed into 6.0.5-alpha
[14 Dec 2007 22: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.