Site performance, Server errors, outages and tunings

[Like Ra]

Tried more tweaks. Interesting, that WP DB cache did not improve anything, but quite the opposite it constantly increases CPU load.

I wonder if zram helps with RAM shortage. Let's see in a couple of days.

[Like Ra]

Finally... After years of troubleshooting, testing and trying to understand why the heck the database is writing gigabytes(!) to disks I finally nailed it. SQL logs, SQL analysis, plugin analysis and here we go! An innocent looking plugin for wordpress that adds pagination... Hundreds DB deletes/inserts per minute! Oh my...

Tweaked the plugin, now the CPU, disk I/O rate gone down significantly, and DB cache hits increased to 70%.

Just a couple of lines of PHP code... BTW, I think this is why the site was banned many times by the previous provider.

Yes, I learn, I do learn...

[Like Ra]

Next step is to update the WP (Blog) theme so it's compatible with the latest WordPress API and HTML5. More work, but it needs to be done anyway...

[Like Ra]

And another breakthrough - I rewrote some scripts so now they work asynchronously after the page has loaded. The result is a further 50% speed up and increase in the Google and Yahoo speed grades.

Now I need to move the Google Analytics script in the same "area", because it takes too much time to load (about 05.sec)... Actually, I have an idea...

[Like Ra]

Yarrggghhh.. another @#$%^&* ripper DOSed the site. Unfortunately I noticed too late. Blocked...

[Like Ra]

One good thing is that the huge load did not overload Apache/PHP/MySQL. Looks like I've done a good job ;P


BTW, is there something going on in the Internet between Europe and US? I see a significant packet loss. Or is it my provider?

[B1u3]

Its the NSA 😉

Besides, sometimes in the overview of threads inside a subforum, if there's a new answer in a thread there which I didn't read yet, there is a small thingie saying things like "2 new posts!". But this doesn't work always, only sometimes. Did you notice that?

[Like Ra]

Its the NSA

I think they have finally tapped the cable because the connectivity restored 😁

But this doesn't work always, only sometimes.

Dunno how this plugin works, need to investigate... Does it correlate with "View Unread Posts" above, BTW?

[Like Ra]

I'm still redesigning the blog theme (mostly internally). So you may see broken design or "the white screen of death". WordPress introduced some interesting features I would like to implement. Then I'm going to replace the menu system.

[B1u3]

But this doesn't work always, only sometimes.

Dunno how this plugin works, need to investigate... Does it correlate with "View Unread Posts" above, BTW?

Hm, didn't check that. Normally I don't use this function, "View unread Posts". I just go to the main overview, open the subforums which are marked something happened there and then the threads.