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
In this post, I will show you how to install MariaDB and phpMyAdmin using Docker Desktop on Windows 10 Home.
→ 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
- install tuning-primer.sh in your container
Fist of all, exec to your MariaDB container
docker exec -it [container_id] bash
docker exec -it 81db1912465f bash
And, You will get into the docker container bash
And log in to your database
$ mysql -u root -p
$ 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
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 -