…, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA… with 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…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… Starting gfs_controld… [ OK ] Unfencing self… [ OK ] Joining fence domain… [ OK ] Starting Pacemaker Cluster Manager:…MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
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… upcoming Percona Training classes in North America and Europe. Join Percona and the MySQL community at our events. The next one is…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/dev…
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…(1) as installed_count from client_app_inventory cai inner join device d on (cai.client_id = d.client_id) inner…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
… KEY (`id`)) —————————————————————————————————— $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db(‘test’,$mysql); function display_menu($parent, $level) { $result = mysql_query(“SELECT a.id, a.label, a.link, Deriv1.Count FROM `menu` a LEFT OUTER JOIN (SELECT parent, COUNT…
Post: Network at the Percona Live MySQL Conference and Expo
March 28, 2013 By Leave a Comment
… you can join attendees with similar interests to discuss common topics of interest and forge new contacts with other MySQL enthusiasts. The…, opportunities to network abound at the Percona Live MySQL Conference and Expo. Connect with MySQL community members in the hallways between talks… what’s available. Join us in Santa Clara from April 22nd through the 25th for the premier MySQL community gathering of the…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… sessions including presentations on Oracle MySQL, Percona Server, and MariaDB during the Percona Live MySQL Conference. Percona Live MySQL Conference Keynotes Tuesday Peter… Ulin, Vice President of MySQL Engineering, Oracle Keynote Topic: “Driving MySQL Innovation” Wednesday Robert Hodges, CEO, Continuent “How MySQL Can Thrive in the… and big data. If you can join us in Santa Clara for the Percona Live MySQL Conference and Expo, use discount code…
Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
… “Driving MySQL Innovation”. In addition, Oracle MySQL technologists will lead three breakout sessions on 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… Percona Live event yet. Please join us in Santa Clara, April 22-25 for the Percona Live MySQL Conference and Expo. As…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually…_groups table to define the relationship between them. When someone joins a group, you run a transaction that adds the relationship… to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think about the…
