Bug #38209 Partitioning becomes CPU-bound as number of partitions grows beyond 20
| Submitted: | 17 Jul 2008 17:13 | Modified: | 6 Aug 2008 9:00 |
|---|---|---|---|
| Reporter: | Eric Jensen | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Partitions | Severity: | S5 (Performance) |
| Version: | 5.1.25 | OS: | Linux (x86_64) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | partitioning, performance | ||
[17 Jul 2008 17:13]
Eric Jensen
[31 Jul 2008 17:44]
Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newr version, 5.1.26, and, in case of the same problem, send exact CREATE TABLE statement for the problematic table.
[4 Aug 2008 17:31]
Eric Jensen
It's fairly time-consuming for me to recreate my test environment with 5.1.26 instead of 5.1.25. Are there some specific fixes you think would have influenced this? You can find my full environment (my.cnf, etc.) in http://bugs.mysql.com/?id=38205
[5 Aug 2008 8:37]
Susanne Ebrecht
In my eyes this is a duplicate of bug #37252. Do you agree with me?
[5 Aug 2008 13:59]
Eric Jensen
If the metadata from this bug was migrated to 37252, i.e. that this happens with 10's of partitions and not just 100's, then they would be duplicates, yes.
[6 Aug 2008 9:00]
Susanne Ebrecht
Ok, I will set this bug as duplicate of bug #37252. I added a comment to the other bug report.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.042 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.