On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register to…query optimizer and see how easy it is? ;-) …to match the order of columns in the index. Example: WHERE (last_name, first_name) = (‘Karwin’, ‘Bill’); Q: On…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… on June 3rd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL… the directory and file name components in a bitmap file name could stop the server starting… INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… of using GTIDs is to have much easier failover than with file-based replication. We will see how to change the replication topology… focused on MySQL 5.6 GTIDs. You can find part one here. Our goal will be to go from setup #1 to setup #2 on… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5.31-30.3 on May 24, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL… (see MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding the…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10… tests a database‘s ability to optimize queries for a star schema. A star schema presents some unique challenge to the database optimizer. The… similar to Flight #1. MyISAM is faster than InnoDB when the database is cold, but the opposite is true when the database is…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… of articles focused on the implications of enabling GTIDs on a production setup. The manual describes very nicely how to switch to GTID-based replication… enable GTID replication on slave #1, but not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
It may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP… table on master databases. Also, if BINLOG_FORMAT is not consistent on master/slave db. 3. CREATE TABLE …. SELECT – It is not supported to…
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
… MySQL to thin clone databases meaning using a snapshot of a source database and provisioning clones from those snapshots. We are writing a book on… multiple copies of the source database. Would be interested if someone wanted to contribute on the MySQL side. Interesting that on Wikipedia Data Virtualization is…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
… Moazam, 1) no, you don’t have to export databases, you can use the existing mysql data dir. But check http://www.percona.com/doc/percona-server/5.1/compatibility.html if you’re planning to…/5.1/feature_comparison.html 3) we’re not planning to release the windows versions of Percona Server at the moment
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… a large innodb database, do I have to export databases from mysql and import them in Percona server or can I use mysql data directory? 2. What’s the advantage of using Percona server over MySQL? 3. I am using CentOS for my servers but i…
