BE SHARING

Elisa Usai

MySQL – Time mismatch between system and log files

13.04.2018 by Elisa Usai

I was working on MySQL upgrades to version 5.7 at a customer, when I found out that for my instance, time in the error log file didn’t correspond to local system time: [email protected]:/u01/app/mysql/admin/mysqld1/log/ [mysqld1] mysql -uroot -p Enter password: ERROR(…)

Database Administration & Monitoring

MySQL – Foreign keys and “Cannot delete or update a parent row: a foreign key constraint fails” error

08.03.2018 by Elisa Usai

As you know, foreign keys establish a sort of relationship between 2 tables. MySQL requires InnoDB storage engine to support foreign keys. In our example, we have the following parent table in a MySQL 5.7.21 server: mysqld3-([email protected]) [sakila]> show create(…)