MySQL Forums
Forum List  »  Portuguese

Configuraçao para Performance com SSD
Posted by: Emerson Martins Da Silva
Date: October 05, 2016 09:19PM

Olá pessoal

Estou fazendo uma análise para otimizar um servidor com as seguintes configurações;


Ubuntu 12.04
MySQL Community 5.5.32
CPU 8
Memoria 16GB
Discos SSD
Compartilhado com Apache e PHP

My.cnf (atual)

max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
max_connections = 100
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

My.cnf (Novo)


# 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

Options: ReplyQuote


Subject
Views
Written By
Posted
Configuraçao para Performance com SSD
1269
October 05, 2016 09:19PM


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.