[italy-tech] ottimizzazione mysql

[rudolph at bastardi.net]

Buongiorno.
Questo il nostro /etc/my.cnf

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently
parsed.
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /var/tmp
language        = /usr/share/mysql/english
skip-external-locking
default-character-set=utf8 
default-collation=utf8_general_ci 
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1
#


Okkio a questi valori qui:


# * Fine Tuning
#
key_buffer              = 512M
max_allowed_packet      = 32M
thread_stack            = 128K
thread_cache_size       = 384
max_connections        = 200
table_cache            = 3500
max_heap_table_size     = 100000M
tmp_table_size          = 100000M


A me paiono un po esagerati.
Ho guardato qui:
http://2bits.com/articles/mysql-my-cnf-configuration-for-a-large-drupal-site.html

dove consigliano:

key_buffer              = 16M
key_buffer_size         = 32M
max_allowed_packet      = 16M
thread_stack            = 128K
thread_cache_size       = 64
query_cache_limit       = 8M
query_cache_size        = 64M
query_cache_type        = 1
join_buffer_size        = 512K
max_connections         = 150


Mi sembra ci sia una grossa discrepanza.
I valori che abbiamo noi, sono settati con cognizione di causa?