Help me with my.cnf

[norival1992]

My VPS
Name:Intel(R) Xeon(R) CPU E3-1240 V2 @ 3.40GHz x2
Speed:1696.286 MHz
Cache:8192 KB
Ram:1GB
Network: 1Gbps

mysqltunner

 >>  MySQLTuner 1.2.0_1 - Major Hayden <[email protected]>
 >>  Bug reports, feature requests, and downloads at [url]http://mysqltuner.com/[/url]
 >>  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.32-cll
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 7M (Tables: 41)
[--] Data in InnoDB tables: 6M (Tables: 71)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 3

-------- Performance Metrics -------------------------------------------------
[--] Up for: 15m 47s (6K q [6.724 qps], 1K conn, TX: 3M, RX: 835K)
[--] Reads / Writes: 82% / 18%
[--] Total buffers: 168.0M global + 2.8M per thread (151 max threads)
[OK] Maximum possible memory usage: 583.2M (56% of installed RAM)
[OK] Slow queries: 0% (0/6K)
[OK] Highest usage of available connections: 13% (20/151)
[OK] Key buffer size / total MyISAM indexes: 8.0M/4.7M
[OK] Key buffer hit rate: 98.1% (29K cached / 565 reads)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 189 sorts)
[OK] Temporary tables created on disk: 10% (22 on disk / 213 total)
[!!] Thread cache is disabled
[OK] Table cache hit rate: 95% (158 open / 165 opened)
[OK] Open file limit used: 13% (135/1K)
[OK] Table locks acquired immediately: 100% (4K immediate / 4K locks)
[OK] InnoDB data size / buffer pool: 6.6M/128.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
    Set thread_cache_size to 4 as a starting value
Variables to adjust:
    query_cache_size (>= 8M)
    thread_cache_size (start at 4)

Please help create the best my.cnf. Thank you very much!

 

[MaestriaNick]

Can you paste the current mysql variables here. That will be helpful to suggest the changes

 

[cPanelMichael]

Hello

It's recommended that MySQL run for at least 24 hours before using the MySQL tuner script for the most accurate results.

Thank you.

 

[thinkbot]

add query cache

query_cache_type = 1
query_cache_size = 30M
query_cache_limit = 1M

and
key_buffer_size = 50M
thread_cache_size = 20

the rest is fine