MySQL Forums
Forum List  »  Performance

Re: Optimizing the MySQL server performance
Posted by: Daniel Nichter
Date: September 21, 2005 05:41PM

For reference, your SHOW STATUS as a mysqlreport: http://hackmysql.com/bobly.txt

227.41 questions/second, of which 99.26% are INSERT--that's quite a lot. An since it's been up for 12 days, this a pretty accurate average. When you're inserting records, what does mytop say your qps is? Everything else in that report looks good, except maybe for the read ratio which is 0.01, but since you do so few selects relatively, this probably doesn't matter much.

I would comment out:
server-id = 1
in your my.cnf unless you're replicating as this will cause MySQL to write bin logs and since you do so many inserts, MySQL will be spending a lot of time logging these inserts. In another post a few days ago, this turned out to be someone else's performance problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
1867
September 21, 2005 04:29PM
Re: Optimizing the MySQL server performance
1479
September 21, 2005 05:41PM
1388
September 23, 2005 01:59PM
1420
September 27, 2005 09:16AM
1438
September 29, 2005 08:23AM


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.