… are stored in a table. Storing the results of a SQL statement into a table (even a temporary table) is called materializing the… the view may occupy twice as much space (similar to ALTER TABLE) Supports all SQL syntax (like outer join) but can’t… last blog post will describe how to use Flexviews for online schema change, or as an ELT* tool and it will…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… the upstream bug #67974, which caused server crash on concurrent ALTER TABLE and SHOW ENGINE INNODB STATUS. Bug fixed #1017192 (Sergei Glushchenko… needs to have at least one of those tables specified in the replicate-ignore-table. Bug fixed #1068210 (George Ormond Lorch III… Server 5.5.29-30.0 are available in our online documentation. Bugs can be reported on the launchpad bug tracker…
Post: When should you store serialized objects in the database?
January 21, 2010 By 47 Comments
… that ALTER TABLE commands are no longer required. Until 5.1-plugin simple operations like adding a secondary index on an InnoDB table require the whole table to be rebuilt (now just the index is… master-slave switching I’ve always been able to emulate online index adds. Projects like MMM and Flipper make this even…
Post: Sharding and Time Base Partitioning
March 14, 2008 By 12 Comments
For large number of online applications once you implemented proper sharding you can consider your … version creation. It may make sense to separate data on table (or partition) level to get better “clustering” – because data is… time to backup and restore it is easier to do ALTER TABLE and replication would not fall behind as easily. You can…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… of parallel query execution makes limits how much IO full table scan queries can consume. If we look at single Server… because operationally working with large table and data sizes in MySQL can be painful, lacking online operations to alter table, defragmentation etc. Yes there…
Comment: Picking datatype for STATUS fields
August 11, 2008 By 24 Comments
Peter: You should also note that ALTER TABLE to add new entries to the end of an ENUM/SET definition in 5.1 is an online operation and requires no table rebuild. So this major drawback to ENUM is corrected.
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
… – waiting on database (or other) operations to complete – backup, restore, ALTER TABLE, load testing – all of these things take time and make… the visit. If appointment is just a phone call or online meeting there is larger chance it can be forgotten by…
Post: Percona Toolkit 2.1.9 is ready
February 15, 2013 By Leave a Comment
…option. * Fixed bug 918056: pt-table-sync false-positive error “Cannot nibble table because MySQL chose no …if those chunks had diffs. * Fixed bug 1099836: pt-online-schema-change fails with “Duplicate entry” on … key is tricky, the tool stops if –alter contains “DROP PRIMARY KEY”, and you have to…
Comment: Using MMM to ALTER huge tables
March 28, 2008 By 11 Comments
… idea, but what do you do if you have to alter the structure due to better performance? While rading this article… have to alter the relationship of tables). Then you will change application to use these new views instead of the old tables, because… it can load all changes from the master who was online. Now you have got one master with all data and…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 19, 2012 By 10 Comments
… a great tool. We have some large tables and sometime we have to alter these table for business requirement which is very painful. Even yesterday I got requirement from my bosses that if we could do online alter…
