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