I set up my MediaWiki on a CentOS. In the first few months, it works fine and fast. But it seems gradually getting slower.
My wiki site has less than 50 pages, so it's a very small scale site. But it seems every first time when loading the page, it takes couple seconds for apache server to parse the php scripts. But the second time visit same page is instant since I configured MediaWiki's caching method as CACHE_ALL. I've also installed eAccelerator.
How to resolve this performance issue? Thanks.
EDIT: DB is MySQL.
Use squid/varnish. If you don't want to go through that, you could always enable the file cache in MediaWiki.
This might not be correct in your case. But, typically the answer to this question for a database application is that the database needs vacuumed, optimized or some such as is appropriate for the database in question. From what I can find it looks like mysql has an
OPTIMIZE TABLE
command. I'd look into that.