… engine. In my testing I discovered that innodb_old_blocks_time had an effect on performance of the benchmark. There was…{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight examines different time periods or different regions. The flights represent the type of…-up post about concurrency in another blog post in this series. Regardless, when the working set fits in memory, InnoDB almost…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… current implementation. This post is the first one of a series of articles focused on the implications of enabling GTIDs on… by making the master read-only. However, “at the same time” means “at the same binlog position”, so you can perfectly… try: GTIDs enabled, mixing regular replication and GTID replication This time, we will enable GTID replication on slave #1, but not…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… query optimizer improvements. However, I plan to focus on a series of posts on the small but handy improvements – changes and… about this on my last webinar, but did not have time to analyze it in-depth. If you try to do…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… release is the latest stable release in the 2.1 series. Bug Fixed: Percona XtraBackup 2.1.2 would hang when… bandwidth Automatic backup verification Higher uptime due to faster restore time XtraBackup makes MySQL hot backups for all versions of Percona…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…, and improvements make this a great new series. It replaces the 2.1 series for which we plan to do only one….2 retries every critical operation, and its tries and wait time between tries for all operations are configurable. Also, we removed… in 2.2 to make their run-related options (–run-time, –interval, –iterations) standard. If you hadn’t noticed, one tool…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… those results. Disclosure: The research and testing for this post series was sponsored by Virident. Usability is, to some extent, a… page threshold, flushing the cache on demand, or having a time-based cache flushing mechanism, but some of these features operate… setting called “fallow_delay”, defined in the documentation as the time period before “idle” dirty blocks are cleaned from the cache…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
This is the second part in a two-part series comparing Virident’s vCache to FlashCache. The first part was … have “no cache”, “FlashCache”, “vCache with no time-based flushing”, and “vCache with time-based flushing.” As the images demonstrate, the no… –report-interval=1 –rand-type=pareto \ –forced-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… about the annual MySQL User Conference’s history – the 9 times it previously took place in its various reincarnations – and there… I recall one of them saying something like, “12 full-time engineers are working on MySQL server.” The MySQL Certification program… GA release in the MySQL 4.0 series, and for the first and only time in a MySQL version you could buy…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… used (currently 2.0.7 in the 2.0 series at the time of writing). New Features: This version of Percona XtraBackup…-copy-interval. Making the interval configurable allows to reduce the time between checks which can prevent XtraBackup failures that are caused… and slow IO then XtraBackup can spend a lot of time opening all the tablespaces. Optimization has been implemented and XtraBackup…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… current GA (Generally Available) stable release in the 2.0 series. New Features: This version of Percona XtraBackup has implemented full…-copy-interval. Making the interval configurable allows to reduce the time between checks which can prevent XtraBackup failures that are caused… and slow IO then XtraBackup can spend a lot of time opening all the tablespaces. Optimization has been implemented and XtraBackup…
