Thread:Project:Support desk/Very slow MW website, possibly due to database/reply (8)

Hi pal,

1) I have run OPTIMIZE TABLE command on all the tables present in MW database.

2) Also, I have increased "innodb_buffer_pool_size" from 16M to 500M. I have only 1800M physical memory available on my server. Do you think I can give even more memory to mysql considering that Apache also needs a lot of memory?

(Just to give you an idea of load on apache, my website gets about 70 simultaneous active users in peak time according to Google Analytics. And it serves about 50 pages per minute)

3) My MW database is 3200M large. I researched a bit on net and found that according to some calculations, in case of such a large database innodb_buffer_pool_size should be set to around 5000M ... that means I should have about 6000M memory to run both mysql and apache. In comparison, the present amount of memory is merely 1800M... so, apprently, it is lack of memory that is causing website to go down every half an hour.