Oct 23, 2018 | The Others |
View original...
Dec 1, 2017 | The Others |
MySQL 8.0 has a new feature called “invisible indexes,” which allow you to quickly enable/disable indexes from being used by the MySQL Optimizer. There are a couple of use cases. One of them is if you want to drop an index, but want to know the effect beforehand. View...
Nov 1, 2016 | Quick Tips, Troubleshooting |
The basic principle is, just restart where the slave left off. The problem arises if a binary log, on the slave side, remains corrupt. The recovery is relatively simple, just follow the recipe: STOP SLAVE SHOW SLAVE STATUS Note down ‘Relay_Master_Log_File’...