my.cnf

[wayward]

Hola.

Tengo mi web alojada en un VPS de 1&1 AMD Opteron y 4 gb de Ram.

Me gustaria saber si la configuracion que he creado para mysql es correcta.

Tengo 5 web en dicho VPS Wordpress, que todas comparten la misma base de datos.

Muchas gracias.

Código MySQL:

[mysqld]
max_connections=500
 
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
# Forced OLD_PASSWORD format is turned OFF by Plesk
#old_passwords=1
 
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
 
#skip-bdb
 
thread_cache_size = 16K
low_priority_updates=1
concurrent_insert=ALWAYS
query-cache-type = 1
query_cache_size = 128M
query_cache_limit = 148M
table_cache = 500
table_open_cache = 96
table_cache = 1K
table_definition_cache = 4K
open_files_limit = 3K
key_buffer = 64M
innodb_buffer_pool_size= 96M
innodb_additional_mem_pool_size= 96M
innodb_log_buffer_size= 96M
innodb_thread_concurrency=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
long_query_time = 5