…which has given me time to explore new tools using their environments. One tool that I am finding very helpful is…is the properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql…(`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… out there that use MySQL, for which we at….test # ######################################################################## # test.test # ######################################################################## # col2 is a left-prefix of col2_… redundancies that are engine-dependent, like redundant…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…bonding in balance-rr mode; this is the only NIC bonding mode which will allow you to stripe a TCP… can be on the same machine if you use the BLACKHOLE storage engine) in between the actual master and …reaction was, honestly, why would you ever want to use MySQL on top of something like that? I can’t…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…. This feature implementation is considered BETA quality…. the Extended Show Engine InnoDB Status to improve… query cache was used together with InnoDB. Bug …MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my…, which is another advantage of InnoDB. SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database is… is substantially faster than InnoDB both cold and hot. SSB Flight #4 There is one query in this flight, Q4.3, which is faster using…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
…attention is paid to one of these aspects at the cost of the others, the resulting system may be over-engineered, … MySQL HA tools and technologies available today (largely grouped into those which use traditional MySQL replication, those which use some other MySQL-level replication, and those which…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…is a case-by-case decision. There are other drawbacks to using temporary tables in this way, for example when using… the MySQL designers know can be improved. But there’s a finite amount of engineer-years … make a decision about which query patterns the optimizer recognizes, and which are left to the…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… of the MySQL buffer pool is a cross-post from Groupon’s engineering blog, and is Part 1 of… MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a warm standby server which is …You will need Percona Server in order to use innodb_fake_changes. Thread pool Percona Playback…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…PXC) for MySQL is a hot thing right now and …only basic support, primarily because the storage engine is non-transactional and so PXC cannot… async stream, MyISAM is not being replicated at all which I reported on this …events, plus a few additional structures used for certification. Having said that, …
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… of hopes were pinned on MySQL 5.0, which was supposed to target the enterprise customer, and which was available as non-GA… State of MySQL AB is delivered by Marten Mickos. It is truly a year of storage engines, focused on showing what is on top is what… his critique of MySQL Management. Monty is working on the Maria storage engine to replace Innodb for a number of use cases. The first…
