MySQL Forums :: InnoDB :: Need help to improve innodb performance


Advanced Search

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

Options: ReplyQuote


Subject Views Written By Posted
Need help to improve innodb performance 5034 Song Wang 03/28/2009 10:10AM
Re: Need help to improve innodb performance 2736 Rick James 03/29/2009 11:00PM
Re: Need help to improve innodb performance 2507 Song Wang 03/30/2009 10:17PM
Re: Need help to improve innodb performance 2499 Rick James 03/31/2009 12:20AM
Re: Need help to improve innodb performance 3096 Song Wang 04/02/2009 01:22AM
Re: Need help to improve innodb performance 2277 Song Wang 04/02/2009 01:28AM
Re: Need help to improve innodb performance 2325 Aftab Khan 04/02/2009 10:19AM
Re: Need help to improve innodb performance 5621 Phoenix Kiula 04/17/2009 03:50PM
Re: Need help to improve innodb performance 2635 Rick James 04/17/2009 10:00PM
Re: Need help to improve innodb performance 2606 Phoenix Kiula 04/17/2009 11:26PM
Re: Need help to improve innodb performance 2395 Rick James 04/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.