Troubleshooting Memory and Networking Issues
I've just amended the settings for my node as recommended here in the Troubleshooting Memory and Networking Issues guide
Now, not always, but quite frequently response and load times are quite slow.
I dont have massive sites, just a couple of them with traffic on one 5000 a day and the other 3000+.
Sites are running on wordpress and also use W3 Total Cache.
I suspect it could be due to MySQL Low-Memory Settings, but as I am not an expert in this area I am not sure.
Could you please help out? Maybe recommend higher settings for Apache or MySQL?
Thank you in advance.
Dmitri
2 Replies
> key_buffer = 16K
Don't use it, or MySQL will scan full table on each query.
Set this value to RAM*25% (128M at Linode 512, for example).
Do you currently have memory issues? Just following that recommendations without reasons can raise more issues.
> table_cache = 4
sort_buffer = 64K
This settings can kill performance too.
Also you can read my comment about tuning here
All the best,
Dmitri