Re: Lowering MySQL Memory Usage without Restart

Thanks again Axel..

On Saturday, January 17, 2015 at 12:33:33 PM UTC+8, ssksa..._at_gmail.com wrote:
> 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 Sun Jan 18 2015 - 14:54:23 CET