…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: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
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: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…How to make the tools connect to MySQL The slides are now available here, and slide 7 provides a basic introduction to Data Source Names…to write to the master. Q: How about pt-table-checksum with databases…rename table itself should be fast, but as it needs 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: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
…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: 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…
