Cause for webserver problems found

After two weeks without problems, I’m now confident that I have found and fixed the cause for the webserver problems on 25 and 26 September.

Two security plugins for WordPress were the offenders, “Acunetix WP Security” and “Ultimate Security Checker”. After the last update, the first one began to carelessly make many long-running database queries. Meanwhile, the second one had inflated WordPress’ crucial wp_options table over the course of time. I guess a webserver which is no longer online after a database crash is kind of secure…

This shows that some functionality that might be beneficial for a website with 1000 page views per day can be disastrous for a website with 100,000. Apart from deleting the two plugins, I worked on the website backend during the last two weeks to further increase its performance.

Increased update schedule

Good news, everyone! Gaia will be updated every Tuesday and Friday (instead of the current 2 – 1 – 2 – 1 cycle) from 1 October until at least 31 December.

Ongoing webserver problems

Unfortunately, the webserver issues are more severe than I thought. There might be a problem that some script running on the website requires too many resources. Therefore I have deactivated all WordPress plugins and the comment section. It will take a while until all features will be activated again since increasing the stability of the webserver is now the most important goal.

Comments from yesterday gone

The webserver running had a serious storage malfunction and was offline for a couple of hours because of it. All your comments made after Tuesday, 24 September 2013, 01:30 CET, are gone. My latest database backup is exactly two hours older so there is nothing I can do to bring them back. I think my webhost Hosteurope handled the issue well. A technician had a look at the defect server although it’s 1 o’clock after midnight here in Germany.

Sketch of Lilith and another wizard

Since there is no new Gaia page this Friday, I decided to post this sketch of Lilith and another young female wizard:

Sketch of Lilith and another wizard