…mysql> drop view if exists all_indexes; mysql> create view all_indexes as select t.table_schema as TABLE_SCHEMA, t.table_name as TABLE…02 | +————–+—————+—————————–+—————+ 22 rows in set (0.02 sec) Recovering filesystem space Now astute innodb experts …
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
… why it was possible to recover them with -D option. When a user immediately creates the same table InnoDB adds the records… same position in the pages. So, table_id and index_id of the dropped table gets overwritten. mysql> CREATE TABLE actor ( -> actor_id SMALLINT UNSIGNED… review an example: # ./s_tables /var/lib/mysql/ibdata1 sakila/actor sakila/actor 15 # ./s_indexes /var/lib/mysql/ibdata1 15 0-18…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
…: MySQL had a dedicated partition on XFS file system Server was running innodb_file_per_table…DROP DATABASE X on the wrong machine (production master) All slaves followed and dropped their copy of the data The important tables…xfs – we all agreed on few things: recovering files from xfs is hard, if at…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… that would be just the table it should have been easy – dropping the table with corrupted page would remove…0.33, meaning you could not really recover corrupted Innodb tables this way for about 6 months. What…all sorts of different things: Versions later than MySQL 5.0.33 are not frequently used True…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… for MySQL service we recognize that reliable backups are one of the most important things we can bring to the table. In… be removed or overwritten A table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server or… that server A disk failed, and RAID array does not recover You run into a InnoDB corruption bug that propagates via…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… to do roll forward recovery while recovering from backup. There are however some …tables are not taken into account. The traditional pre MySQL 5.0 way to break such replication is also using multi-table…. For example cloning Master (and dropping not replicated tables) to set up replication becomes …
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… examples, it would be pt-query-digest –review S=/tmp/mysql_sandbox5527.sock,u=msandbox,p=msandbox,D=percona,t=reviews… tables can make your ibdata file grow a lot. As is known, this space won’t be recovered when the auxiliary table is dropped unless you’re using innodb_file_per_table. Q: Does pt-online…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… worst onces, because you can’t really recover data on per table basics. Also if MySQL crashes during recovery lower values of innodb… now dump potentially corrupted tables (in this particular corruption instance Innodb did not print table name in question), drop tables, restart Innodb without innodb…
Post: Small things are better
October 8, 2006 By 15 Comments
… kind be mild, so ALTER TABLE to rebuild the table fixes it. Sometimes table needs to be dropped and recovered from backup but in certain… recover, smaller tables allow per table backup and recovery to happen faster. With MySQL and blocking ALTER TABLE there is yet another reason to keep tables…
