Topic on Project:Support desk

My instance is (suddenly?) _extremely_ slow

9
Andrey22221 (talkcontribs)

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.

88.130.79.121 (talkcontribs)

I have called your wiki. I do not get a 504 timeout displayed by the server. Instead, it seems to be ready kind of immediately. However, the result is a blank page. This points to a PHP error. See blank page for how to get the actual error message.

What does it say?

88.130.79.121 (talkcontribs)

Oh, I just noticed: What I see in your wiki actually is not a PHP error. In fact the white page is not generated by MediaWiki at all.

What I see there is a correct HTML document (which is an empty page). It has head and body and inside it uses some JavaScript to redirect visitors to a sedoparking domain.

So this is not a PHP error, but some kind of misconfiguration with the folder wiki/ at least.

Andrey22221 (talkcontribs)

just copied it back to index.php just to make it easier

Andrey22221 (talkcontribs)

I have temporary renamed the .php file, current URL is rusefi.com/wiki/tempwiki.php

I've actually made some progress: I believe php is hanging on start_session invocation which is a popular place to hang up

88.130.79.121 (talkcontribs)

Your wiki is sometimes working correctly, e.g. I could see the Special:Version page, the Main Page and its history. However, a second later the same pages show an error 500.

These errors are logged in the server configuration - ask your host, what the exact error message is.

Andrey22221 (talkcontribs)

I currently have two instances - the one you are hitting is 1and1.com with pretty much non-existent support. I cannot change much there.

the other instance where I have SSH and debug_log does not have a public domain yet. You can hit the instance where I have much more troubleshooting options if you change your hosts file:

108.167.160.48 rusefi.com

In my Update #2 I am seeing my non-public instance constantly hang up on session_start() invocation

Thank you for your patience and help so far!

Andrey22221 (talkcontribs)

I've just fixed it! I've followed the recipe from http://stackoverflow.com/questions/26754108/mediawiki-1-22-session-storage

$wgSessionsInObjectCache = true; # MW internal session cache management                                 # takes precedence over PHP management $wgSessionCacheType = CACHE_DB; # See documentation for other backends $wgObjectCacheSessionExpiry = 3600; # Default lifetime of the sessions

and hanging issue is gone! wiki is still pretty slow and it's probably time to look into performance, but at least it's functional now!

(the 500 internal server error seems to be a different issue, that's some CGI limitation and the reason I am probably moving away from 1and1.com)

87.123.54.137 (talkcontribs)
Reply to "My instance is (suddenly?) _extremely_ slow"