… ibdata was updated MySQL will fail to start with error: InnoDB: Reading tablespace information from the .ibd files… InnoDB: Error: trying to add tablespace 15 of name ‘./sakila/customer.ibd’ InnoDB…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…for our customers: Failed or full LVM snapshots. LVM backup strategies can fail to delete snapshots …pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as… are like credit card debt: easy to start, impossible to dig out afterwards. Another very…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… see how this works now. Metadata Locking behavior starting MySQL 5.5.3 Starting with 5.5.3 DDL statements that modify… auto_increment primary key) ENGINE=InnoDB; When using MySQL 5.1 the second CREATE would just fail immediately with the error “ERROR… null auto_increment primary key) ENGINE=InnoDB; However, I feel that the CREATE TABLE should fail in such a case when the…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… line option innodb_changed_pages_limit. MySQL option handling would then shadow the former with the latter, resulting in start up errors. Fixed by renaming the innodb_changed_pages_limit option to innodb_max_changed_pages. Bug… tracking wasn’t compatible with innodb_force_recovery=6. When starting the server log tracking initialization would fail. The server would abort on…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… not possible. Gathering information about the server I start off with these commands: date uname -a cat /… be running the query, and if the query fails, then you know from the error code that … that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The …
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
… regards to storage engine initialization. Previously if you start MySQL and Innodb storage engine fails to initialize (ie you resized log file but forgot to delete old ones) MySQL Server simply would not start… accessible not catching such errors. If MySQL is started with Innodb tables disabled accesses to Innodb tables will simply result in errors. The…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… statements. There is a chance of failing for example during CREATE statement with table created in Innodb dictionary but .frm not created… files or .frm being unsync with internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL 4.1… basing my failure handling scenarios. Cold Start – If you restart MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
… tracking wasn’t compatible with innodb_force_recovery=6. When starting the server log tracking initialization would fail. The server would abort on startup. Bug fixed #1083596 (Laurynas Biveinis). InnoDB monitor was…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_file_size=64M You can start your first node now. Make sure that you only start…: 97, protocol version: 2 120619 13:20:19 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on a micro instance, simply…=16 innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb-rollback-segments=16 innodb-stats-auto-update=0 innodb-stats…
