./mysqltuner.pl çıktım bu arkadaşlar.
>> MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
>> 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.5.34-cll
[!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 64M (Tables: 319)
[--] Data in InnoDB tables: 3M (Tables: 88)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 5
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 11h 4m 39s (11M q [277.394 qps], 25K conn, TX: 12B, RX: 2B)
[--] Reads / Writes: 96% / 4%
[--] Total buffers: 560.0M global + 2.7M per thread (300 max threads)
[OK] Maximum possible memory usage: 1.3G (33% of installed RAM)
[OK] Slow queries: 0% (0/11M)
[OK] Highest usage of available connections: 24% (73/300)
[OK] Key buffer size / total MyISAM indexes: 16.0K/7.7M
[OK] Key buffer hit rate: 95.9% (11B cached / 481M reads)
[OK] Query cache efficiency: 87.5% (9M cached / 10M selects)
[!!] Query cache prunes per day: 116226
[OK] Sorts requiring temporary tables: 0% (13K temp sorts / 3M sorts)
[!!] Joins performed without indexes: 1047
[OK] Temporary tables created on disk: 0% (8K on disk / 1M total)
[OK] Thread cache hit rate: 86% (3K created / 25K connections)
[!!] Table cache hit rate: 0% (4 open / 5M opened)
[OK] Open file limit used: 0% (8/1K)
[OK] Table locks acquired immediately: 99% (7M immediate / 7M locks)
[OK] InnoDB data size / buffer pool: 4.0M/512.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Adjust your join queries to always utilize indexes
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
query_cache_size (> 8M)
join_buffer_size (> 2.0M, or always use indexes with joins)
table_cache (> 4)
/etc/my.cnf'um ise bu;
[mysql]
no-auto-rehash
[mysqld]
key_buffer_size=16K
thread_stack=128K
socket="/var/lib/mysql/mysql.sock"
skip-networking
tmp_table_size=24M
max_heap_table_size=24M
join_buffer_size=2M
query_cache_size=8M
port=3306
skip-external-locking
max_connections=300
sort_buffer_size=64K
innodb_buffer_pool_size=512M
read_buffer_size=256K
local-infile=0
read_rnd_buffer_size=256K
thread_cache_size=4
table_cache=6
max_user_connections=300
table_open_cache=4
max_allowed_packet=32M
net_buffer_length=2K
server-id=1
innodb_file_per_table=1
default-storage-engine=MyISAM
[mysqlhotcopy]
interactive-timeout
[client]
socket="/var/lib/mysql/mysql.sock"
port=3306
[mysqldump]
max_allowed_packet=16M
quick
[myisamchk]
key_buffer_size=8M
sort_buffer_size=8M
Sunucu'da Cpanel var. Rica ediyorum bi uzman arkadaş görüş belirtebilir mi my.cnf ayarlarım hakkında? Ne yapmalıyım?