…the insertion of data to other sessions. How to troubleshoot gap locks? Is possible to detect those gap locks using SHOW ENGINE INNODB STATUS: —…repeatable reads) so in order to prevent problems with the replication you should change the binary log format to “row”. Depending on the statement…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…snapshot (and binary logs for point in time recovery) in case of that ‘Oops’ moment? Let me show you quickly how. This… to apply mysql-bin.00022 only starting from position 336796712 and skipping the DROP statement at position 336797160: mysql> show binary logs; +——————+———–+ | Log…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… have to be sure the snapshot you’re dealing with corresponds to correct binary log position. There are two sources of information for binary log position SHOW MASTER STATUS – this shows position as master writes its own binary…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
…to load this data on many servers without putting it into the binary log. While this is generally a fast way to… 1M because the rows were small). But how to do this without splitting the file? The…to log the “cool-down period” after the load ended. It would be fun to see that. Cacti seemed to show…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… the logs before I did this, everything in the binary log so far comes from these statements. Let’s look at the binary logs: master > show… not depends, again, on how the stored procedure call is logged to the binary log. Let’s create a stored procedure to hold the transaction, which…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how to identify them… and how to… to the binary log. They are called binary log events. A binary log event contains the server-id where it was executed. Then that event is replicated to… on the active master (mysql 1) is changed to the position returned by SHOW MASTER STATUS on mysql 4 (this position will…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…to log “not usual” queries like Events, Functions, Stored Procedures, Local Variables, etc. We’ll learn what problems can we have and how to…())); Binary Logs: First the event gets logged to the Binary Log:…show a wrong ‘SHOW SLAVE STATUS’ output when using SET user-variables and then using it to…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
…binary logging will be performed by this statement in row-based logs, but the DELETE will be written to a statement based binary log…SHOW SLAVE STATUS now reports an error (many fields omitted): SHOW SLAVE STATUS\G Relay_Log_File: mysql_sandbox25162-relay-bin.000002 Relay_Log… to find is c1=1, but how…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… it’s better to show the client the full extent of the investigations in the first place, and not just show “here’s… possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log… plan, and the desired modifications to the query or the table. We explain how to interpret what we’re showing, and why the proposed…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
…: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay log is corrupted… you want to check the master’s binary log or slave’s relay log, you will be able to know their names by issuing ‘SHOW SLAVE… and it still has all the logs needed to re-fetch events. How would you know if logs are OK on the master ? Well…
