Queria saber la mejor configuracion de mysql5 para un servidor grande.
Las carecteristicas del server son las siguiente:
Procesador: Intel Xeon Quad Core 2.00GHz
Ram: 8 GB
He seguido la optimizacion siguiendo esta URL: http://www.guatewireless.org/mysql-o...to-de-lectura/
Mas o menos mi foro necesita eso, optimizar el rendimiento de lectura, ya que se lee mucho mas, que se postea.
Deje mi my.cnf asi:
Cita:
Tambien tengo alguna duda. En el manual habla de poner el valor sort_buffer_size a 3M. Pero ese valor aparece repetido varias veces. Se refiere a todos? o solo a alguno en especial?[mysqld]
character-set-server = latin1
init-connect='SET NAMES latin1'
default-character-set = latin1
user = mysql
port = 3306
socket = /var/run/mysqld/mysqld.sock
pid-file = /var/run/mysqld/mysqld.pid
log-error = /var/log/mysql/mysqld.err
basedir = /usr
datadir = /var/lib/mysql
skip-locking
key_buffer = 500M
max_allowed_packet = 32M
table_cache = 4000
sort_buffer_size = 3M
net_buffer_length = 8K
read_buffer_size = 3M
thread_cache_size = 8
query_cache_size = 100M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
#long_query_time = 10
#log-slow-queries = /var/log/mysql/mysql-slow.log
max_connections=400
query_cache_type = 1
[mysqldump]
quick
max_allowed_packet = 32M
[mysql]
# uncomment the next directive if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 500M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 500M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
character-set-server = latin1
init-connect='SET NAMES latin1'
default-character-set = latin1
user = mysql
port = 3306
socket = /var/run/mysqld/mysqld.sock
pid-file = /var/run/mysqld/mysqld.pid
log-error = /var/log/mysql/mysqld.err
basedir = /usr
datadir = /var/lib/mysql
skip-locking
key_buffer = 500M
max_allowed_packet = 32M
table_cache = 4000
sort_buffer_size = 3M
net_buffer_length = 8K
read_buffer_size = 3M
thread_cache_size = 8
query_cache_size = 100M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
#long_query_time = 10
#log-slow-queries = /var/log/mysql/mysql-slow.log
max_connections=400
query_cache_type = 1
[mysqldump]
quick
max_allowed_packet = 32M
[mysql]
# uncomment the next directive if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 500M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 500M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
Que diferencia hay entre los valores "isamchk" , "myisamchk" y "mysqld" ? Hay veces como esta que he comentado, que te hablan de un valor, pero aparece repetido, y no se si se modifica en todos o solo en mysqld.
A ver si alguien me echa una mano a optimizar mejor el server.
Gracias