Bug #61689 How to get improved performance in MySQL-v5.5?
Submitted: 29 Jun 2011 14:05 Modified: 30 May 2012 12:04
Reporter: satheesh kumar Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S5 (Performance)
Version:5.5.12 OS:Linux
Assigned to: CPU Architecture:Any
Tags: Performance Issue V5.5

[29 Jun 2011 14:05] satheesh kumar
Hi ,
I am working on the MySQL-v5.5 which is named as performance release, but i got degraded performance in the same.I Installed MySQLv5.5 have changed some attributes in my.cnf as follows: *)innodb_buffer_pool_size but its a crap. Would you please let me know is there any other settings has to changed in MySQLv5.5 to acquire good performance…


How to repeat:

*)Install MySQL-v5.1
*)Configure 5,10,15 million backup-data to your server,observer backup time and DB-Transaction time.
*)Install MySQL-v5.5 and increase innodb_buffer_pool_size.
*)Configure 5,10,15 million backup-data to your server,observer backup time and DB-Transaction time.
*)Now compare the observed reading from both versions.
*)Now you could see the performance gets degraded in MySQL-v5.5.
[29 Jun 2011 14:30] Valeriy Kravchuk
What exact version, 5.1.x and 5.5.y, you compared? Please, describe all details of your test or, even better, provide the code to run to see the problem.
[29 Jun 2011 15:16] Valeriy Kravchuk
Please, send my.cnf file content from both 5.1.x and 5.5.12. Describe hardware used to compare performance (how many CPUs/cores do you have etc).
[29 Jun 2011 15:40] satheesh kumar
Hi @Valeriy Kravchuk,
                      I have attached the my.cnf file for both MySQL-v5.1.39 and MySQL-v5.5.12. Hardware Details Used as follows,

*)Server- OS-Centos5.5-64-bit, 4GB RAM, Processor-Core(TM)2Duo[2-cores].

If you need any more clarification please intimate me.we have planned to use MySQL-v5.5.x in our production so it would be useful for us if this issue fixed.

[30 Jun 2011 4:28] satheesh kumar
Hi @Valeriy Kravchuk,
                      Could you please let me know the status of the issue  as soon as possible.

[2 Jul 2011 7:36] satheesh kumar
Hi @Valeriy Kravchuk ,
                         Any update on the issue?.Please,kindly let me know the status.

[3 Jul 2011 17:31] Valeriy Kravchuk
Status of this bug report is still "Open" as you can see. It may hang in this status forever, or may be verified tomorrow by me or somebody else, or maybe somebody will explain the difference in performance that you see, who knows...

This site is the place to report bugs, in a hope that developers or community members will confirm them or prove there is no bug, or give some workaround ideas, eventually. It is not intended to provide you regular feedback or help with the issue.

Looks like you had provided enough information to start testing, but that's all I can tell you for now.
[6 Jul 2011 8:05] satheesh kumar
Hi @Valeriy Kravchuk ,

                        As you mentioned that you will update the status of the issue in one or two days,but yet no suggestion from you  regarding the issue.Please let me the know the status.

[30 Apr 2012 12:04] MySQL Verification Team
Sateesh,  we at least need table structure and some testcase or queries that you run in multiple threads to reproduce the issue.

also notice 5.5.12 is now considered old.  if this is still a problem on 5.5.23 we would like to know more details about your tests.
[1 Jun 2012 1: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".