0

I'm writing this after about 3 days of researches without ending in a solution that has sense.

I had several setups to host Wordpress sites, using Apache directly and using Plesk, everything hosted on AWS. Recently I setup a new Plesk installation on a m5a.xlarge instance, and things started behaving strange.

Basically the performances on this new instances, profiling the TTFB of the wp-login.php are unacceptable. We are talking about 2.0 secs in comparison of the old setup.

To make the thing short, I made tons of tests and the results are the following:

  1. TTFB 0.3-0.4 on Apache AWS Linux 2 with Mariadb 10.2, t3.medium
  2. TTGB 0.3-0.4 on Plesk t3.medium running Mariadb 5.5
  3. TTGB 1.8-2.2 on Plesk m5a.xlarge running Mariabdb 10.5 (the last one).
  4. Final test, bring up a new machine m5a.xlarge and installed another plesk, TTFB 0.2-0.5 but plesk installed Mariadb 5.5

Now first of all I did not understand why plesk intalled 5.5 twice and 10.4 on one instance. There's no choice during the installation.

I made every kind of test, I have the sensation that there's something about encoding and collations, but also running a mysql benchmark from withing WP, no differences are shown and the results are pretty much the same.

So anyone can show the light what's going one there ? Mariadb 10.5 ? Or is it possibile a faulty disk ? Ever happened ? (I also detached the disk and tried on another instance, no difference, so faulty instance is out of scope).

Thanks !

bitski
  • 1,168
  • 1
  • 13
  • 20
Leonardo Bernardini
  • 1,076
  • 13
  • 23

1 Answers1

0

To anyone that may experience a foolish problem like mine, basically when I did the installation of the faulty server, I updated MariaDB to 10.5. The problem was there, it does not play nice with Wordpress, that's all. I found a lot of people reporting performances regression with Wordpress and even this sounds weird, that's the problem. I've rebuilt a server, kept MariaDB 5.X and everything is going smooth. BTW Plesk support has been totally useless keeping uninstalling my plugins and telling me that the problem was in the plugins.. :/

Leonardo Bernardini
  • 1,076
  • 13
  • 23