Thread:Project:Support desk/Mediawiki database size problem/reply

Hi!

No, generally such a size is not a problem. MySQL and PHP can handle that. However, you might want to make certain settings especially in MySQL to keep things running fast.

For example the objectcache table contains only temporary data. You can manually purge this table, so that it is empty again. After that the objectcache needs some time until it is filled again. However, when a row in that table has expired, it should normally be removed from the table automatically. Is this not the case for you?

Another thing I notice: Your DB without the cache is 200MB of size. The cache is 1.2GB - this ratio does not seem very efficient. Is the cache used properly at all? To me it seems like hundreds of rows might just be inserted, but never again used - and instead new rows are being inserted. Things are cached, but MediaWiki might for some reason think, that they are not reusable so that pages are rendered uncached again and again.