…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would be… the binary log; my experience has been that this is a very dangerous thing to do and causes way too many bugs in the server and the tool, so there is no code in the tool that disables binary logging at all…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | mysql-bin.000023 | 107 | +——————+———–+ 23 rows in set (0.00 sec) mysql… or encounter and LVM bug, your snapshots are useless. …
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… MySQL version and starting new one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL… it scales well. There have been number of scalability bugs in MySQL history when issues would only happen at high load. You… the final backup before upgrading and make sure to keep binary logs for some time, in case you run into some serious…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… of examples for High Performance MySQL book. In the bug Heikki explains the code was probably removed in MySQL 5.0 during XA… expected. Innodb during recovery also prints position in the MySQL binary log: InnoDB: Last MySQL binlog file position 0 589600615, file name ./galax-bin… master, or later use for point in time recovery using binary log.
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… VALUES(YEAR(CURDATE())); END;// mysql> CALL this_pyear(); Binary Log: #111213 23:33:41 server id 1 end_log_pos 2055 Query thread_id…: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql> insert into t VALUES(@this_year) Binary Log: #111213 23:58:11 server id 1 end_log… note here. There is a bug related with this described on https://bugs.launchpad.net/percona-server/+bug/860910. In a master-master…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… a bug. The temporary table shouldn’t be logged out-of-order on the master like this (I suspect it’s logged out… see what’s in the binary log: master > show binlog events in ‘mysql-bin.000011′\G *************************** 1. row *************************** Log_name: mysql-bin.000011 Pos: 4…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… you have some hardware problems (99%) or found new Innodb bug (1%) Innodb recovery should be automatic and bring your database… use innodb-safe-binlog option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL 5.0 XA is taking care of this synchronization. .frm Corruption – Few people know MySQL is…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
… log event entry. The possible reasons are: 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… 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: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… with more performance results but as we can see the bug is still in Verified stage and there is no indication… so you may not get same performance as with MySQL 4.1 Disable Binary Logging This allows to get group commit back but obviously you loose point in time recovery and replication. Use innodb_flush_log…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… workloads on servers. Best if you can analyze full query logs but if this is not possible at least look at… and file the bug at this point. Check Binaries Make sure you’re not using debug binary or differently optimized binaries. When you’re about to file a bug or report the problem through MySQL support channel…
