Score:0

Server

Why would my WordPress website be so slow?

Arvo Bowen

9/9/23, 5:16 PM

Goal:

Make WordPress webpage load faster on local network. Currently pages load fine but take about 4-5 seconds to load. I want to cut that down to half the time or smaller.

I have a two new VMs dedicated to this new website I'm testing (ON LOCAL NETWORK). One VM is for the SQL server, and the second VM is for the webserver.

SQL Server Setup: (less then 50% mem/cpu max)

OS: Windows Server 2019
MySQL: Ver 8.0.29 for Win64 on x86_64 (MySQL Community Server - GPL)

Web Server Setup: (less then 50% mem/cpu max)

OS: Windows Server 2019
IIS: Ver 10.0.17763.1
IIS Compression module enabled
IIS WinCache module enabled
IIS Output Caching enabled
PHP: Ver 7.4.29 (cli) (built: Apr 14 2022 16:24:02) ( NTS Visual C++ 2017 x64 )

WordPress Setup:

Ver 5.9.3
NO plugins enabled

I currently do not have an SSL cert set up on the server because I want to get these performance issues resolved first. Was not sure if that would be a factor but thought it wise to mention.

The site loads fine but it just takes forever. Is there any things that can be checked to see why the site is loading so slow? Could it be related to mySQL somehow? It seems that from the default IIS webpage when I put a phpinfo.php page that loads really fast. Any ideas of tests I could run to troubleshoot slow load times?

Note: I know there are a lot of server admins out there that will knee jerk response with "Don't use Windows it's bad.". I'm not looking for that kind of "help" here. I know it runs fine on Windows using IIS. I have seen plenty of webpages with users saying they have no issues running the sites on Windows with IIS.

Thanks for any suggestions you can provide with a solution or debug help!

0 + 0

mysql

iis

wordpress

djdomi

9/9/23, 5:21 PM

and what is the business related question in here?

Arvo Bowen

9/9/23, 5:40 PM

@djdomi What is the business related question? I was just seeking any suggestions as to why a out of the box new IIS/PHP/mySQL/WordPress setup would be run slow.

Chopper3

9/9/23, 6:06 PM

Hi Arvo, I have to agree with Tom I'm afraid - our help pages, which we ask all new users to at least glance over, is clear that we're here for professional sysadmins/system-designers with experience in covering the basics, have done their homework and come to us with information we can use to help - we just get a lot of people come here who want us to guess what their setup is and it gets frustrating - at least you had some detail in your post, just not that much really sorry. Ultimately we want to help but we're not mind-readers, does that make sense?

Arvo Bowen

9/9/23, 7:29 PM

I think I found my issue. A really great suggestion/answer that could have been more helpful is one I found over at spice works.com which suggested that I replace the hostname with the IP address of the MySQL server in my WordPress config. Having page loads go from 4 second to ~1 second. I understand this is a professional site @Chopper3 but the way comments are coming off from users, it sounds like server fault is a site that should be a paid membership and have users confirm they are part of the "IT profession". Why would people who know the answers ask questions here?

Arvo Bowen

9/9/23, 9:10 PM

@Chopper3 could you help me learn by telling me what was unclear and left readers with questions? When you say "we're here for professional sysadmins/system-designers with experience in covering the basics, have done their homework", I'm left wondering what I said in my question that gives you the impression I'm not one of those. Obviously I have experience as I have stated in my question that I have an virtual environment I have created, setup multiple servers on that environment, set up the mysql server and the webserver, added support for php, installed wordpress, etc.

Tim

9/9/23, 9:41 PM

Wordpress is commonly used in business, my opinion is this is a valid question. I'm surprised changing the DNS name to an IP helped that much, DNS lookups should be cached. I would suggest looking at Wordpress caching plugins as well, in addition to carefully configured page caching.

Lex Li

9/10/23, 12:43 AM

As a complex PHP app itself, WordPress performance tuning requires significant experience with PHP (like using a profiler, like Xdebug). You were just a little bit lucky to find a tip that hits (slow DNS like yours is rare), but in any other case luck might not be applicable.

Esa Jokinen

9/10/23, 3:53 AM

Of course this is business related: an individual with money to use WordPress on Windows Server 2019 sounds unlikely.

djdomi

9/10/23, 4:58 PM

he dis still not answer if his page is business environment or relevant. We getting daily WordPress question from enduser which are off topic as Chopper greatly explained. And your comment to me sounds offensive in my feelings. Moreover opinion based questions and answers are also offtopic

Wilson Hauck

9/13/23, 1:31 AM

@ArvoBowen Additional information request, please. RAM size, # cores, any SSD or NVME devices on MySQL Host server? Post on pastebin.com and share the links. From your SSH login root, Text results of: A) SELECT COUNT(*) FROM information_schema.tables; B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; AND very helpful OS information, includes - for server workload tuning analysis to provide performance improving suggestions.

Rick James

9/13/23, 4:06 AM

[_WP Index Improvements_](https://wordpress.org/plugins/index-wp-mysql-for-speed/) is a plugin that will help performance of a number of queries, especially those involving `post_meta`.