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

Hi Lalit,

1) that's good.

2) I read instructions saying that you can set innodb_buffer_pool_size to 70-75% of the available RAM. The value of innodb_buffer_pool_size is definitely high enough, when the complete database (size of the database) fits into it. For example I have a machine on which I have 8GB RAM, so I could use about 6GB for innodb_buffer_pool_size. However, the DB on the machine is 1,3GB, so I actually set it to 2GB.

3) For you that means that seeing your DB you should set innodb_buffer_pool_size to more than 3,2GB. But 80% of your RAM are only 1,4GB (and you still have to take away the memory needed for Apache, if it's running on the same machine). If innodb_buffer_pool_size is too small (like it was way too small), it will cause swapping and poor performance. I think this gap is at least a big part of your problem.

3) Maybe you can try with 1GB and see if more is possible, depending on how much RAM is needed for other programs. However, I have not tested that. Might also be, that for what reason ever, performance might be worse after that (although I do not expect that). Apart from that more RAM would be better. Would always be better. ;-)