…technique ? The problem comes from the fact how MySQL‘s Transactions work with DDL, In particular … data to that table and when drop original table and rename such temporary table to original name. How does… also use Percona Xtrabackup, LVM or other database backup approach which does not relay on …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…to the database may have happened since the backup was taken. Replaying the binary logs brings the database up-to…_name‘,’customer_name…using RENAME TABLE…to prevent wide innodb primary keys on the MV. mysql…how you can combine both types of views together. The complete method examples show how to…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…on the server and go to the directory where the sources archive and the patch is. First you should determine how your current MySQL…to the database configuration, specifically you need to enable slow logging (see Configuration section for details). Then rename…=name Choose how verbose the messages to …
Post: SHOW OPEN TABLES - what is in your table cache
December 14, 2008 By 3 Comments
…to examine what tables do you have open right now: mysql> show open tables from test; +———-+——-+——–+————-+ | Database | Table | In_use | Name…to lock it. Name_locked shows whenever the name for this table is locked. It is used for DROP or RENAME…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…to tmp table | 61.816063 | | rename…to trigger table rebuilds without affecting the table size. mysql> SET expand_fast_index_creation=ON…mysql> SHOW TABLE STATUS LIKE ‘t’\G *************************** 1. row *************************** Name…database…
