MediaWiki 1.22.2 I believe
PHP 5.4.45 see http://rusefi.com/info.php5
Database MySQL
TL,DR: after two years my instance is suddenly giving me "gateway timeout" 95% of the times, Once in a while one page would be displayed. Copying the same instance and ~600MB backup to another hosting altogether has showed me ONE page ONCE and once I've clicked on a link I am getting gateway timeout at the new hosting location as well. How do I go from here?
I have installed my instance at 1and1 shared hosting about two years ago. My instance has that huge internalization plugin (full list of extensions - http://i.imgur.com/m49hmLa.png )
I believe the whole wiki is maybe a couple hundred pages, I am actually surprised by the database size - maybe there awe more attachments that I thought, it's for a not so big open source project, about 200 sessions a day on both wiki and forum.
Everything was simply great until a week ago - I've never maintained the instance in any way. I do not have command line access to this hosting, only FTP and myPhpAdmin. A week ago the whole site (both wiki and phpbb forum) started showing 500 and in a couple of hours it availability has really went down - see http://i.imgur.com/yoLInDK.png
1and1.com has very limited technical support but they've mentioned something about CGI limit and up-sold me to the next hosting package, which has completely healed the forum but the wiki was still pretty much down. Please keep reading, sorry for too much text :)
I've decided to move hosting. I've created a ~600MB backup on the wiki database only, and copied all the wiki scripts and wiki data into another virtual hoster with much better reviews, ehost.com
I was really surprised when my freshly-copied instance on the new hosting with a freshly restored 600MB backup has shown me the title page ONCE and then went into 'gateway timeout'. With new hosting I have slightly better control - I have port 3306 remote access and maybe even SSH access, need to confirm that.
Here is a picture of my table sizes. I am pretty surprised how big the database is, http://i.imgur.com/FyeKDHh.png I've assumed my instance barely has any info in it.
I am an embedded software developer so some IT background but no idea how to troubleshoot PHP or MySQL.
Update 1: I've requested wiki page in browser, it's waiting/hanging, went into myPhpAdmin to run "SHOW FULL PROCESSLIST" and I do not see any database queries running
Update 2: got ssh, got debug logs. The last message before hanging is
[cookie] session_set_cookie_params: "0", "/", "", "", "1"
And then silence.