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 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