… NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `id` int…you have any implicit constraints that you might have missed and can then write into your metadata file. Donate -… Feel free to answer via the comments. Thanks for reading…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… and thus does not need to read any bitmap files. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause… was missing. Bug fixed #1179974. A warning is now returned if a bitmap file I/O error occurs after an INNODB_CHANGED… overhead from the Handle Corrupted Tables check as it was missing branch predictor annotations. Bug fixed #1176864. Other bug fixes: bug…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and… this, maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 mode works well… drive, instead of crashing InnoDB, it will be caught by ZFS and the data will be read from the other drive in…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 22, 2013 By 32 Comments
Does Percona have improvements to keep the InnoDB insert buffer from getting full (as in do background reads for ibuf merges when it is getting full)? That is the key to sustaining good throughput for InnoDB on iibench.
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… illumos ZFS by giving up 10% total ram for metadata caching, but it is just the price you should be willing… a lot. So OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… something you’re not that familiar with, I’d suggest reading over the manual’s description of how replication filtering rules… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… double caching by the file system vs the InnoDB caching. However, limited ARC size also limits ZFS file system’s internal metadata caching(which…) You need to sacrifice a little ram for ZFS metadata caching to make ZFS fast. NexentaStor recommends minimum 1-2GB ram…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… we did above. So we will suppose that we can read the binary logs of the crashed master. The first thing… slave will be the new master is to recover the missing events with mysqlbinlog. Let’s say that we want to…-b985-0800272864ba:1. How can I instruct mysqlbinlog to start reading from there? Unfortunately, there is no –start-gtid-position option…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
@JDempster: I could give the SSD to xfs also with Flashcache and the like. Don’t forget all these jbods have a raid controller write cache in front of them. I also did the Innodb tuning. @Nils: no fuse, direct kernel support. Look here: http://zfsonlinux.org/
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… cost difference. ZFS provides built in checksumming and double write buffering, so make sure these are turned off in InnoDB.
