Catégorie : mysql

Replication bloquée : mysql 4.1.2

Bonjour, Encore un incident mysql sur un serveur de réplication , c’est un incident courant dans ce contexte de production .   Incident:   :   show slave status\G; Replicate_Wild_Do_Table:...

by dbaexpertconsulting
Read More

Host ‘host_name’ is blocked because of many connection errors

Incident : Host ‘host_name’ is blocked because of many connection errors. Unblock with ‘mysqladmin flush-hosts’ The value of the max_connect_errors system variable determines how many successive interrupted connection requests are...

by dbaexpertconsulting
Read More

Lock wait timeout exceeded

Incident : 161004 18:47:32 [ERROR] /opt/mysql/product/5.1.73/bin/mysqld: Lock wait timeout exceeded; try restarting transaction 161004 18:47:32 [ERROR] /opt/mysql/product/5.1.73/bin/mysqld: Sort aborted solution: modification du parametre :  innodb_lock_wait_timeout qui passe de 50 seconds...

by dbaexpertconsulting
Read More