Hi guys!
I am analyzing the parameters to optimize one server mysql with configurations :
Ubuntu 12.04
MySQL Community 5.5.32
CPUs 8
memory 16GB
Disks SSD
Server sharing with Apache and PHP
My.cnf (actual)
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
max_connections = 1000
table_cache = 64
thread_concurrency = 10
query_cache_limit = 10M
query_cache_size = 16M
query_cache_type = 2
general_log_file = /var/log/mysql/mysql.log
general_log = 1
log_error = /var/log/mysql/error.log
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 2
long_query_time =2
log-slow-queries =/var/log/mysql/mysql-slow.log
New My.cnf (analyzing this parameter to high performance )
# CACHES AND LIMITS #
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 500
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 10240
# INNODB #
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 256M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 10G
innodb-max-dirty-pages-pct = 75
innodb-read-io-threads = 24
innodb-stats-on-metadata = 0
innodb-thread-concurrency = 0
innodb-write-io-threads = 24
This topic in portuguese too
http://forums.mysql.com/read.php?72,651138,651138#msg-651138
This server are in (Digital Ocean);