Database Reference
In-Depth Information
In this chapter, you review some important points pertaining to the performance of
MariaDB.
Database administrators spend a significant portion of their lives tweaking and
experimenting to improve DBMS performance. Poorly performing databases
(and database queries, for that matter) tend to be the most frequent culprits
when diagnosing application sluggishness and performance problems.
What follows is not, by any stretch of the imagination, the last word on
MariaDB performance. This is intended to review key points made in the pre-
vious 29 chapters, as well as to provide a springboard from which to launch
performance optimization discussion and analysis.
So, here goes:
First and foremost, MariaDB (like all DBMSs) has specific hardware
recommendations. Using any old computer as a database server is fine
when learning and playing with MariaDB. But production servers
should adhere to all recommendations.
■
As a rule, critical production DBMSs should run on their own dedi-
cated servers.
■
MariaDB is preconfigured with a series of default settings that are usu-
ally a good place to start. But after a while you might need to tweak
memory allocation, buffer sizes, and more. (To see the current settings
use
SHOW VARIABLES;
and
SHOW STATUS;
.)
■
