Всем привет, есть мощный сервер и под него было решено отдать mysql, но как правильно сконфигурировать не знаю
подскажите как настроить на максимальную производительность для innodb
какие надо сделать настройки чтобы максимально использовать процессоры и память
Dell PowerEdge R610
12 CPUs x 3.33 GHz Intel Xeon CPU X5680 @ 3.33 GHz
96GB RAM
OS Ubuntu 12.10
Server version: 5.5.29-55-log Percona XtraDB Cluster (GPL), wsrep_23.7.2.r3843
* /usr/bin/mysqladmin Ver 8.42 Distrib 5.5.29, for Linux on x86_64
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Server version 5.5.29-55-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 1 hour 30 min 57 sec
root@ubuntu:~# uname -a
Linux ubuntu 3.5.0-17-generic #28-Ubuntu SMP Tue Oct 9 19:31:23 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
сейчас my.cnf такой, но я понимаю, что он далеко не самый лучший
root@ubuntu:~/storage# cat /etc/mysql/my.cnf
[mysqld]
#bind-address = 10.0.10.225
# default-character-set = utf8
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
# paths
datadir = /storage/mysql
tmpdir = /tmp/mysql
# network
connect_timeout = 60
wait_timeout = 28800
max_connections = 2048
max_allowed_packet = 64M
max_connect_errors = 1000
# limits
tmp_table_size = 512M
max_heap_table_size = 256M
table_cache = 512
# logs
log_error = /storage/mysql/log-error.log
slow_query_log_file = /storage/mysql/log-slow.log
slow_query_log = 1
long_query_time = 20
# innodb
innodb_file_per_table = 1
innodb_data_home_dir = /storage/mysql
innodb_data_file_path = ibdata1:128M;ibdata2:128M:autoextend:max:4096M
innodb_file_per_table = 1
innodb_status_file = 1
innodb_additional_mem_pool_size = 128M
innodb_buffer_pool_size = 64G
innodb_flush_method = O_DIRECT
innodb_io_capacity = 2000
innodb_flush_log_at_trx_commit = 2
innodb_support_xa = 0
innodb_log_file_size = 512M
innodb_log_buffer_size = 128M
# experimental
innodb_stats_update_need_lock = 0
# other stuff
event_scheduler = 1
query_cache_type = 0
Отредактированно maxjoin (16.04.2013 22:24:46)
