Who is running MySQL 8?

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Anti-Spam Guide
Swanny
Registered User
Posts: 486
Joined: Sun Apr 14, 2002 2:11 am
Location: Canada

Who is running MySQL 8?

Post by Swanny »

Hi I'm just wondering how many folks are running MySQL 8 here with the latest phpBB? My host wants me to upgrade from 5.7 to 8 and I can't have a test area. It seems like a few people are running MySQL 8 but I'm not seeing a lot of talk about it.

Is there anything to be aware of regarding the upgrade? I'm running phpBB 3.3.11 latest.

My hoster says once I go to MySQL 8 there is no way to downgrade back to 5.7 so I need to be very sure everything with phpBB will work.
User avatar
ssl
Registered User
Posts: 1815
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: Who is running MySQL 8?

Post by ssl »

I use mysqlnd 8.2.9
Capture d’écran 2023-12-07 à 17.54.28.png
You do not have the required permissions to view the files attached to this post.
Sorry for my English ... I do my best!

phpBB: 3.3.12 | PHP: 8.3.7
[Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
Swanny
Registered User
Posts: 486
Joined: Sun Apr 14, 2002 2:11 am
Location: Canada

Re: Who is running MySQL 8?

Post by Swanny »

What is mysqlnd? Never heard of it.
User avatar
ssl
Registered User
Posts: 1815
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: Who is running MySQL 8?

Post by ssl »

The mysqlnd library is highly optimized for and tightly integrated into PHP. The MySQL Client Library cannot offer the same optimizations because it is a general-purpose client library. The mysqlnd library is using PHP internal C infrastructure for seamless integration into PHP

https://www.gizmola.com/blog/archives/a ... sqlnd.html

Ask to your host
Sorry for my English ... I do my best!

phpBB: 3.3.12 | PHP: 8.3.7
[Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
Swanny
Registered User
Posts: 486
Joined: Sun Apr 14, 2002 2:11 am
Location: Canada

Re: Who is running MySQL 8?

Post by Swanny »

What version of MySQL are you running as shown on the main ACP index page? I looked at my PHP information page in ACP and it reports the 8.1 version as well but the main index page near the top says MySQL 5.7.44
Screen Shot 2023-12-07 at 2.36.47 PM.png
You do not have the required permissions to view the files attached to this post.
User avatar
ssl
Registered User
Posts: 1815
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: Who is running MySQL 8?

Post by ssl »

Capture d’écran 2023-12-07 à 21.41.02.png

All this depends on your host for the different versions.
On another forum with another host i have this config
Capture d’écran 2023-12-07 à 21.44.56.png
You do not have the required permissions to view the files attached to this post.
Sorry for my English ... I do my best!

phpBB: 3.3.12 | PHP: 8.3.7
[Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
Swanny
Registered User
Posts: 486
Joined: Sun Apr 14, 2002 2:11 am
Location: Canada

Re: Who is running MySQL 8?

Post by Swanny »

Hmm OK so you are using MySQL 5.7 and MariaDB 10.4
User avatar
Forex Station
Registered User
Posts: 184
Joined: Thu Apr 06, 2017 2:26 pm
Location: Australia

Re: Who is running MySQL 8?

Post by Forex Station »

Recently started using PHP 8.2 from PHP 7.1 and had to fix a few issues it was causing us due to our outdated Envato style:
  • Private Message folders being inaccessible
  • Jumping to topic pages not working
But apart from those small problems PHP 8.2 has made our forum noticeably quicker ie. pages load 20% faster so we're really happy with it.

Has anyone else noticed the jump in performance after upgrading to 8.2 here?

Ass On Fire.jpg

Edit: Made a mistake thought we were discussing PHP.
You do not have the required permissions to view the files attached to this post.
Highly-customized PhpBB board, voted as one of the most influential trading sites in the world: forex-station.com 💬
redsquirrel
Registered User
Posts: 40
Joined: Wed Aug 20, 2014 3:54 am

Re: Who is running MySQL 8?

Post by redsquirrel »

I would setup a local test bed. Always a good idea anyway so when you make changes you can make sure it works locally first then rsync to the host when you want to go live with the update.
User avatar
AmigoJack
Registered User
Posts: 6115
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン

Re: Who is running MySQL 8?

Post by AmigoJack »

Guys, you mix up server and client:
  • nd is "native driver", and i is "improved" - both are just clients=drivers whose version is unbound to the version of the actual running DBMS. ACP > System > General Tasks > PHP information lists all modules active with PHP, thus only SQL clients.
  • ACP > General > Board statistics > Database server tells you both: phpBB's client variant which connects to the DBMS, followed by the actual SQL daemon=server version (can be as quirky as "5.5.54-0+deb8u1").
  • MariaDB is not MySQL - those are not synonyms. Both have crucial differences in licenses, features, and in their names.
So far nobody in this topic runs MySQL 8. If you have PHP 8 then (of course) your MySQL driver's version is 8, too. But that doesn't mean the DBMS magically becomes version 8, too - a version 8 driver can still use MySQL 5 and/or MariaDB 10.
  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
User avatar
SpIdErPiGgY
Registered User
Posts: 220
Joined: Sun May 02, 2021 2:11 pm
Location: Erpe-Mere, Aalst, BE
Name: Andy Dm

Re: Who is running MySQL 8?

Post by SpIdErPiGgY »

Screenshot 2023-12-24 at 04-58-40 Beheerdersoverzicht.png
You do not have the required permissions to view the files attached to this post.
phpBB NL Extension translations, also on request.
--> Click Here: Myarea51secrets.com <--

Return to “phpBB Discussion”