Lowering MySQL Memory Usage without Restart

From: <ssksanthosh_at_gmail.com>
Date: Fri, 16 Jan 2015 20:33:29 -0800 (PST)
Message-ID: <e136869e-c9d7-4418-9747-5f7b438e47c5_at_googlegroups.com>



Hello,
We are using Percona Server 5.5.35-rel33.0-611.precise with InnoDB in our production server. Recently Mysql memory went high and it did't drop from there. We are afraid whether it would result in OOM sooner. We would like know whether mysql memory can be freed with out doing a restart

we tried RESET QUERY CACHE but it didn't help

We came across this post http://serverfault.com/questions/238...ear-the-buffer where it says we can use

innodb_max_dirty_pages_pct=0;

to clear the buffer. We would like to know whether its safe to use in Prodution enviorment( no data loss) ?

Does it clear the clear memory ?

does it require a mysql restart ?

Please advise

thanks,
Santhosh Received on Sat Jan 17 2015 - 05:33:29 CET

Original text of this message