Query Cache is 22 % fragmented

Databases
1

Hello,

im hosting higher amount of clients on my server, ic ant optimise their mysql queries, so i want to ask for advice on how should i modiffy my mysql config file?

this is the result of the mysql tuning primer script:

QUERY CACHE
Query cache is enabled
Current query_cache_size = 512 M
Current query_cache_used = 129 M
Current query_cache_limit = 512 M
Current Query cache Memory fill ratio = 25.26 %
Current query_cache_min_res_unit = 4 K
Query Cache is 22 % fragmented
Run “FLUSH QUERY CACHE” periodically to defragment the query cache memory
If you have many small queries lower ‘query_cache_min_res_unit’ to reduce fragmentation.
Your query_cache_size seems to be too high.
Perhaps you can use these resources elsewhere
MySQL won’t cache query results that are larger than query_cache_limit in size

2

Not really sure what you’re asking; it is giving you instructions right there in the log.

Run “FLUSH QUERY CACHE” periodically to defragment the query cache memory

and lower your query_cache_size setting a bit.

Pay special attention to this line to help minimize this in the future: If you have many small queries lower ‘query_cache_min_res_unit’ to reduce fragmentation