MySQL Forums
Forum List  »  Performance

Re: Correctly setting mysql options for a huge DB with intense trafic
Posted by: Rick James
Date: November 28, 2010 10:35PM

When a query has to store more information than will fit into a log file (formerly 5MB), it has to store rollback information with the data; this more costly. By changing to 200MB, medium sized queries will run perhaps twice as fast.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Correctly setting mysql options for a huge DB with intense trafic
1224
November 28, 2010 10:35PM


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.