To recover a dropped or corrupt table with Percona Data Recovery Tool for InnoDB … the table structure in an InnoDB page. Normally we either recover the structure from .frm files or take it from some… page_parser ./page_parser -f /var/lib/mysql/ibdata1 3. Recover SYS_TABLES, SYS_INDEXES, SYS_COLUMNS and SYS_FIELDS from…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…. While TokuDB averages around 14000 tps mark with some periodical drops into 10000 tps area. TokuDB datasize after 5h of run…-sec checkpoint interval, as TokuDB does time-based checkpoints. These drops are quite concerning, and it might be a problem for…_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… the most consistent performance. The others all have assorted performance drops scattered throughout the graph. We see the exact same pattern…_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… table dictionary corruption when it may be much harder to recover the table. In this example I actually went ahead and… series of queries with LIMIT can be handly if you recover manually: mysql> insert ignore into test2 select * from test limit… is also helpful in cases you’ve want to recover deleted rows or dropped table. I should also mention at Percona we…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… use XtraBackup to avoid the server shutdown. You must not drop, truncate or alter the schema of the table after the… time and some headaches 
Instead of recovering all the InnoDB data we are going to recover only the “salaries” table: Discard the… is back again! Conclusion: As we learned , you can also recover single InnoDB table as with MyISAM but knowing in advance…
Post: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
… 100% recovered if they were not overwritten yet, as well as recover dropped Innodb tables. We also can get some data recovered from covering… request because neither MySQL nor Oracle could help them to recover the date so we had to get our hands dirty… release code for our innodb recovery toolset, so you can recover your data for free if you’re ready to spend…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
… because mysqldump in many cases generates the “DROP TABLE” instruction before the “CREATE TABLE”: DROP TABLE IF EXISTS `actor`; /*!40101 SET @saved… TABLE” make the recovery any harder? When a table gets dropped InnoDB deletes respective records from the dictionary – tables SYS_TABLES… marked as deleted. That’s why it was possible to recover them with -D option. When a user immediately creates the…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…drop_eventblogpercona.commanual Com_drop_functionblogpercona.commanual Com_drop_indexblogpercona.commanual Com_drop_procedureblogpercona.commanual Com_drop_serverblogpercona.commanual Com_drop_tableblogpercona.commanual Com_drop…commanual myisam_recover_optionsblogpercona.commanual myisam_recover_…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…, otherwise garbage-in, garbage-out and you risk dropping necessary indexes. To accomplish merging multiple result sets,… 0.02 | +————–+—————+—————————–+—————+ 22 rows in set (0.02 sec) Recovering filesystem space Now astute innodb experts will realize …
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
… to them as well. (root@localhost) [oops4]> drop database oops4; ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./oops4′, errno: 39… day. The one thing that you can do, fortunately, is recover the data into a new table, but you’ll need… database is still potentially inconsistent, and you can’t explicitly drop those temporary tables or rename them. This looks somewhat like…
