MariaDB High Performance

Summary

You've seen important tips here to get better performance using several stable engines used in production. Other engines exist but are not so common in production or not stable enough to figure out in this chapter.

Remember that if you have slowness on your application, and if it's due to the database, here is what you should check:

• Look out for any long requests (slow queries), and try to optimize them with the explain command
• Be sure you're using a good engine and have correctly tuned it
• Verify whether you're using indexes only where they are needed
• Be sure your hardware is correctly tuned for high performance
• If all these steps are alright, you should consider going ahead with the next chapters

Tuning MariaDB performance does not require you ...