MySQL crashes daily at exactly 17:00 (server time). The website freezes and nothing seems to work. Now I to reinstall the database from a backup to restart the website.
I am using MySQL with InnoDB and it seems that something locks the database at the same time always. The website makes a lot of writes and reads and probably there is an issue between InnoDB and MyISAM in handling of data.
Is there anybody who can identify what causes the lock and remove it?
This is a dedicated server that runs Apache and Nginx.