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:
None 
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
Description:
My MySQL Installation is very very slow on Sun Solaris.
The statement "select benchmark(1000000,1+1);" needs 0.4 seconds, under 
Windows XP the statement needs 0.03 seconds.
Another sql-statement needs in Informix on Solaris 30 seconds, the same 
statement on the same machine with the same datas needs in MySQL 4min!!!

How to repeat:
select benchmark(1000000,1+1);

Suggested fix:
I think this is not a MySQL-problem but a sun-/solaris-problem.
I hope you can help me.
[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".