[solved] Major site lag after moving to new web hoster

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
User avatar
Manuel
Regular
Posts: 36
Joined: Mon Feb 20, 2006 12:36 am
Location: Lion's den :3
Contact:

[solved] Major site lag after moving to new web hoster

Post by Manuel » Sat Apr 30, 2016 1:54 pm

Hi!

As my previous web hoster has gone defunct, I had to move my two blogs to a new server recently. I used MySQLDumper to back up and restore the databases, made the necessary path adjustments in serendipity_config using PHPMyAmin and let the installer run in order to create new serendipity_config_local.inc.php files.

So far, so good.

Now, for some strange reason, the older one of my blogs exhibits severe lag when browsing through the site. Check it out: 1st blog (major lag) -- vs. -- 2nd blog (no lag)

Installed event plugins (in order of their appearance in the backend):
  • serendipity_event_head_nugget (this contains a few lines of javascript for e-mail spam protection)
  • serendipity_event_s9ymarkup
  • serendipity_event_emoticate
  • serendipity_event_nl2br
  • serendipity_event_spamblock
  • serendipity_event_staticpage
  • serendipity_event_freetag
  • serendipity_event_emoticonchooser
  • serendipity_event_statistics
  • serendipity_event_lightbox
  • serendipity_event_findmore
  • serendipity_event_commentsearch
  • serendipity_event_dbclean
As you can see, I tried cleaning up the database using the DBClean plugin, but that made no difference at all.

I'd hate to lose the old content and simply start afresh, so any help to get the old blog back working properly again is greatly appreciated. :)

Thanks!
Manuel

Edit: Updated thread title
Last edited by Manuel on Sat Apr 30, 2016 6:24 pm, edited 1 time in total.
Image

User avatar
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Major site lag after moving to new web hoster

Post by Timbalu » Sat Apr 30, 2016 4:52 pm

Manuel wrote:the older one of my blogs exhibits severe lag when browsing through the site
I currently simply have no idea what you mean by this.... (Maybe, you mean the older blog takes as while to load each page?)
Where is the problem, the issue you have?

We also have a german part of the forum. Maybe that is easier and quicker?

If the load is the main question, we would need some more details, about how you have installed these 2 blogs. What is the directory structure? (Hopefully not one in another, for example.) Are these total independent Serendipity installs? etc. Do they use the same database? etc. Everything you may think of which could be related for one being slower than the other. Did you also check the database of the old maybe having grown too big, in special in the spamblog log or visitors tables...?
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian

User avatar
Manuel
Regular
Posts: 36
Joined: Mon Feb 20, 2006 12:36 am
Location: Lion's den :3
Contact:

Re: Major site lag after moving to new web hoster

Post by Manuel » Sat Apr 30, 2016 5:26 pm

Timbalu wrote:Maybe, you mean the older blog takes as while to load each page?
Jau.
Timbalu wrote:What is the directory structure? (Hopefully not one in another, for example.)
/path/to/my/webspace/domain1/blog <-- 1st s9y install dir
/path/to/my/webspace/domain2/main <-- 2nd s9y install dir

Each installation uses its own dedicated database. So yeah, the two installs are completely independent, apart from being hosted on the same server.
Timbalu wrote:Did you also check the database of the old maybe having grown to big, in special in the spamblog log or visitors tables...?
As mentioned in the opening post, I ran DBClean to no avail. If the tables are still too big, what else can be done to safely shrink them?
Image

User avatar
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Major site lag after moving to new web hoster

Post by Timbalu » Sat Apr 30, 2016 5:37 pm

Manuel wrote:If the tables are still too big, what else can be done to safely shrink them?
If that really is the case, delete old logs and old visitors by hand with some nice query and/or not using these table logs at all. How big are they?

What about your domains - do they have the same access rate?

I takes about 3,25 seconds to load the index page.
Directories look good.

I would try to disable (in mean: set hidden) the plugins one by one and check the access after each to find out, if the lag is a used plugin.
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian

User avatar
Manuel
Regular
Posts: 36
Joined: Mon Feb 20, 2006 12:36 am
Location: Lion's den :3
Contact:

Re: Major site lag after moving to new web hoster

Post by Manuel » Sat Apr 30, 2016 5:55 pm

Timbalu wrote:
Manuel wrote:If the tables are still too big, what else can be done to safely shrink them?
If that really is the case, delete old logs and old visitors by hand with some nice query and/or not using these table logs at all.
Got it. And lo and behold, the lag seems to be gone! Thank you very much! :D
Image

User avatar
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Major site lag after moving to new web hoster

Post by Timbalu » Sat Apr 30, 2016 6:01 pm

I remembered I once had this with a blog I have to look up from time to time, see
http://board.s9y.org/viewtopic.php?f=3& ... #p10438464

These tables had about 0.9 GB. And I used queries like this:

Code: Select all

DELETE FROM `s_spamblocklog` WHERE reason='No API-created comments allowed'
DELETE FROM `s_spamblocklog` WHERE reason LIKE 'BEE Honeypot%'
DELETE FROM `s_spamblocklog` WHERE reason LIKE 'BEE HiddenCaptcha%'
DELETE FROM `s_spamblocklog` WHERE reason LIKE 'Caught by the Bayes-Plugin%'
DELETE FROM `s_visitors` WHERE day LIKE '2012-%' 
....
and that freed about ~0.5 GB
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian

Post Reply