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.
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,…
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…