Bug #50621 Increase ndb_autoincrement_prefetch_sz to >256
| Submitted: | 26 Jan 2010 12:49 | Modified: | 28 Jan 2010 9:26 |
|---|---|---|---|
| Reporter: | Johan Andersson | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S3 (Non-critical) |
| Version: | mysql-5.1-telco-6.3 | OS: | Any |
| Assigned to: | Jonas Oreland | CPU Architecture: | Any |
| Tags: | autoincrement | ||
[27 Jan 2010 13:38]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/98336 3094 Jonas Oreland 2010-01-27 ndb - bug#50621 - allow autoincrement prefetch size up to 65536
[27 Jan 2010 13:49]
Jonas Oreland
pushed to 6.3.31 and 7.0.11 increased max to 65536
[28 Jan 2010 9:26]
Jon Stephens
Documented feature change in the NDB-6.3.31 and 7.0.11 changelogs as follows:
The maximum allowed value of the
ndb_autoincrement_prefetch_sz variable has been increased
from 256 to 65536.
Also noted change at http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-system-variables.html#sysvar_ndb_auto....
Closed.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: Max of ndb_autoincrement_prefetch_sz is 256. How to repeat: .. Suggested fix: Changing it to more is trivial: in mysqld.cc: {"ndb-autoincrement-prefetch-sz", OPT_NDB_AUTOINCREMENT_PREFETCH_SZ, "Specify number of autoincrement values that are prefetched.", (uchar**) &global_system_variables.ndb_autoincrement_prefetch_sz, (uchar**) &max_system_variables.ndb_autoincrement_prefetch_sz, 0, GET_ULONG, REQUIRED_ARG, 1, 1, 256, 0, 0, 0}, change to {"ndb-autoincrement-prefetch-sz", OPT_NDB_AUTOINCREMENT_PREFETCH_SZ, "Specify number of autoincrement values that are prefetched.", (uchar**) &global_system_variables.ndb_autoincrement_prefetch_sz, (uchar**) &max_system_variables.ndb_autoincrement_prefetch_sz, 0, GET_ULONG, REQUIRED_ARG, 1, 1, 65535, 0, 0, 0},