Acabo de realizar una instalación del mysql 5.5 y tengo el my.conf por defecto me gustaría modificarlo para que se ajuste a las características de mi servidor 64bits con un procesador de 8 núcleos con 8GB de ram y las bases de datos son InnoDB.
Tengo aproximadamente 100 usuarios con cierto lag y el servidor esta en uso del 10% del procesador y 20% de memoria me gustaría sacarle mas provecho para mejorar el rendimiento.
que elementos del my.conf debo cambiar y por otra parte creo que tengo desactivado el InnoDB
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
#skip-locking
key_buffer_size=1024M
max_allowed_packet = 8M
table_cache = 64
sort_buffer_size = 2M
net_buffer_length=64
read_buffer_size = 128M
read_rnd_buffer_size = 256M
myisam_sort_buffer_size = 16M
tmp_table_size = 512M
join_buffer_size=512M
#skip-networking
# Disable Federated by default
skip-federated
skip-name-resolve
#skip-external-locking
skip-host-cache
lower_case_table_names=1
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 128M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
# The safe_mysqld script
#The bigger you set this the less disk I/O is needed to access data in tables. On a dedicated database server you may set this parameter up to 80% of the machine physical memory size. Do not set it too large, though, because competition of the physical memory may cause paging in the operating system.
innodb_buffer_pool_size=1024M
#Enter a name for the query log file. Otherwise a default name will be used.
log=/var/lib/mysql/registro/query_log.sql
#Enter a name for the slow query log. Otherwise a default name will be used.
log-slow-queries=/var/lib/mysql/registro/slow_query.sql
#Log all queries that have taken more than long_query_time seconds to execute to file.
long_query_time=10
#Don't log extra information to update and slow-query logs.
log-short-format
Muchas gracias por su ayuda se lo agradezco mucho.
