SQLSTATE[HY000]: General error: 23 Out of resources when opening file ‘/tmp/#sql_203f_0.MYD’ (Errcode: 24 – Too many open files)

I solved the problem. This is how I did it: I edited /etc/security/limits.conf and added this at the bottom of the file: *                soft    nofile          65535 *                hard    nofile          65535 Then I edited /etc/my.cnf and added/changed this line: open_files_limit=65535 Then I restarted MySQL. And now my backup/dump of databases runs and complete without errors. I... » read more

Lock wait timeout exceeded; try restarting transaction

Як лікувати дану проблему написано тут. Конкретно допомогло ось це Check Your Tables Corrupt tables or problems with mysql will cause errors or slowness. Make sure it’s all working well. CHECK TABLE prism_actions; And if needed: REPAIR TABLE prism_actions