… the application evolves, additional requirements will appear like hot backups, online schema changes, replication based high availability (which has some caveats). Also…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… bitmap files. Bug fixed #1184427. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS… MySQL 5.1.69-17.4 are available in our online documentation. Bugs can be reported on the launchpad bug tracker…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…-intensive workloads. Bug fixed #1171699. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS… MySQL 5.6.11-60.3 are available in our online documentation. Bugs can be reported on the launchpad bug tracker…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer improvements. However…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… with the fix for bug #710799. This regression caused mysql schema to be missing after the clean RPM installation. Bug fixed… MySQL 5.5.31-30.3 are available in our online documentation. Bugs can be reported on the launchpad bug tracker…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… significantly (e.g. pt-query-digest, pt-upgrade, and pt-online-schema-change). Here are some highlights: Official support for MySQL 5… to evolve to support it. pt-online-schema-change (pt-osc) is much more resilient pt-online-schema-change 2.1 has been a… may affect you, see Ovais’s article. In short: pt-online-schema-change 2.2 is far more resilient out of the…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… when performance problems happen randomly or are very short pt-online-schema-change, to run ALTER TABLE statements on large tables without…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… “hotspots”. Examples of hotspots Example 1: Your application is an online game and you keep track of global achievement statistics in… SET count = $last_count where achievement = ‘killed_troll’”; } change your schema In Example 2, above, how above moving the ‘joined’ column…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… a server or database upgrade, change in my.cnf or schema change can affect the overall performance of your MySQL database… bugfixes for Percona Playback for MySQL are available in our online documentation. Bugs can be reported on the launchpad bug tracker…
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
pt-online-schema-change is simple to use, but internally it is complex. Baron’s webinar about pt-online-schema-change hinted at several of the tool’s complexities. Consequently, users often want to know before making changes what pt-online-schema…_country` < ?) OR (`guest_language` = ? AND `guest_country` = ? AND `score` <= ?)) /*pt-online-schema-change 10451 copy nibble*/ SELECT `guest_language`, `guest_country`, `score…
