Posts

Showing posts with the label MySQL8

Forget Oracle MySQL Server (Its Buggy)

Image
Seen more and more users who've recently had issues working RadioDJ alongside Oracle MySQL (8) server. I personally think Oracle MySQL lost their way a LONG time ago. I Wrote A While Back about this very issue it seems MySQL8 still doesn't work properly. A soon as people switched to MariaDB their issues went away (Strange That) Marius carried out out some tests a while back 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 2 seconds to run a Query I've been a MariaDB user since 2014 and its RARE I have to do any maintence on my SQL databases. IF You have been having issues with MySQL download and install MariaDB Instead! How to Install MariaDB Please Note: Some versions of MariaDB have issues with RadioDJ due to a Database update...

The Most Perfect Database Software?

Image
2024 will mark 10 years of me being a MariaDB user. I've used it alongside a lot of versions of RadioDJ. I'd seen someone mention in 2014 that they had found MariaDB so I went and installed it. Maria DB hasn't let me down. I can't even remember the last time I had to fire up HeidiSQL to do maintenance to my databases. MariaDB is being used by some large corporations across the world! I had MariaDB powering my old website before I had to cancel the VPS due to technical issues beyond my control. On my VPS servers MariaDB performed amazingly well compared to MySQL Community Server from Oracle. The author of RadioDJ did a few tests and it appears that MariaDB processes SQL queries fast than Oracle MySQL. I had nothing but headaches with Oracle MySQL community server I only ever do a bit of basic housework with MariaDB. I optimise my RadioDJ database every day by an event. Its been a LONG time ...

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...