MySQL Forums
Forum List  »  Performance

Re: Help with peculiar DB setup
Posted by: Rick James
Date: January 21, 2009 01:28AM

Configure in my.cnf.

If you are using InnoDB, set innodb_buffer_pool_size = 29000M for a 32GB machine. That's for both data and indexes.

If you are using MyISAM, set key_buffer_size = 4000M (can't go beyond 4GB, even with 64-bit). That's for indexes, not for data; the OS takes care of caching data blocks. Also, be sure to set MAX_ROWS and AVERAGE_ROW_LEN; see docs on CREATE TABLE.

Options: ReplyQuote


Subject
Views
Written By
Posted
3144
January 19, 2009 08:08AM
1548
January 19, 2009 10:28AM
1632
January 19, 2009 12:42PM
Re: Help with peculiar DB setup
1532
January 21, 2009 01:28AM


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.