Bug #28651 | mysql is very very slow | ||
---|---|---|---|
Submitted: | 24 May 2007 11:44 | Modified: | 13 Aug 2007 16:56 |
Reporter: | Guido Kohl | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server | Severity: | S5 (Performance) |
Version: | 5.0.37 | OS: | Solaris (8 Ultra Sparc) |
Assigned to: | CPU Architecture: | Any | |
Tags: | Benchmarc, performance, Solaris 8 |
[24 May 2007 11:44]
Guido Kohl
[24 May 2007 14:36]
Valeriy Kravchuk
Thank you for a problem report. Please, send your my.cnffile content. Have you tried to check system load with vmstat/sar during testing?
[24 May 2007 15:41]
Guido Kohl
mysql config-file
Attachment: my.cnf.txt (text/plain), 18.18 KiB.
[24 May 2007 15:42]
Guido Kohl
Thank you for your answer. I checked the system with top during testing. The iowait jumps from 0% to over 4%, and the process has never more than 49% CPU. The my.cnf is in the attachment. Thanks a lot, Guido Kohl
[25 May 2007 7:11]
Guido Kohl
screenshot of top and vmstat during testing
Attachment: top_vmstat.doc (application/octet-stream, text), 60.00 KiB.
[13 Jul 2007 16:56]
Valeriy Kravchuk
Please, try to repeat with a newer version, 5.0.45. In case of the same problem, please, describe you SUN hardware and send that SQL that runs fast on Informix and slow on MySQL.
[13 Aug 2007 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".