hallo,
ich habe mir ein .sh script runtergeladen(day32.com/MySQL/tuning-primer.sh) der meine mysql config überprüft und mir sagt was ich verbessern kann
jetzt het er folgende Verbesserungen angegeben:
TABLE CACHE
Current table_cache value = 64 tables
You have a total of 171 tables
You have 64 open tables.
Current table_cache hit rate is 10%, while 100% of your table cache is in use
You should probably increase your table_cache
MAX CONNECTIONS
Current max_connections = 100
Current threads_connected = 1
Historic max_used_connections = 3
The number of used connections is 3% of the configured maximum.
You are using less than 10% of your configured max_connections.
Lowering max_connections could help to avoid an over-allocation of memory
See "MEMORY USAGE" section to make sure you are not over-allocating
und das noch:
SLOW QUERIES
The slow query log is NOT enabled.
Current long_query_time = 10 sec.
You have 0 out of 13217 that take longer than 10 sec. to complete
Your long_query_time may be too high, I typically set this under 5 sec.
wie stelle ich jetzt diese 3 warning richtig ein damit es 100%ig gescheit läuft? wäre dankbar über hilfestellungen wie ich das vorallem machen kann
mfg