MySQL Forums
Forum List  »  Install & Repo

Configuring and Optimizing Performance with SSD
Posted by: Emerson Martins Da Silva
Date: October 06, 2016 08:52AM

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);

Options: ReplyQuote


Subject
Written By
Posted
Configuring and Optimizing Performance with SSD
October 06, 2016 08:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.