Стояла Mysql 5.1 и результат такой
Обновил до 5.5 и после на PerconaDB и стало так:
Конфиг:
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld_safe]
nice = 0
socket = /var/lib/mysql/mysql.sock
[mysqld]
# Basic mysql server configuration
user = mysql
port = 3306
basedir = /usr
datadir = /var/mysql
socket = /var/lib/mysql/mysql.sock
skip-external-locking
default-storage-engine = innodb
pid_file = /var/run/mysql/mysql.pid
transaction-isolation = READ-COMMITTED
max_allowed_packet = 128M
myisam-recover = BACKUP
expire_logs_days = 10
max_binlog_size = 512M
# Cache parameters
query_cache_size = 128M
table_open_cache = 4096
thread_cache_size = 32
key_buffer = 64M
thread_stack = 512K
join_buffer_size = 16M
sort_buffer_size = 16M
# Parameters for temporary tables
tmpdir = /var/tmp
max_heap_table_size = 128M
tmp_table_size = 512M
# InnoDB parameters
innodb_file_per_table
innodb_buffer_pool_size = 128M
innodb_log_file_size = 512M
innodb_flush_method = O_DIRECT
innodb_data_home_dir = /var/mysql/
innodb_log_group_home_dir = /var/mysql/
innodb_flush_log_at_trx_commit = 0
# Database charset parameters
character-set-server = utf8
collation-server = utf8_unicode_ci
skip-character-set-client-handshake
skip-name-resolve
Простой
