>> MySQLTuner 1.2.0 - Major Hayden <[email protected]>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.6.17-log
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 4M (Tables: 56)
[--] Data in InnoDB tables: 2M (Tables: 15)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52)
[!!] Total fragmented tables: 16
-------- Performance Metrics -------------------------------------------------
[--] Up for: 17h 0m 33s (40M q [666.503 qps], 6K conn, TX: 27B, RX: 13B)
[--] Reads / Writes: 98% / 2%
[--] Total buffers: 364.0M global + 1.8M per thread (50 max threads)
[OK] Maximum possible memory usage: 451.5M (5% of installed RAM)
[!!] Slow queries: 74% (30M/40M)
[OK] Highest usage of available connections: 62% (31/50)
[OK] Key buffer size / total MyISAM indexes: 14.0M/3.7M
[OK] Key buffer hit rate: 100.0% (773M cached / 12K reads)
[!!] Query cache efficiency: 0.0% (0 cached / 40M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 15M sorts)
[!!] Joins performed without indexes: 9702
[OK] Temporary tables created on disk: 0% (893 on disk / 15M total)
[OK] Thread cache hit rate: 99% (34 created / 6K connections)
[!!] Table cache hit rate: 5% (183 open / 3K opened)
[OK] Open file limit used: 0% (193/234K)
[OK] Table locks acquired immediately: 99% (103M immediate / 103M locks)
[OK] InnoDB data size / buffer pool: 2.0M/310.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Adjust your join queries to always utilize indexes
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
query_cache_limit (> 8M, or use smaller result sets)
join_buffer_size (> 256.0K, or always use indexes with joins)
table_cache (> 2000)
my.cnf
[client]
user = root
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
bind-address = 127.0.0.1
socket = /tmp/mysql.sock
skip-external-locking
key_buffer = 14M
max_connections = 50
thread_concurrency = 4
tmp_table_size = 24M
max_allowed_packet = 1M
max_tmp_tables = 128
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
myisam-recover=backup,force
query_cache_size = 8M
query_cache_limit = 8M
thread_cache_size = 64
default-storage-engine = InnoDB
log-bin=mysql-bin
server-id = 1
innodb_flush_method = O_DIRECT
skip-innodb_doublewrite
innodb_data_home_dir=/var/db/mysql/ibdata
innodb_log_group_home_dir=/var/db/mysql/iblogs
innodb_data_file_path=ibdata1:10M:autoextend
innodb_flush_log_at_trx_commit=2
innodb_buffer_pool_size = 310M
log-short-format
myisam-recover=backup,force
expire_logs_days = 5
log-queries-not-using-indexes
log-warnings
long_query_time = 2
[mysqldump]
quick
max_allowed_packet = 100M
single-transaction
skip-lock-tables
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
--
Vladislav V. Prodan
System & Network Administrator
support.od.ua
