Comment to 'My experiences on page speed'
  • At this point would you recommend upgrading to MariaDB 10.3? Is there anything you can share on the changes made and if it affected your site at all. Does WHM give the option to change from Inno to Aria or will I have to do that in root? When it comes to databases I am still learning a lot. Right now on MySQL 5.7. A fear I have is when I installed Froala it wouldnt work and I had to put a code to convert all my darn tables. So I hope they would convert over the same and with no issues. They are in utf8mb4_unicode_ci.

    • you will need root permissions.
      if you dont shift to mariadb there is no need to change the engine to Aria.

      My site works on Mariadb + Aria engine now, this was the best setup for me.
      But mysql+inno is perfectly fine, just you need to convert UNA tables from Myisam to Inno for best performance.

      • if you are using apache with mod-php the biggest positive impact could be changing to apache + phpfpm or nginx + pgpfpm

        • I am using phpfpm, I ran into problems in the beginning thankfully which caused me to switch to it instead and made a big improvement.