MySQL Forums
Forum List  »  Performance

Re: InnoDB configuration problem
Posted by: James Day
Date: December 29, 2004 09:12PM

key_buffer_size does not affect InnoDB. You want it large enough for the MySQL mysql database but may not need more if you have no other MyISAM tables. You determine the optimum values for the parameters by experimenting with your specific workload. You might set all fairly low and then set one very high to see what effect it has, then repeat for the others until you know the individual effects of each. Then you can mix and find the best combination.

Options: ReplyQuote


Subject
Views
Written By
Posted
2856
December 26, 2004 08:45PM
Re: InnoDB configuration problem
2038
December 29, 2004 09:12PM
2058
December 31, 2004 01:22AM


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.