MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimal Mysql Configuration (my.cnf)
Posted by: Luiz Cláudio Pinheiro
Date: July 08, 2011 10:28AM

> How much RAM do you have?

My server's configuration:

HDD 2x 500 GB SATA II-HDD 7.200 rpm
RAM 1x 8 GB DDR2-RAM ECC
Barebone 1x Fujitsu PRIMERGY RX200 S4
CPU 2x Intel Xeon DP E5405 Quadcore


If is possible, i wanna know what is the best values to set in this fields with this configuration:

key_buffer

thread_cache
thread_concurrency
thread_stack
read_buffer_size

query_cache_limit
query_cache_size

I've tested many values following many tutorials in the inertnet, but i dont believe that i have an ideal configuration.

Att,
Luiz Cláudio Pinheiro
PHP Programmer

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Optimal Mysql Configuration (my.cnf)
3406
July 08, 2011 10: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.