Fabian, – please note that, as stated in the article, this technique only works well for highly selective …
Comment: Sphinx search performance optimization: attribute-based filters
June 13, 2013 By 11 Comments
Comment: Performance Schema overhead
June 12, 2013 By 22 Comments
Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering 
Thanks for sharing.
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of …or OFF on all servers, but not something in the middle. What if we try to reconfigure the master? …auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create table …
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…in it, Percona Server 5.5.31-30.3 is now the current stable release in the 5.5 series. All of Percona’s… release can be found in the 5.5.31-30.3 milestone at Launchpad. New Features: Percona Server …This vulnerability would allow remote attacker to detect what user accounts exist on the server. This …
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… in it. All of Percona’s software is open-source and free, all the details of the release can be found in the 5.1.69-14.7 milestone at Launchpad. Bugs Fixed: In Ubuntu Precise libmysqlclient18 package was chosen from the distribution’s… the oldest untracked log records are overwritten by the new log data. In some corner cases this could lead to assertion errors…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… naming your keys with a consistent pattern. This new behavior was introduced in 5.6.7 with the closing of this bug (although… explains more in detail what the “will be disallowed in a future release” means. In MySQL 5.7 the checks will be stricter: in the default… definition in the same order. In other words, it checks for duplicate keys, but not redundant ones. What is the difference? Let’s see…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. Our… recover data from the crashed master, but that’s another story). In this case, you will have to promote the… slave will be the new master is to recover the missing events with mysqlbinlog. Let’s say that we want…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…in it, Percona Server 5.6.11-60.3 is the first RC release in the Percona Server 5.6 series. All of Percona’s…in the 5.6.11-60.3 milestone at Launchpad. This release contains all the bug fixes from latest Percona Server 5.5 release (currently Percona Server 5.5.31-30.3). New Features…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… post in our blog. Starting with 5.1, the new plugin API gives us more flexibility by allowing users to extend the server’s functionality with their own code, and this is what the McAffee plugin does. Installation and…”:”Connect”,”query”:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL’s behavior in a way that, once…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… informative flowcharts in addition to the textual explanation. Q: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6… customer that’s using 5.6), is that I question its readiness. There have been some unfortunate performance regressions compared to 5.5, such… and receive a response back in a reasonable (what is reasonable is determined by your environment), it’s a safe bet that MySQL…
