… MySQL schema and then reload it with a different schema name on the …on larger schemas. One of the downsides to mysqldump is the need to scan the full tables and in turn…in crash recovery and applies the redo-logs to the dirty tablespace and voila, you have a consistent binary backup at a point in…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. … slave’s binary unless log_slave_updates is enabled, this is similar to Percona XtraDB Cluster in that if … latter, make sure to not forget turning the feature back on when you switch to the new cluster …
Post: What is exec_time in binary logs?
January 31, 2011 By 2 Comments
…MySQL‘s mysqlbinlog tool, you’ve probably seen something like the following in…in the replication thread, it will be logged to the replica’s binary log so it can be replicated to other servers in turn…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… issue is binary log or relay log corruption. Will replication checksums help you in this case? Yes, they will! Replication checksums on replicas Checksums on slaves…. We’ll now turn on replication checksums on the slave: slave1 [localhost] {msandbox} ((none)) > set global slave_sql_verify_checksum=ON; Query OK, 0… bug in the master’s or slave’s MySQL code. If you want to check the master’s binary log or slave’s relay log…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… it’s disabled by default.) However, that turned out not to be the cause; the…binary log; otherwise replaying the binary log can result in a different order of execution. The MySQL manual actually says this, but not in… Locked – read Low priority read lock But on INSERT…SELECT, you’ll see this: Read…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…on database server for those things which need to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL…O_DIRECT as from buffered mode ? It turns out it is not always the case…which is not available in MySQL 5.5 (different version is added back in MySQL 5.6) …
Post: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
…binary logs to find the same thing — and match the two up to figure out C’s position relative to A. It turned… record on C actually said approximately which binary log and byte offset to look in? That …in a three-server replication chain. I’m using sandbox servers on my laptop to illustrate: mysql>…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
We made new binaries for MySQL 5.0.67 build 10 which include next fixes: We addressed concerns about potential logging and statistics… fully turn on / off query statistics for microslow patch and user statistics in runtime. Next variables were added: | slow_query_log | ON | | slow_query_log_file…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… if we get any other problems spotted and in the meanwhile we go over binary logs for the last month to see how frequently this functionality is used. Happily there are only few INSERT ON DUPLICATE… tool for MySQL to see what is different in the tables. It turned out one of the float columns stored “-0″ in MySQL 5.0…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
…MySQL Replication speed. My first idea was to check it based on slow query log, happily the server was running MySQL with slow query log…first time after start. I knew in my case most of the …turned my attention to mysqlsla which I remembered parses all kinds of MySQL Logs. Too bad MySQL Binary log…
