L. Arnold's picture

Just tried 3 times to set/reset:
query_cache_size:  from 16777216   to 268435456

query_cache_limit:   from   1048576  to 16777216

Whenever I restart MYSQL the Original settings return.

I have read that up to half of Memory available to a Magento Install should be allocated to MySQL and cache.  Running on ESXI and can provide from 1024 to 2056mb for the Application.

I must be missing something...


Update:  Digging into my.cnf --  seems to be the place to set variables more permanently

references:  http://dev.mysql.com/doc/mysql/en/server-system-variables.html

-------- Seemed to Take, but perhaps I don't want such a high number on Limit.  Studying.

Why does not WEBMIN actually save changes of his sort?  I recall the same isse relative to setting InnoDB settings a year ago or so.

Jeremy Davis's picture

But Webmin changes should stick permanently. Not sure why it doesn't!? Generally how Webmin works, is that it makes the changes to the relevant config files (it's just set out a little easier to understand rather than manually editing a file, you can click check boxes etc). So assuming you click the 'save' button (generally at the bottom of the page) it should permanently save the changes to the conf file.

Having said that I often don't use Webmin as I rather learn the intracies of manually configuring the conf files. There are a couple of exceptions, Samba being one of them. Anyway, I haven't used the MySQL Webmin module at all so can't really comment further.

If you are sure that you saved your changes in Webmin and it still didn't stick then I suspect that there is a bug somewhere...

Add new comment