Re: Tuning headaches and questions
> 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
Subject
Views
Written By
Posted
2832
June 17, 2012 06:47AM
1081
June 18, 2012 07:59AM
1461
June 18, 2012 08:45AM
982
June 19, 2012 08:27AM
1520
June 19, 2012 08:38AM
Re: Tuning headaches and questions
969
June 20, 2012 09:11AM
899
June 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.