Skip navigation links

MySQL Forums :: Performance :: Tuning headaches and questions


Advanced Search

Re: Tuning headaches and questions
Posted by: Rick James ()
Date: June 20, 2012 09:11AM

> open_files_limit 300510
Good. The OS is not limiting you.

> table_open_cache 150000
decrease

> innodb_open_files 300
increase

> key_buffer_size 8388608
--> 1G

> query_cache_size 536870912
--> 100M

Options: ReplyQuote


Subject Views Written By Posted
Tuning headaches and questions 988 Chad Gladue 06/17/2012 06:47AM
Re: Tuning headaches and questions 528 Rick James 06/18/2012 07:59AM
Re: Tuning headaches and questions 578 Chad Gladue 06/18/2012 08:45AM
Re: Tuning headaches and questions 464 Rick James 06/19/2012 08:27AM
Re: Tuning headaches and questions 619 Chad Gladue 06/19/2012 08:38AM
Re: Tuning headaches and questions 468 Rick James 06/20/2012 09:11AM
Re: Tuning headaches and questions 411 Aftab Khan 06/22/2012 01:26AM


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.