Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am a developer who will be starting a new project soon in which database performance will be crucial. The current candidate for the backend is MariaDB. I have worked with MySQL and MariaDB before in smaller projects, but the field of bloody optimization is quite new to me, admittedly.

To prepare for the project and not drive it into the ground, I'd like to learn about database performance optimization first. I'd like to know if I (or my employer) bought a book about optimizing MySQL performance, would it apply to MariaDB similarly?

My intuition tells me, that most of the MySQL optimizations would apply to MariaDB too, for they change quite a huge portion of their code base, but to avoid wasting money by buying books which we don't need, I'd like to clarify this. Vice versa a book only applicable to MariaDB would be useless to us if we tried optimizing old products. Unfortunately - as far as I know - there are no books dedicated to MariaDB performance yet. Does this hold?

share|improve this question

2 Answers 2

Yes, all the basic optimizations in MySQL 5.5 apply to MariaDB 5.5.

However, starting with MariaDB 10, a real fork, not all improvements in 5.6 are in MariaDB codebase, and alternatively, MariaDB has some exclusive features (Hash JOINS). For now, those are not too different, that may change in the future. For a book, where most of the optimizations are regarding basic indexing, it may not be very relevant.

And you can always check the latest improvements online -blogs, wikis. This is a presentation I created for the newest MySQL 5.6 query optimizations techniques.

Have a look at this image for a visual representation (white zones are MariaDB-only). 5.6- and 5.7-only are not represented:

enter image description here

share|improve this answer

Take a look here - it's a recommended book list from those who bring you (us) MariaDB. As you will see, many of the books are (also) about MySQL. Take a look here for the differences between MariaDB and MySQL. As I understand it, MariaDB is gradually drifting away from MySQL and will not remain plug and play compatible for long. With most of the differences, they appear to be additions in MariaDB, (storage engines &c.). Having said that, it will (IMHO) be a long time before a developer skilled with MySQL will start having much difficulty with MariaDB.

The good thing about the Open Source/Free Software movement(s) is that there are always references available on the web - take Percona's site and the mysqlperformance blog (excellent IMHO), SkySQL and MariaDB's own (.org and .com) sites for reference. There are of course the storage engine web sites as well.

Overall, I don't feel that finding material to read about MariaDB will be an issue. You're based in Berlin - for €250, you could have a nice MySQL/MariaDB reference library - how much is developer time/hour in Berlin?

Tell your employer to put a small investment into educational resources - it'll pay back many times over (ease of development/mistakes not made/better, more contented employees who can feel that their time isn't being wasted).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.