… MySQL Sunny Bains, Senior Principal Software Engineer, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” Luís Soares, Senior Software Engineer…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
….6 content continues Tuesday morning when Tomas Ulin, VP, MySQL Engineering for Oracle, will present an invited keynote on “Driving MySQL… New in InnoDB” by Sunny Bains, Senior Principal Software Engineer “MySQL 5.6: Redefining Replication” by Luís Soares, Senior Software Engineer The Tuesday…
Comment: Should you move from MyISAM to Innodb ?
March 27, 2013 By 59 Comments
… specific article by Peter Zaitsev my general understanding of DB engines and the desire to investigate them has been broadened and… never went deep enough to make well informed decisions about engines and other optimizations. Getting very involved in e-commerce I… DBA to help me past MyISAM. Along with MySQL’s InnoDB, I also have PostgreSQL on my radar for future more…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 30, 2013 By 10 Comments
… to http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-internals.html there are some caching settings to play… specifies whether to use InnoDB as the data store of memcached (innodb_only), or to use the traditional memcached engine as the backstore… key in memory, it searches for the value in an InnoDB table.” I’d like to see the results with all…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 28, 2013 By 26 Comments
… try to convert 240 GB InnoDB table to TokuDB: “ERROR 1030 (HY000): Got error -1 from storage engine” The table has approximately 1.6 billion rows and I used “ALTER TABLE ENGINE=TokuDB” to do the conversion. Any idea on the possible…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… MySQL buffer pool is a cross-post from Groupon’s engineering blog, and is Part 1 of 2. Thank you to… –session-init-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting… server. You will need Percona Server in order to use innodb_fake_changes. Thread pool Percona Playback added a connection pool…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 11, 2013 By 13 Comments
… it may be much better than InnoDB, but I assume for 99% applications/workloads mainline innodb/xtradb with mysql/percona/mariadb server… first chance ever to have a MVCC/fully transactional storage engine outside Oracle that works. So MariaDB could profit most from…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… – 5.1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware: Node:2 CPU…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…, however, MyISAM has only basic support, primarily because the storage engine is non-transactional and so PXC cannot guarantee the data… so. However, if you can, you should consider moving to InnoDB altogether. There are very few reasons to stay with MyISAM…
Comment: BoardReader - Forum Search Engine
April 9, 2013 By 13 Comments
Peter, I use InnoDB for my Mysql Engine. And I know it is safe for deals of bank trades. Does it get something relative with the cpu? Will it take much cpu? And how these are calculated?
