Bug #11531 | Strange slowness for indexed search | ||
---|---|---|---|
Submitted: | 23 Jun 2005 15:29 | Modified: | 18 Aug 2006 13:52 |
Reporter: | Name Withheld | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S2 (Serious) |
Version: | 4.1.12 | OS: | MacOS (Mac) |
Assigned to: | CPU Architecture: | Any |
[23 Jun 2005 15:29]
Name Withheld
[23 Jun 2005 16:49]
Name Withheld
most of the 'test4' database
Attachment: test4_rest.zip (application/zip, text), 143.72 KiB.
[23 Jun 2005 16:50]
Name Withheld
the 'terms.MYI' file for the 'test4' database
Attachment: test4_index.zip (application/zip, text), 168.53 KiB.
[23 Jun 2005 17:04]
Name Withheld
Sorry; my 'test1' database was larger than your 200Kb upload limit. So I've attached a smaller database, 'test4', with only 12,500 rows of data, spread across two zipfiles. After further testing, it seems like the Mac slowness may be intermittent. If you can't reproduce it, try calling "FLUSH TABLES", then repeat the test.
[25 Jul 2006 10:41]
Sveta Smirnova
Thank you for the report. I have following result using your test data and last 4.1.22 BK sources: Mac with index: 0.24 sec Mac without index: 0.11 sec Windows with index: 0.14 sec Windows without index: 0.11 sec It looks like problem has solved. Could you please check this using your full loaded table and if not reopen the bug?
[18 Aug 2006 13:52]
Name Withheld
As you requested, I've tested this with 4.1.21 and my full loaded table. The problem is gone.