MySQL Forums
Forum List  »  Performance

How Many Sort merge passes per day is too much?
Posted by: dbv
Date: August 23, 2005 10:17PM

In order to allow as many simultaneous connections as possible, I am trying to lower the per-connection variable sort_buffer_size as much as possible while making sure that the "Sort merge passes" statistic doesn't increase too much. I was wondering how big this stat can increase every day which is reasonable such that the sort buffer doesn't need to be raised. I am using 4.1.12 Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
How Many Sort merge passes per day is too much?
2546
dbv
August 23, 2005 10:17PM


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.