[MDEV-11821] Adaptive hash index partitions is documented twice Created: 2017-01-16 Updated: 2017-06-05 Resolved: 2017-06-05 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Documentation |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Michaël de groot | Assignee: | Ian Gilfillan |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Hi, Adaptive hash index partitions are documented twice:
Some questions arise: |
| Comments |
| Comment by Ian Gilfillan [ 2017-02-01 ] | ||||||||||||||||||||||||||||||||
|
As far as the documentation goes, it's accurate, as they have two different names, and one is the Percona XtraDB implementation, and the other MySQL 5.7's. I may eventually merge them depending on what happens in later versions of 10.2 XtraDB. As far as the internals and whether the MySQL bug also applies, I don't know, so will leave this for someone else to investigate. | ||||||||||||||||||||||||||||||||
| Comment by Michaël de groot [ 2017-05-25 ] | ||||||||||||||||||||||||||||||||
|
Great that you are investigating this! I've seen quite often that people have contention in adaptive hash index mutexes. In the PS meeting there were some thoughts of disabling it as a precaution, because the benefit may not weigh up against the contention. After fixing this we may want to benchmark it's benefits/drawback and reevaluate. | ||||||||||||||||||||||||||||||||
| Comment by Elena Stepanova [ 2017-06-02 ] | ||||||||||||||||||||||||||||||||
|
If you use INFORMATION_SCHEMA.SYSTEM_VARIABLES on 10.2, it will tell you the whole story.
For the second question, about an upstream bug report, it's unrelated to the reported documentation question, so if there anything to do about it, please create a separate bug report. However, please note that whether it applies to 5.5 (or to anything below 10.2) has become rather theoretical question after 10.2 became GA. | ||||||||||||||||||||||||||||||||
| Comment by Elena Stepanova [ 2017-06-02 ] | ||||||||||||||||||||||||||||||||
|
greenman, do you think it's worth mentioning in the description that in 10.2 one is an alias for another? | ||||||||||||||||||||||||||||||||
| Comment by Ian Gilfillan [ 2017-06-05 ] | ||||||||||||||||||||||||||||||||
|
This was documented, and now that 10.2 is stable and the one set as an alias of other there should be no further changes. Will close this documentation bug - the upstream issue can be reported separately. |