└ posted on Wednesday, 23 October 2013, by Novil
Some of you may miss the comment rating system. But I have decided to not reactivate it yet, because it definitely costs some performance and I don’t want to gamble with the webserver resources again. Sandra and Woo and Gaia together had over 150,000 page views per day during the last two weeks, and Monday even saw a new all-time record with 166,960 page views for the English version of Sandra and Woo alone. Unfortunately, I have almost no chance to measure the resource consumption since I’m using a managed hosting service without access to the server itself.
└ posted on Friday, 11 October 2013, by Novil
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.
└ posted on Friday, 27 September 2013, by Novil
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.
└ posted on Thursday, 26 September 2013, by Novil
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.
└ posted on Wednesday, 25 September 2013, by Novil
The webserver running sandraandwoo.com 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.