Installing MariaDB Tuning Performance Tools.

Performance Tuning is an important part of the database. In MariaDB or MySQL If you use phpMyAdmin you will get “possible performance issues report” and “All status variables” that can tell you about the reason for performance issues.

Installing MariaDB and phpMyAdmin on Docker Desktop for Windows

→ All status variables and Advisor can help you know about issues on your database and you can tune for increase performance.

In addition, today I have two more tools to help you in tuning the performance of your database

1. install tuning-primer.sh in your container

Fist of all, exec to your MariaDB container

docker exec -it [container_id] bash
#for example
docker exec -it 81db1912465f bash

And, You will get into the docker container bash

And log in to your database

$ mysql -u root -p

login to MySQL database

show databases; (check it works)

$ run command below for install tuning-primer.sh

$ apt update
$ apt upgrade
$ apt-get install sudo
$ sudo apt install bc
$ sudo apt install curl
$ curl -L https://raw.githubusercontent.com/BMDan/tuning-primer.sh/master/tuning-primer.sh | bash

You will get a report about a variable that can help you decide to tune each variable to increase your database performance

Query Cache analysis

Connection analysis

If you want to know further about tuning-performance in MariaDB, please check out https://mariadb.com/kb/en/optimization-and-tuning/ (this is the big topic about database)

ENJOY WITH SELECT * FROM …….

Thanks for reading!

- Anu Wat -