On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still… queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But there’s a finite… more efficient in this case to force MySQL to scan the `title` table first, grouping by kind_id in index order. This made…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… reception at the famed Paddy’s Bar and Grill sponsored by Tag1 Consulting featuring great networking possibilities and free drinks for… MySQL, then this is an event you can’t afford to miss… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the ideal of Percona MySQL University and would…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
…, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101… = ‘f’ and cai.trash = ‘f’ and (cai.status is NULL) group by ld.label_id, cai.inventory_id All 4 tables in…
Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
…MySQL 5.6 at the Percona Live MySQL Conference: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” by Dmitri Kravtchuk, MySQL Performance Architect “MySQL… morning continues the MySQL 5.6 focus at the Percona Live MySQL Conference. A distinguished group of MySQL experts from HP…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…(inclusive). Quorum is computed using weighted sum over group members. Percona XtraDB Cluster binary will …included the old version of innotop. Fixed by removing innotop and its InnoDBParser Perl …. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… the next few years despite the buzz created by NoSQL alternatives Despite the buzz, MySQL is still much more common than even… 451 Research’s database survey by viewing the research report “451 Research database survey points to MySQL gravitational tug of war” on… of our multiple service vendors including Ireland Presentations, Carleson Production Group, Tricord, the Hyatt Santa Clara, and the Santa Clara Convention…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…, really matters (really!). By enforcing replication to …groups, but also updates groups with some metadata: BEGIN; INSERT INTO users_groups (user_id, group_id) VALUES (100, 1); UPDATE groups…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered (by design), but one thing I regret… replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding… to continue. This prevents any node in the synchronous replication group from getting too far behind the others in applying replication…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… first post on MySQL transaction descriptors optimization introduced in Percona Server 5.5.30-30.2 and a followup by Dimitri Kravchuk… read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are, by definition, read-only transactions… = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb_read_io_threads…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
…mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql…-SHA by default socket.ssl_compression = yes by … settings as regular group communication (gcomm). Will …
