Website Retrieval Slower After Upgrade To Joomla 5 And Associated Change To MySql 8 - Question | JoomShaper
Black Friday sale is live with flat 50% OFF. Sale ends soon! Grab your deal now!

Website Retrieval Slower After Upgrade To Joomla 5 And Associated Change To MySql 8

M

Marco

SP Page Builder 1 year ago

Hello,

Have any of you ever noticed that after a DB migration from MySql 5.7 to MySql 8.0 the website responses are higher?

According to my provider, a MySql dump of the 5.7 DB and an import of this dump into a MySql 8.0 DB is sufficient.

Do I have to consider anything else from Joomla or from SP Page Builder?

Regards - Marco

0
5 Answers
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #150473

Hi there,

Thank you for reaching out, and I apologize for any inconvenience caused by this oversight. I would request you to contact your hosting provider. I hope they can help you.

Best regards,

Toufiqur Rahman (Team Lead, Support)

0
M
Marco
Accepted Answer
1 year ago #150537

Hello,

I have already contacted my hosting provider - the support assured me twice that the SQL dump of a MySql 5.7 database can simply be imported into a MySql 8.0 database - done.

Do you see it the same way from Joomshaper?

My question in this regard also goes in this direction, whether SP Page Builder can also use the new features of the MySql 8.0 database after such an import into the new database - list of features here (please translate yourself): https://www.easyname.at/blog/news-2/updates/mysql-8-das-solltest-du-wissen/

I miss the increase in speed of the pages that now run with MySql 8 databases - there is no difference to before, as written possibly even slower!

Regards - Marco

0
Paul Frankowski
Paul Frankowski
Accepted Answer
Senior Staff 1 year ago #150694

Marco, few technical details

  1. In general MySQL 8 is requested by Joomla Core itself, without you cannot even dream about Joomla 5.
  2. About MySQL version doesn't have big impact on the website speed, but it shouldn't be slower.
  3. From my private expirence, for over 3 weeks I test Joomla 5.03 + PHP 8.3 + SPPB 5.x and I see difference between PHP 8.0/8.1 vs PHP 8.3 in speed, all is smoother.
  4. And whether Joomla 5 is slower than Joomla 4 is a question for Joomla Team Developers.

We are not hosting support to give you tips what you can or not do in your Cpanel. But If you can:

  1. Turn on GZIP on the server for all objects.
  2. Check if you can use LiteSpeed or REDIS Cache.
  3. Add extra "speed-up & cache" code to .htaccess file.
  4. Check topics on forum.joomla.org what else you can do.

In general it's a topic for whole book or long article, not forum post.

0
M
Marco
Accepted Answer
1 year ago #151031

Hello Paul,

thanks for your information.

So I take it from your answer that not much more needs to be done when converting the database - that's fine!

The few technical points are interesting - unfortunately I don't have PHP 8.3 available, my provider stops at 8.2.

Gzip is activated by default - I didn't know that myself before, but of course the provider releases his systems and I have set up redis, but it doesn't really do anything for me - I'll have a look at the .htaccess entries - thanks for that.

Regards - Marco

0
Paul Frankowski
Paul Frankowski
Accepted Answer
Senior Staff 1 year ago #151066

Of course using PHP 8.2 is totally OK, it's faster & safer than PHP 7.4, 8.0 or 8.1. I hope soon your Hosting company should implement PHP 8.3 - but more users have to ask for it, ask by FB etc.


You're welcome.

0