MySQL Forums
Forum List  »  General

Re: mysql max_connections
Posted by: Rick James
Date: December 22, 2009 12:37AM

As I read the manual, 5.1.32 should allow a 6GB key_buffer. 4GB will be nearly as good as 6GB, so do not worry about it. How big is the total of the MyISAM index files (.MYI)? If it the total is less than 4GB, the extra space would not be used anyway.

Try setting key_buffer_size = 6G in my.cnf and restart mysql. Perhaps the problem is just with SET.

Options: ReplyQuote


Subject
Written By
Posted
December 11, 2009 01:26AM
December 12, 2009 03:56PM
December 16, 2009 11:59PM
December 17, 2009 12:39AM
December 20, 2009 11:39PM
Re: mysql max_connections
December 22, 2009 12:37AM
December 24, 2009 02:01PM
December 25, 2009 12:49AM
December 25, 2009 03:30AM
December 25, 2009 03:49AM
December 25, 2009 11:12PM


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.