Стояла Mysql 5.1 и результат такой
Обновил до 5.5 и после на PerconaDB и стало так:
Конфиг:
Обновил до 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 |