Hi friends
How i must modify my /etc/my.conf???
My machine is:
Intel Core 2 Quad CPU 2.6 GHz
8 Gb RAM
actually my /etc/my.conf is this:
cat /etc/my.cnf
[mysqld]
set-variable = max_connections=500
query_cache_type=1
query_cache_size=64M
table_cache=5000
safe-show-database
local-infile=0
>> 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.0.92-community
[!!] 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: 363M (Tables: 6254)
[--] Data in InnoDB tables: 12M (Tables: 135)
[--] Data in MEMORY tables: 0B (Tables: 1)
[!!] Total fragmented tables: 435
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 6h 58m 20s (263K q [10.486 qps], 12K conn, TX: 609M, RX: 44M)
[--] Reads / Writes: 63% / 37%
[--] Total buffers: 98.0M global + 2.7M per thread (500 max threads)
[OK] Maximum possible memory usage: 1.4G (18% of installed RAM)
[OK] Slow queries: 0% (2/263K)
[OK] Highest usage of available connections: 1% (9/500)
[OK] Key buffer size / total MyISAM indexes: 8.0M/136.9M
[OK] Key buffer hit rate: 99.2% (1M cached / 11K reads)
[OK] Query cache efficiency: 84.4% (164K cached / 194K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts)
[!!] Joins performed without indexes: 258
[OK] Temporary tables created on disk: 14% (1K on disk / 7K total)
[!!] Thread cache is disabled
[OK] Table cache hit rate: 37% (4K open / 13K opened)
[!!] Open file limit used: 92% (9K/10K)
[OK] Table locks acquired immediately: 99% (72K immediate / 72K locks)
[!!] InnoDB data size / buffer pool: 12.9M/8.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
Set thread_cache_size to 4 as a starting value
Variables to adjust:
join_buffer_size (> 128.0K, or always use indexes with joins)
thread_cache_size (start at 4)
open_files_limit (> 10510)
innodb_buffer_pool_size (>= 12M)
this is my mysqltuner.pl output
How i must modify my /etc/my.conf???
My machine is:
Intel Core 2 Quad CPU 2.6 GHz
8 Gb RAM
actually my /etc/my.conf is this:
cat /etc/my.cnf
[mysqld]
set-variable = max_connections=500
query_cache_type=1
query_cache_size=64M
table_cache=5000
safe-show-database
local-infile=0
>> 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.0.92-community
[!!] 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: 363M (Tables: 6254)
[--] Data in InnoDB tables: 12M (Tables: 135)
[--] Data in MEMORY tables: 0B (Tables: 1)
[!!] Total fragmented tables: 435
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 6h 58m 20s (263K q [10.486 qps], 12K conn, TX: 609M, RX: 44M)
[--] Reads / Writes: 63% / 37%
[--] Total buffers: 98.0M global + 2.7M per thread (500 max threads)
[OK] Maximum possible memory usage: 1.4G (18% of installed RAM)
[OK] Slow queries: 0% (2/263K)
[OK] Highest usage of available connections: 1% (9/500)
[OK] Key buffer size / total MyISAM indexes: 8.0M/136.9M
[OK] Key buffer hit rate: 99.2% (1M cached / 11K reads)
[OK] Query cache efficiency: 84.4% (164K cached / 194K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts)
[!!] Joins performed without indexes: 258
[OK] Temporary tables created on disk: 14% (1K on disk / 7K total)
[!!] Thread cache is disabled
[OK] Table cache hit rate: 37% (4K open / 13K opened)
[!!] Open file limit used: 92% (9K/10K)
[OK] Table locks acquired immediately: 99% (72K immediate / 72K locks)
[!!] InnoDB data size / buffer pool: 12.9M/8.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
Set thread_cache_size to 4 as a starting value
Variables to adjust:
join_buffer_size (> 128.0K, or always use indexes with joins)
thread_cache_size (start at 4)
open_files_limit (> 10510)
innodb_buffer_pool_size (>= 12M)