innodb_expand_fast_index_creation should be optional
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Undecided
|
Alexey Kopytov | ||
5.1 |
Fix Released
|
Undecided
|
Alexey Kopytov | ||
5.5 |
Fix Released
|
Undecided
|
Alexey Kopytov |
Bug Description
The server-side functionality from innodb_
1. We promise the same behavior as compared to the upstream server unless Percona-specific features are explicitly enabled by corresponding options.
2. Fast index creation may actually be slower than the default method in some cases. (e.g. when the data fits in the buffer pool and the merge buffer is too small, see https:/
3. There are upstream server bugs that make fast index creation inefficient in even more cases, for example https:/
We should have an option controlling whether fast index creation is used, and it should be disabled by default.
Related branches
- Laurynas Biveinis (community): Approve
- Oleg Tsarev (community): Approve
-
Diff: 419 lines (+198/-81)1 file modifiedpatches/innodb_expand_fast_index_creation.patch (+198/-81)
- Laurynas Biveinis (community): Approve
-
Diff: 437 lines (+209/-86)2 files modifiedpatches/innodb_expand_fast_index_creation.patch (+207/-86)
patches/mysql-test.diff (+2/-0)
summary: |
- innod_expand_fast_index_creation should be optional + innodb_expand_fast_index_creation should be optional |
Quoting revision comments for RN and documentation updates:
" expand_ fast_index_ creation. patch disabled by default.
This fix makes all functionality provided by
innodb_
It can be enabled by using a new system variable, expand_ fast_index_ creation, that has both global or session online_ alter_index. patch.
innodb_
scopes, and can also be specified in a configuration file or on the
command line. The variable is of the boolean type and is FALSE by
default. The session value of TRUE enables optimizations and
improvements provided by the patch. The variable also has no effect when
fast index creation is disabled with the fast_index_creation option
provided by control_
"