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
About the Author
About the Reviewers

Chapter 3. Performance Optimizations

In this chapter, you will see how to choose the engine depending on your needs, how to optimize them, and how to optimize your operating system for MariaDB.

Checking all the requests passed to your MariaDB database can be a long quest. When you're facing slowdown issues on an application, some other elements should be taken into consideration before auditing all your application code. For example, there is a lot of engine optimization that can be checked and adjusted before diving into the code. There are also several engines that can answer your needs. We'll see here a few things that you need to check, and that can be easily verified.

In this chapter, a lot of MariaDB global variables will be seen and configured. Some of them are simply counters. Before taking them into account, it's recommended that you run a MariaDB instance for at least 24 hours with a normal load. If you set new environment variables and want to reset those counters, it's recommended...