MySQL Forums
Forum List  »  Performance

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
2234
June 17, 2012 06:47AM
1115
June 18, 2012 08:45AM
1210
June 19, 2012 08:38AM
Re: Tuning headaches and questions
814
June 20, 2012 09:11AM


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.