…after the hot test. All OS caches are dropped at this time as well. These set …ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql…dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed: Percona XtraBackup would crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… for new MySQL 5.6 features (GTID, remote/transportable tablespaces, separate undo tablespace, 5….TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables…5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a …
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
… is because mysqldump in many cases generates the “DROP TABLE” instruction before the “CREATE TABLE“: DROP TABLE IF EXISTS `actor`; /*!40101 SET @saved_cs_client… 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… to grep etc. Using information from UNDO segment SYS_TABLES and SYS_INDEXES are normal InnoDB tables. They’re also ruled by MVCC…
Post: Announcing Percona Server 5.5.27-28.0
August 23, 2012 By 5 Comments
… MySQL As A Service. New Expanded Program Option Modifiers have been added to allow access control to system variables. New table INNODB_UNDO… the undo segment. This information is ‘live’ and calculated for each query of the table. Bugs Fixed: Fixed incorrect merge of MySQL bug… bug exists and it’s setting up the innodb_lazy_drop_table to 1. Release notes for Percona Server 5.5.27…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…defined types are: FIL_PAGE_INDEX, FIL_PAGE_UNDO_LOG, FIL_PAGE_INODE, FIL_PAGE_IBUF_…taken from some MySQL server. 0. Create empty InnoDB tablespace. 1. Create the table: mysql>CREATE TABLE actor ( actor_…in InnoDB dictionary for table test/t2 In this case you need to drop table `test`.`t2` and create…
Post: XtraDB storage engine release 1.0.2-2 (New Year edition)
December 29, 2008 By 20 Comments
… is fixed value. This patch expands the maximum number of undo slots to 4072 and allows better utilizing modern hardware. (Thank… compiled in into MySQL-5.1.30 RPM as separated shared library, to use as drop-in plugin for existing MySQL-5.1.30 installation XtraDB is compatible with existing InnoDB tables (Warning: unless you…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… would be just the table it should have been easy – dropping the table with corrupted page …undo buffer. True this would leave some tables corrupted but at least you could get by by dumping in reimporting couple of tables…sorts of different things: Versions later than MySQL 5.0.33 are not frequently …
Post: Small things are better
October 8, 2006 By 15 Comments
… ALTER TABLE to rebuild the table fixes it. Sometimes table needs to be dropped and recovered…if corruption is happens to be in undo tablespace or log files. So …tables allow per table backup and recovery to happen faster. With MySQL and blocking ALTER TABLE there is yet another reason to keep tables…
