1GB ram, LAMP, just one wordpress site using classipress theme with over 30k ads and lot of content, with mysql db 500+ mb large, always about 15-30 visitors on site at every moment (looking at google analitics live preview), sometimes more.
Now, website is working, but pages are loading slow, sometimes very fast, and other times it takes 20+ seconds to open a page, and sometimes a blank page is open.
I run free -m when page is loading slow and get something like this:
total used free shared buffers cached Mem: 1001 919 82 21 42 553 -/+ buffers/cache: 323 678 Swap: 1023 31 992
if I understand right, this means I have 678 mb free. Then what is the problem why are pages loading so slow most of the times ?
Some of the settings I have:
keep alive - OFF
<IfModule mpm_prefork_module> StartServers 2 MinSpareServers 2 MaxSpareServers 5 MaxRequestWorkers 10 MaxRequestsPerChild 0 </IfModule>
in my.cnf
key_buffer = 64M max_allowed_packet = 1M thread_stack = 64K thread_cache_size = 8 myisam-recover = BACKUP table_cache = 8 query_cache_limit = 1M query_cache_size = 16M
in error.log i have errors like
Maximum execution time of 30 seconds exceeded in… and sometimes pages open blank, nothing there…
and also
server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting, but I tried that and it did not worked.
Any help would be appreciated!
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
You should turn on keep alive.
Your database is quite big consider using cache plugin to your wordpress.
You should also considering separate web and database. order 2 x 512MB droplet then put your web in droplet A then database in droplet B.
Anybody any ideas please