MySQL Forums
Forum List  »  Performance

Re: how to optimize MySQL 4.0.24-log on 10 mbps pnet
Posted by: Daniel Nichter
Date: May 26, 2005 07:07AM

Slow queries are going to affect performance more than anything else. I would add:
log-slow-queries
long_query_time = 5

under the [mysqld] section of /etc/my.cnf (and restart MySQL). Fix all the queries you can that get logged. Out of the box, MySQL itself runs well for most setups. The real effort is making your usage, code, database design, etc. optimal.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to optimize MySQL 4.0.24-log on 10 mbps pnet
1523
May 26, 2005 07:07AM


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.