MYSQL
PB SQL FAILOVER
Clic droit --> Failover… Next Next Finish Vérifier que le 1 est bien passé en...
Commandes General
Poids base de doonnées SELECT sum( data_length + index_length) / 1024 / 1024 "Nom-de-la-base ...
Dump/Restore
Création de dump Mysql: /usr/bin/mysqldump -u mysqldump -p name | gzip -c --best > /production/...
Mysql innodb cache info
Vérifier taille Buffer Pool Size: mysql SELECT FORMAT (BufferPoolPages*PageSize/POWER(1024,3),2...
Modification du compte mysql_monitor
mysql SHOW DATABASES; select user, host from mysql.users; UPDATE user SET password=PASSWORD('P...