Two the Same site with same Theme – Create a new post big time difference!!

What’s totally missing from your comparison and performance assessment is the traffic or LOAD on the respective sites/servers.

For the same site, a server that is just enough to power the site when you have just 1,000 visitors per month will not be able to power the same site when you have a million visitors per month.

And a 1-page site that gets a million visitors per month (eg if you’re driving paid ads to it) will require a much bigger server to run than a website with 100,000 posts that was launched today and gets virtually no traffic.

That’s why site owners often scramble around to beef-up their server when they know they’re going to appear on a major news site: because the huge inrush of visitors will put excessive strain on their “normal” server, crashing the site. (The Slashdot effect)

For a 5-year-old site with 82,000 posts, I can bet it’s getting a ton of traffic/visitors, and this is playing a big role in the slow dashboard speed you’re experiencing. Heck, even bots alone can put a huge strain on the server (if bot crawling is not properly controlled).

I have two site both use the same theme and identical plugins also both hosted on Amazon AWS Lightsail

These plugins (and the theme) aren’t just sitting there idle: they are doing “something” (that’s why you installed them to begin with). And to do this “something” on 82,000 posts for (say) 100 visitors simultaneously will require much more infrastructure than doing the same “something” on just 18 posts for (say) 10 visitors.

1st site 5 Years old – https://bit.ly/3k9mKMz – 82000 posts
– Instance set in Ohio USA (I am in US)
– 32 GB RAM, 8 vCPUs, 640 GB SSD Bitnami WordPress Instance
– 2 GB RAM, 1 vCPU, 80 GB SSD MySQL database (8.0.21)

I’m really struggling to understand why you have such a configuration. For a database-driven website like WordPress, most of the load (hence the bottleneck) will be on the database.

So I’m really perplexed why you have a MySQL database server with just 2GB RAM and 1 vCPU, while the webserver rather has 32GB RAM and 8vCPUs. Did you choose these RAM and CPU configs based on expert analysis of the performance logs on the two servers? I doubt this was the case.

In summary, yes, the number of posts play a role, but even more important is the load or traffic coming to the site: the 5yo site with 82,000 posts is likely getting traffic orders of magnitude higher than the 3wo site with just 18 posts. And comparing the performance of two websites as you’re doing now isn’t really useful.

And looking at the GMetrix report you provided, even the “winning” 3wo site with just 18 sites isn’t performing spectacularly: LCP of 5.4 seconds and an “F” GMetrix grade.

This leads me to conclude that your setup for both sites isn’t optimal, and you can probably get better performance without spending more, if you could have an expert look at your setup and tune things up for you.

Just my 2 cents.

Good luck!

• This reply was modified 3 years, 8 months ago by George Appiah. Reason: Fixed typo

Hello George @gappiah,

Thank You! for super fast response that make a lot of sense!!!
And YES, look like You are absolutely right! and Your 2 cents look like a million dollars ??

The 1st site vs 2nd site have a big difference with live traffic!

All setups during this 5 years is on the base of random recommendations from other forums advices that look like are not correct at all.

This is why I keep increasing single Lightsail server Instance till max avilable package on AWS Lightsail thinking that this will help.

Then when website still failing to load I decide (first time in my life) to get separate database Instance started from very small which also fail after 1st hour then I go to another bigger.

If I thinking correct? Now after Your post I see that the Primary instance with wordpress server can be much smaller and database Lightsail Instance should be a lot bigger to take care the load.

And YES this site receive a lot of spam traffic and bots, when I install WORDFENCE plugin I see hundreds request to try random passwords to get access to the site. Thankfully this plugin block them.

Now I will try to optimise and block unnecessary bots and scammers that trying to compromise the site.

Can You recommend any plugin or settings for this?

And after that I will try to move wordpress to smaller Lightsail Instance and database to bigger…?

Also this is a first time when I setup and use a separated MySql database on Lightsail Instance.

This is a screenshot from current loads – https://i2.paste.pics/BRGDE.png can You take look on this…?

I am still not know how to properly read all the status on MySql but I think that Client Connection is important factor because when I start with smaller instance I reach the 66 limit after first 60 minutes – so then I decide to increase this instance to another level.

Now after upgrade Client Connection have this limit at 150 that so far never has been reached. So for this moment maybe ok? can keep this Instance – 2 GB RAM, 1 vCPU, 80 GB SSD MySQL database (8.0.21) until another fail then will go to next available 2vCPU 4GB RAM…?

Can You confirm my thinking…?

Thank You for your explanation!!!

Arthur