… of concurrent behavior. You may have hidden dependencies of MyISAM table lock behavior in your applications, also check if your application… a while as depending on the schema and usage Innodb tables may increase in size significantly due to fragmentation. Usage Differences… is tuned to be ACID by default – if you’re moving from MyISAM often you do not need such strong guarantees…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…, but QA still needs to have some tables in fresh status. – resharding databases, moving some shards from one server to another. So… still not so easy as with MyISAM tables when you just copy table.frm, table.MYD, table.MYI files, but so nice here – just can copy InnoDB tables in fully non-blocking mode…
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
… this time we worked on features I mentioned before: – Moving InnoDB tables between servers – Improve InnoDB recovery time and rest time we…, with all its benefits like FAST INDEX CREATION, table compression – XtraDB will support moving tables between servers – XtraDB will be released with fast…
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
… were in a new session. We move on to table 2: (root@localhost) [oops4]> alter table dos2 change column fkto3 fkto3 char(32… ascii not null; ERROR 1146 (42S02): Table ‘oops4.dos2′ doesn’t exist (root@localhost) [oops4]> show tables; +—————–+ | Tables_in_oops4 | +—————–+ | dos1 | | dos3 | +—————–+ 2…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
… will see the following MySQL creative error message: mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | queue | | test_innodb | +—————-+ 2 rows in set (0… corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? or, the table contains indexes that this version…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… do on disk temporary tables cause compared to MEMORY tables. To have things comparable I used medium size table and types which can… getting a lot of random writes. OK. Now lets move to testing MEMORY tables for the same queries: mysql> set global key… get 100 times faster than MyISAM on disk table even in case temporary table is small enough to fit in OS cache…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… if your tables are InnoDB the process is a little bit different story. With Oracle’s stock MySQL you cannot move your ibd files freely from one server to another or from one database to another. The reason is that the table… are going to recover only the “salaries” table: Discard the tablespace of the salaries table: mysql> set FOREIGN_KEY_CHECKS=0; mysql…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… ago http://www.mysqlperformanceblog.com/2009/06/08/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases… lock or shutdown server. To export table you need XtraBackup, and you can just specify table or table by mask: xtrabackup –defaults-file=/etc/my.reg.cnf –backup –tables=tpcc.order_line* –target…
Post: Hidden columns of query_review_history table
August 28, 2012 By Leave a Comment
… historical values for review trend analysis into query_review_history table. According to its official documentation you can populate many columns… event attributes list could be outdated as Percona Toolkit was moved from Google Code to Launchpad. So according the above, you… have the following useful columns populated in query_review_history table: * `user_max` varchar(64) DEFAULT NULL – User who executed the…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… Percona XtraDB for a gaming workload (mostly inserts to the “moves” table), I used strace to gather statistics about how the log…
