MySql version - is it important?

[Jon12345]

Currently, my Xenforo setup is using MySQL version 5.7.29. Is that good? Bad?

What benefits are there to upgrading to the newest version? Are they faster?

 

[Ozzy47]

Yes, faster and more secure.

 

[rdn]

Newer version mostly Faster but has more bugs.
Older version mostly Stable but slower.

 

[Ozzy47]

As an aside, XF2 recommends 5.5+

 

[Slavik]

As an aside, XF2 recommends 7.2.0

Thats an interesting MySQL release....

 

[Ozzy47]

Hahahaahaa, fixed

 

[gerryvz]

I'm using 5.7.29 myself. MySQL 5.7.x is going to be JUST FINE for any XF 2.1 installation. Users aren't going to notice any difference in database performance between 5.7 and 8.X. Much more performance will be noticed in the broadband connection than in the database. As said, 8.x is much newer than 5.7, and is going to contain more bugs. 5.7 is more tried and true.

I'm on Ubuntu 18.04.3, which is the latest LTS version of Ubuntu. When the next LTS version comes out in a few months (should be 20.04) I'll do a database upgrade. That will give things a bit more time to mature, and bugs to be killed.