• Welcome to RadioDJ - Free Radio Automation Software Forum. Please log in or sign up.

MySQL 8 vs MariaDB - Important!!!

Started by Marius, May 06, 2019, 11:45:32 PM

RadioDAVE.US

Add my name to the people who switched from MySQL to MariaDB. MariaDB is much faster in my environment. I'm running Windows 10 Professional, 16GB RAM, i5 (six cores), on SSD. Note that the same machine is also hosting StereoTool audio processing, which eats a ton of CPU time. The music library includes 5,226 entries.

I have written a custom playlist generator (Clocklist) that runs every 30 minutes to build a clock-pattern playlist for the following half-hour. Clocklist is written in C# and the performance is highly dependent upon the database querys' performance.

After switching from MySQL to MariaDB, the Clocklist playlist generation time dropped from 650ms to 150ms. 150ms includes the I/O for file creation and program execution. Individual database queries often take 7ms to 12ms.

While the previous execution of 650ms is an acceptable time for playlist generation, the drop to 150ms is a good metric for examining the performance of the infrastructure. The only change was the database engine for this dramatic change in system performance.

I continue to use MySQL Workbench to analyze the data.

bobhill

I'll tell you what, my searches were getting excruciatingly slow with 7000 database entries plus. (beautiful music format) Today the database wouldn't load anything  new and I went and changed the my.ini file in  programdata\mysql\mysql server8.0   to put max_allowed_packet up a bunch to 40M  and suddenly not only did my backup database load instead of error out with max_allowed_packet error, but my searches also became breezy as the wind.   

Just throwing that out there!  I mean instantaneous......Not kidding.

jeffm

Hi all, so how DOES one switch from MySQL to MariaDB?  Jhonny's tutorial on page 1 seems to be gone now and everything I've looked at online seems to contradict each other (uninstall MySQL vs doing some "mysqldump" which I have no clue about.

Thanks in advance.

Jhonny

R.T.F.M. means to me, Read The Fantastic Messages.
Einstein says: Make things simple, but don't make simple things simpler! (wise) this is just my life lesson you know.

I don't do drugs ( ͡° ͜ʖ ͡°)
The Radiodj tutorials site is now managed by Domstad radio .nl still  Just in English


Derek

#20
Updated link (2022) for Jhonny's info. Thanks to Jhonny and the new info site host :-)

https://radiodj.site/howto/migratie.php

*** Please note this post from Marius regarding Beta 2.0.3.4 (not sure if later versions still need this) ***

https://www.radiodj.ro/community/index.php?topic=15858.0

jbakel

i have a question and i already ask it in the dutch forum.
we are swtiched to maria DB with a new computers, now i have the problem that i cannot connect to the host computer with studio 2, hou can i make it work,

marclr17

Hi,

In 2023, is still MariaDB a better choice than MySQL for Radio DJ ?
Thank you,

Marc - France

DaveTheRave

DJ Garybaldy is telling people not to use Mysql server 8 as its buggy If it works for you then thats great just there are users struggling with radiodj and mysql
AMD A8-9600
8GB RAM
Windows 10/11
RadioDJ 2045
MariaDB 11.2

marclr17