Recommended MySQL Query Cache size

With 1Mb ram vps server, I have MySQL Query Cache configured to 16mb.
Is it advisable to increment it to 32Mb?

Fz

interesting discussion — simple to google this topic

http://haydenjames.io/mysql-query-cache-size-performance/

Thanks for the link. Quality info on that site!

🙂
be sure to raise the default memory for WP in your wp-functions.php file if you had not already done so. Default is 40MB, and should be at least 96MB (I do 256MB).

I had raised it to 64Mb to get “green” on Newsmag system status.
With 1Mb ram, is it okay to raise it to 96Mb?

Not sure if this is the same thing your trying to do. I added the code below to wp-config.php in WordPress directory and it shows ‘WP Memory Limit GREEN 256 MB/request’.

/** Memory Limit */
define(‘WP_MEMORY_LIMIT’, ‘256M’);

To clarify, two things at work with increasing memory limit on a hosting account

a) memory limit allocated to PHP on the server, set at server level such as php.ini — any hosting company that allows WordPress should allow up to 64MB for php — with a VPN or dedicated server you may need to make that setting yourself by changing the defaults to higher than (in some cases default as low as 16MB!)

b) WordPress limit — WP defaults to 40MB max, even if you change the default on server. So, the setting in wp-config.php will raise the default max RAM for WordPress. 40MB is too low to use Visual Composer and all the modern plugins. 64MB is better, 96MB advisable; higher depends on your hosting account/setup “allowance.” (e.g., if you have VPN or dedicated server, 256MB is advisable; very high traffic sites, perhaps more).

Not sure anybody “needed” to know that, but easy to get confused on these. 🙂

I am on Azure from Microsoft with Standard VM, which is dedicated by there definition. That is why that worked for me. The only thing I can’t figure out because they don’t have CPanel, and they got their own kind of dashboard is, I can’t change the Max_Input_Vars from 1000 to 5000. I changed on the php.ini, but it did not change. I am using Bitnami on a VM. So there is probably no way to change it.

As for memory limit though. I did not or have had any problems since I put it to 256 mb.

Not sure if that is for me since I use Ubuntu VM not Windows server VM, because I have to do stuff for my website via putty or filezilla. What I saw was Windows server kind of information, and I am not using that. I rather use Ubuntu because Azure forces SQL server database that only works about only have of plugins on WordPress, that is why I went to Ubuntu in first place for MySQL. I wouldn’t even have BuddyPress or bbPress on my website if I used Windows server. I have to have node.js installed in where the VM is and I don’t want to fiddle with that.

The reason I don’t like Azure in the first place is I have to do way more work for a website through them than using Cpanel, but I can’t afford hosting right now. I have to deal with using Azure until I can figure something out until I get some other hosting for my website. I am lazy for certain things. That is why I took the VM way on Azure instead of using their Websites that forces SQL database and or pay out of pocket for MySQL database usage through their websites instead of VM. VM is easy to install, but only controllable with settings with Putty. I can use FileZilla, but just for uploading and changing code in the files already there.

• This reply was modified 11 years by doucare1971.

Don’t worry about that Max_Imput_Vars for me. I am doing fine with it set at 1000 anyways. The way subcategories mega menu is done with theme it keeps me from having too many items anyways.