…indexes (with their IDs) to the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name…not only rows deleted accidentally. You should manually find the data you need to recover and save it in another file…
Post: Missleading Innodb message on recovery
February 15, 2010 By 2 Comments
… 20000000, file name ./mysql-bin.003000 He has tried to restart replication from mysql-bin.005000 position 10000000 which failed with “Could not find first log file name in binary log index file” error message Looking at the Master for this slave I could see its binary log files going only to about 2000, so the binary log file mentioned…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…name-resolve is easy to miss, as is the absence of innodb_log_file…in the mysql.* tables, running mk-duplicate-key-checker to find redundant indexes…in a high-performance system is virtually every query.) If it’s not possible to use a patched binary…
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
April 7, 2011 By 21 Comments
Getting this error: Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file‘ tried changing binlon file to position to full path, but no luck, any suggestions?
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
Getting this error: Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’ tried changing binlon file to position to full path, but no luck, any suggestions?
