Home MySQL query cache settings and high RAM ussage
Reply: 0

MySQL query cache settings and high RAM ussage

R3ason
1#
R3ason Published in 2018-02-14 17:08:59Z

Hello I have server with 120 GB of RAM and I have only 16 GB free. I think it's because of bad configuration of cache in my database. I'm getting information that ratio of free query cache memory to total query cache size is 11.9% and it should be around 80%. My current settings:

query_cache_size = 16777216
query_cache_limit = 1048576
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.422674 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO