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 Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:5.0bk, 5.1bk OS:Any
Assigned to: Martin Skold CPU Architecture:Any
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.