… more complete performance schema, online DDL and several other InnoDB and query optimizer improvements. However, I plan to focus on a series…-, but we will get a warning (note severity, to be exact): mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows affected…) not null auto_increment # To shorten this duplicate clustered index, execute: ALTER TABLE `test`.`test` DROP INDEX `redundant`, ADD INDEX `redundant` (`col2`); # ######################################################################## # Summary…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…patch from MariaDB. This feature adds atomic write support for directFS… vulnerability would allow remote attacker to detect what user accounts exist …, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978…..3 are available in our online documentation. Bugs can be reported…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…: Your application is an online game and you keep track of global achievement statistics in a single table with a row for… your application. These are maintained in separate tables and there also exists a users_groups table to define the relationship between them. When someone joins a group, you run a transaction that adds the relationship row to users…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…local and streamed backups in order to add another layer of protection to the backups. innobackupex now uses …files behind due to a typo. Bug fixed #1172016. Percona XtraBackup would assume the table has been …XtraBackup 2.1.1 are available in our online documentation. Bugs can be reported on the …
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 10 Comments
… pt-online-schema-change, a tool that enables you to ALTER large tables with no blocking or downtime. As you know, MySQL locks tables for most ALTER operations, but pt-online-schema… in the future we will be able to add features to these tools rapidly, for example, to support new types of RAID controllers. Percona…
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
… have to do is create another table with desired table structure and switch .frm table definition files. For safety, I’d recommend to flush tables with…). Let’s have a simple table with auto_increment we want to get rid of: CREATE TABLE `huge_table` ( `id` int(6) NOT NULL…, adding auto_increment does not work that way. Enum values (add and remove). Enumerated values are added and removed the same…
Post: pt-online-schema-change and default values
June 21, 2012 By 1 Comment
… pt-online-schema-change –execute –alter=”add column v varchar(100) not null” D=sbtest,t=sbtest Altering `sbtest`.`sbtest`… Creating new table… Dropping new table… Dropped new table OK. `sbtest`.`sbtest` was not altered. (in cleanup) Error copying rows from `sbtest`.`sbtest` to `sbtest`.`_…
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
… the table structure correctly, and 2) it allows the tool to test the –alter statement: Altering new table… ALTER TABLE `test`.`_t_new` add column… on the table, the number of rows, chunking-related options, etc., but in general you can see how pt-online-schema-change will copy the table using the given SQL statements. Herein lies…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… need. Because I’ve built two such systems to manage online ads through Google Adwords, Yahoo, MSN and … But you still have to think about how to avoid enormous tables that are hard to maintain, back up, and… and non-blue clicks stored, and to get the totals you add them. Did this gain us anything?…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to build for massive scalability, how to do read-write splitting without breaking the user experience, how to take online…”garbage” query that just adds latency and makes the overall time to complete an action …an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might…
