… on the table. mysql> show processlist; +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ | Id | User | Host | db |…READ LOCK and fail backup or kill…you’re just using Innodb tables and you’…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
…, we bring up the new mysqld, which finds a crashed innodb, recovers this, and then it is being configured to become… once in a while the recovery of the innodb in the target location fails, though, even though it has been made even… have been experiencing this with many versions of MySQL. We are now using ‘service mysql stop’ instead of FLUSH TABLES WITH READ…
Post: How to change innodb_log_file_size safely
July 9, 2011 By 14 Comments
If you need to change MySQL’s innodb_log_file_size parameter (see How to calculate a good InnoDB log file size), you… and watch the error log output carefully. You should see InnoDB print messages saying that the log files don’t exist… means that InnoDB hasn’t started, and MySQL is trying to access a table with the InnoDB storage engine, which is failing, of course…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… cases Innodb will typically print something like this: InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 7. InnoDB: You…_get_page(index)) InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…that caused downtime for our customers: Failed or full LVM snapshots. LVM backup strategies can fail to delete snapshots after finishing, …other problems. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention that crosses…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… assert due to a failed malloc() in ut_malloc_low() in ut/ut0mem.c inside InnoDB source code. InnoDB wraps the majority of… successfully. What was failing is the allocation of 3.37GB after that. What in the world could InnoDB need that was 3… another chunk that is in proportion to the setting of innodb_buffer_pool_size for the blocks array. The exact proportions…
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
… you start MySQL and Innodb storage engine fails to initialize (ie you resized log file but forgot to delete old ones) MySQL Server simply… accessible not catching such errors. If MySQL is started with Innodb tables disabled accesses to Innodb tables will simply result in errors. The… it beating up people is performing Innodb conversion…. By default MySQL substitutes storage engines so if Innodb is disabled MyISAM is used, so…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
… to HardCore MySQL business – foreign Keys. MySQL supported Foreign Keys for Innodb for many years, yet rudimentary support initially added in MySQL 3.23… get it right even though Innodb is able to drop indexes without rebuilding table since MySQL 5.1 (Innodb Plugin) dropping foreign keys… add or update a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving towards the parallelized purge: in MySQL 5… innodb_flush_log_at_trx_commit=2 innodb_doublewrite=1 innodb_flush_method=O_DIRECT innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb…. Huh? The dedicated purge threads in 5.6.2 completely fail to stop the history list growth, but at least the…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the …innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…
