…of the remaining questions here. Q: Isn’t it possible to take all the locks required in the … why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? …1 version of the tool does NOT have any features to disable the binary log; my experience has been that …
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…i | +——+ | 21 | | 25 | | 26 | | 30 | +——+ Phantom reads do not occur if you’re simply …How to troubleshoot gap locks? Is possible to detect those gap locks … 3 row lock(s), undo log entries 1 MySQL thread id 3, OS … replication you should change the binary log format to “row”. Depending on the…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
…binary logs are essential part of creating good backup infrastructure as it gives you the possibility…connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/…. By default if you do not supply the binary log file, mysqlbinlog deletes and overwrites …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… row-based binary logs (RBR). If you don’t have MySQL 5.1 or aren’t using RBR, then it is possible to set… from a MySQL master. I’ll talk more about that in another blog post. FlexCDC does not implement a full binary log parser. Instead… binary logging not being enabled) it will exit with an error. It will exit with a message “setup completed” otherwise. Verify installation The binary log…
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… the final backup before upgrading and make sure to keep binary logs for some time, in case you run into some serious… if you need to. In other cases however it is not possible as MySQL only fully support slaves newer than the master. Older…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery after … query execution time. It may be possible, therefore, to refresh an MV based …the incrementally refreshable version does not take long to refresh: mysql> call flexviews.refresh( -> flexviews.get_id(‘…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… servers. Best if you can analyze full query logs but if this is not possible at least look at network traffic from tcpdump… 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…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… and fast updates which go after it in MySQL binary log can’t proceed. It is either more than … of one large update to help MySQL replication lag it is not going to work. This brings us … hardware purchases or development efforts based on assumption MySQL replication can’t possibly keep up any more…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… in additional to IO resources which may not be available, especially for CPU bound MySQL Load. The benefit in this case is… but still not quite enough. Also note the serious leap in compressed file size. Though in this example we used MySQL binary log file… generated with 13 MB/sec. For all archivers it is possible to use parallel compression to get better speed though this…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… there is with other databases, at least not in the same way. Windows in particular …joins whenever possible, because of things like the lower startup cost for the query). But MySQL isn’…MySQL replication is one of the core, fundamental features — and it’s single-threaded and relies on the binary log…
