15 useful MySQL/MariaDB performance tuning and Optimization Techniques

15 useful MySQL/MariaDB performance tuning and Optimization Techniques

MySQL is a powerful open-source Relational Database Management System (RDBMS ). It was released in 1995 (20 years ago ). It uses Structured Query Language (SQL), which may be the most popular choice in database content management. The latest MySQL version is 5.6.25, which was released on July 25, May 29, 2015.

An interesting fact about MySQL is that its name comes from Michael Widenius (MySQL founder)'s daughter "My ". Although there are many interesting rumors about MySQL, this article mainly shows you some useful practices to help you manage your MySQL server.

MySQL Performance Optimization

In April 2009, MySQL was acquired by Oracle. The result is that the MySQL Community is split and a branch named MariaDB is created. The main reason for creating this branch is to keep this project free under GPL.

Today, MySQL and MariaDB are one of the most popular RDMS for WordPress, Joomla, Magento, and other web applications (if not the most ).

This article will show you some basic but useful tips on how to optimize MySQL/MariaDB performance. Note: This document assumes that you have installed MySQL or MariaDB. If you still don't know how to install them on the system, follow the instructions below:

• Install LAMP on RHEL/CentOS 7
• Install LAMP (Apache with MariaDB and PHP) in CentOS/RHEL/Scientific Linux 6)
• Implementation of MariaDB Proxy read/write splitting
• How to compile and install the MariaDB database in Linux
• Install MariaDB database using yum in CentOS
• Install MariaDB and MySQL
• How to migrate MySQL 5.5 database to MariaDB 10 on Ubuntu
• Install MariaDB on the Ubuntu 14.04 (Trusty) Server