Database Reference
In-Depth Information
Indexes improve the performance of data retrieval but hurt the perfor-
mance of data insertion, deletion, and updating. If you have tables that
collect data and are not often searched, don't index them until needed.
(Indexes can be added and dropped as needed.)
■
■
LIKE
is slow. As a general rule, you are better off using
FULLTEXT
over
LIKE
.
Databases are living entities. A well-optimized set of tables might not
be so after a while. As table usage and contents change, so might the
ideal optimization and configuration.
■
And the most important rule is simply this—every rule is meant to be
broken at some point.
■
In this chapter, you reviewed some important tips and notes pertaining to
MariaDB performance. Of course, this is just the tip of the iceberg, but now
that you have completed the
MariaDB Crash Course
you are free to experiment
and learn as you best see fit.