Tag: mysql
-
View original article
-
Thoughts on MySQL 8.0’s Invisible Indexes
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 original article
-
MySQL replication: How to recover from “Event too small corruption” or “Slave SQL: Relay log read failure”
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’ and ‘Exec_Master_Log_Pos’ entries. RESET SLAVE CHANGE MASTER TO ….. (use MASTER_LOG_FILE=relay_master_log_file and MASTER_LOG_POS=exec_master_log_pos from…