Need help to improve innodb performance
Posted by:
Song Wang
Date: March 28, 2009 10:10AM
Hi, experts,
We use MySQL5.0.67, cluster installation, running on a sun-blade server(SUSE, RAM16G, 2CPU*4Core).
Our data model is quite simple, only has several tables with innodb type. But the data volumn is farely large which is about 20G/hour.
We have tuned the normally considerred server variables for innodb engine. Now the problem is the cpu utilization is low and has high i/o wait percentage. Throughput requirement was not fulfilled. We tried to tune the size of client connections, it seems that too many connections harms the performance. We get the best throughtput when having 3-5 concurrent sessions. It's about 3k-4k inserts/sec, while we want 8k-10k inserts/sec.
what we can do to improve performance? Thanks in advanced.
//Song
Subject
Views
Written By
Posted
Need help to improve innodb performance
5884
March 28, 2009 10:10AM
3031
March 29, 2009 11:00PM
2795
March 30, 2009 10:17PM
2725
March 31, 2009 12:20AM
3454
April 02, 2009 01:22AM
2515
April 02, 2009 01:28AM
2602
April 02, 2009 10:19AM
6503
April 17, 2009 03:50PM
3068
April 17, 2009 10:00PM
2960
April 17, 2009 11:26PM
2639
April 18, 2009 05:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.