Trinitycore: MySQL 8

Created on 23 Jul 2018 · 13Comments · Source: TrinityCore/TrinityCore

Description: Someone have tried to use MySQL 8 ?

this a little bit changed FindMySQL.cmake for mysql8.0
cmake_mysql8.zip

FindMySQL.cmake updated, but it's not enough.

Someone has inspected it already?

Current behaviour: TC doesn't support mysql 8.0
Expected behaviour: can work with mysql8?

Steps to reproduce the problem:

Install MySQL 8.0
Try to compile

Branch(es): 3.3.5
TC hash/commit: https://github.com/TrinityCore/TrinityCore/commit/c031167e067dd0903c6fa4db4ea88cd5279039d2

TDB version: TDB 335.64
Operating system: Win64

Comp-Build Priority-Very-Low

Source

kvipka

Most helpful comment

Yeah, great. But you need to properly interpret data for our use cases, which is all the lowest points (16-32 threads, less than 100k rows) where there is no difference at all

Shauren on 9 Sep 2019

👍2

All 13 comments

This issue is not considered valid because of the following reasons:

No proper commit hash (revision)

Please read http://bit.ly/tc-issuetracker-and-you and add the missing information to this issue. Thanks.

TrinityCoreBot on 23 Jul 2018

Will not work - fails to compile

Shauren on 23 Jul 2018

Even MySQL 5.7 is less than trivial to combine with TC source, so I would not expect MySQL 7 or 8 to be even close to compatible.

illfated on 24 Jul 2018

5.7 works just fine

Shauren on 24 Jul 2018

After approx. 1 year still "Priority-Very-Low"? When you'll update for MySQL 8.0? In 5 years :)? No hurry..

HBSNET on 1 Jul 2019

Still very low

Shauren on 1 Jul 2019

😄1

Ty and no problem :)
MySQL 8.0 is 10x faster and this is bad.
Staying on MySQL 5 for whatever reason is the best thing ever 😄👌

HBSNET on 1 Jul 2019

go mariadb like all linux distros, fixed.

Aokromes on 1 Jul 2019

👍1

MySQL 8.0 is 10x faster and this is bad.

10x at doing what exactly ? got any comparision report ?

jackpoz on 9 Sep 2019

https://severalnines.com/database-blog/mysql-performance-benchmarking-mysql-57-vs-mysql-80

https://www.mysql.com/products/enterprise/database/

HBSNET on 9 Sep 2019

Yeah, great. But you need to properly interpret data for our use cases, which is all the lowest points (16-32 threads, less than 100k rows) where there is no difference at all

Shauren on 9 Sep 2019

👍2

Yes, you're right. Anyway I downgraded from MySQL 8.x to MySQL 5.7 to use with TC 3.3.5 stable branch and it's ok. I use with Linux Ubuntu 18.04 LTS but this is my last time with MySQL, next time I'll go with MariaDB.

HBSNET on 9 Sep 2019

https://github.com/TrinityCore/TrinityCore/commit/4710a3f6c164dda2909d2962f66090ba6f48c278

Aokromes on 10 Nov 2019

Was this page helpful?

0 / 5 - 0 ratings