MySQL/MariaDB-Tabellen in docker-compose optimieren

Wenn das MariaDB / MySQL-Root-Passwort in .env gespeichert ist, diesen Befehl verwenden:

optimize_mysql_from_env.sh

source .env && docker-compose exec mariadb mysqlcheck -uroot -p$MARIADB_ROOT_PASSWORD --auto-repair --optimize --all-databases

source .env && docker-compose exec mariadb mysqlcheck -uroot -p$MARIADB_ROOT_PASSWORD --auto-repair --optimize --all-databases

Das Root-Passwort kann auch direkt im Befehl verwendet werden:

mysqlcheck_direct_command.txt

docker-compose exec mariadb mysqlcheck -uroot -phoox8AiFahuniPaivatoh2iexighee --auto-repair --optimize --all-databases

docker-compose exec mariadb mysqlcheck -uroot -phoox8AiFahuniPaivatoh2iexighee --auto-repair --optimize --all-databases

Check out similar posts by category: Container, Databases, Docker

If this post helped you, please consider buying me a coffee or donating via PayPal to support research & publishing of new posts on TechOverflow