Book Image

MariaDB High Performance

By : Pierre Mavro
Book Image

MariaDB High Performance

By: Pierre Mavro

Overview of this book

Table of Contents (18 chapters)
MariaDB High Performance
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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 to change a lot of parameters, but only the most important ones. The rest of the performance will be achieved by tuning your schema, your indexes, and your application!

In the next chapter, we'll start discussing architectures and how to make a replication...