Posts

Showing posts with the label queries

MySQL 8 Problems (RadioDJ)

Image
Over the past year or so I've seen LOTS of people having issues with MySQL 8 and RadioDJ. Which has now lead Marius to post about using RadioDJ with MySQL 8 Marius carried out out some tests and its quite clear that MySQL 8 takes longer to process queries compared to MariaDB. Query Duration MySQL8: 1.7712764 seconds Query Duration MariaDB: 0.0081946 seconds As you can see the difference is huge on MySQL8 it takes almost 2 seconds just to run a single query. I found MySQL to be bloated when it came to installing it to test it There were far too many options to setup MySQL8 Whereas MariaDB is simpler to install and not so bloated I've used MariaDB since June 2014 and it performs 100% better than Oracle MySQL ever did. I've NOT had to rebuild my RadioDJ database since 2014. I take daily backups so I don't lose my hard work. Its rare for MariaDB databases to crash (IF EVER) I've not had to run a repair in a w