… and DROP TEMPORARY tables are not supported inside transaction. 2. Updates involving non-transactional storage engines – It is not possible to mix… issue can arise if slave host is using different storage engine for the respective table on master databases. Also, if BINLOG… master/slave db. 3. CREATE TABLE …. SELECT – It is not supported to perform such type of statements http://mysqlopt.blogspot.co…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… ported the Atomic write support for Fusion-io devices patch from MariaDB. This feature adds atomic write support for directFS filesystem on… and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage diagnostics. Bugs Fixed…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… NULL, `SPACE` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 `NAME` is a human readable table…_NAME` varchar(255) DEFAULT NULL, PRIMARY KEY (`INDEX_ID`,`POS`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Fields names explain their content. Index… good enough for the recovery. DECIMAL fields are not fully supported. If a field was of DECIMAL(5,2) type sys…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… users with greater choice in terms of both functionality and support. As a result of that choice, we are seeing the… Cloud: Present and Future” Tomas Ulin, Vice President of MySQL Engineering, Oracle Keynote Topic: “Driving MySQL Innovation” Wednesday Robert Hodges, CEO…: Performance Benchmarks, Tuning, and ‘Best’ Practices” Luís Soares, Senior Software Engineer, Oracle Topic: “MySQL 5.6: Redefining Replication” Breakout Sessions on…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…! MyISAM tables are supported within Percona XtraDB Cluster, however, MyISAM has only basic support, primarily because the storage engine is non-transactional and… work well with those and even if there is basic support when wsrep_certify_nonPK is enabled, you can still hit…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 11, 2013 By 13 Comments
… it passes a certain breaking point, you can either get support from Tokudb or then decide to spend on something expensive… of work, money and resources, no matter how the sales engineer tries to tell you it is just plug and play… by opening up their software and lining them up for support contracts down the road.
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
…, it is much easier to get people to pay for support once they have been using your open source product for… having other companies in the community spend resources integrating their engine in their MySQL branch/fork. Definately QA, discussions and suggestions…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… of time and energy into development of MySQL with an engineering team of over 200 developers The release process is more… organizing the event. Kortney could not have succeeded without the support of our multiple service vendors including Ireland Presentations, Carleson Production…
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… for debugging purposes. Streaming logs from stdin Percona Playback now supports the –query-log-stdin command-line option for accepting a…
Post: Percona is looking for a Support Engineer
November 16, 2010 By 1 Comment
… and with the introduction of our Support and Maintenance services, we’re looking for a new Support Engineer. You would be a part… for our customers. Responsibilities include handling or dispatching emergencies and support requests, triaging incoming issues, and ensuring customers always get the…
