Bug #27271 | Repeating a query slows it down | ||
---|---|---|---|
Submitted: | 19 Mar 2007 18:38 | Modified: | 25 Mar 2007 13:23 |
Reporter: | [ name withheld ] | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: General | Severity: | S3 (Non-critical) |
Version: | 5.0.32-Debian_7-log | OS: | Linux (Debian Etch 64bit) |
Assigned to: | CPU Architecture: | Any | |
Tags: | repeat, slow down |
[19 Mar 2007 18:38]
[ name withheld ]
[19 Mar 2007 18:40]
[ name withheld ]
Table-Dump
Attachment: test2.zip (application/x-zip-compressed, text), 111.23 KiB.
[19 Mar 2007 19:40]
Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.3/5.0.37, and inform about the results.
[21 Mar 2007 12:03]
[ name withheld ]
I tested again: deactivating the raid did NOT help. I also tried a 32bit-Debian installation, but it didn't help. Only one thing changed now: Only every second query gets slow now: * Query 0: 0.04s * Query 1: 2.46s * Query 2: 0.04s * Query 3: 4.46s * Query 4: 0.04s * Query 5: 8.15s * Query 6: 0.04s * Query 7: 14.90s * Query 8: 0.04s * Query 9: 27.21s Looks like i have to put some more effort into installing 5.0.37
[21 Mar 2007 12:34]
Valeriy Kravchuk
Yes, please, try to repeat with 5.0.37 and inform about the results. In case of the same problem send also your my.cnf file content.
[25 Mar 2007 13:23]
[ name withheld ]
Changing from cross-over to switched connection solved this issue - no bug, sorry.