Do you ever wonder where does your database lives? MySQL is just like any other programs, it runs and listens to specified port, accepts connections,…
Knowledge from writing codes and a bit of managing linux servers.
Tag: mysql
Have you ever encounter failing to start your MySQL server that throws this kind of error:
|
1 |
[ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions. |
This occurs when your server suddenly shutsdown or…