VServer MySql Optimirung

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