… between the directory and file name components in a bitmap file name could stop the server starting if the innodb_data_home_dir… warning is now returned if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to….04. Bug fixed #1186690. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server stop…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… using InnoDB heap allocation. This may improve write performance for high levels of concurrency. Bug fixed #1185686. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server stop…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…table when appending exclusive key for cascading delete operation. Bug fixed #1089490 (Seppo Jaakola). …more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978…Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work …
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… to redirect to /dev/null, and only have a log file for debugging purposes. Streaming logs from stdin Percona Playback now…-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting the data on the standby server. You will need Percona Server in order to use innodb_fake_changes…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
… case when a customer deleted the InnoDB main table space – ibdata1 – and redo logs – ib_logfile*. MySQL keeps InnoDB files open all the time… modified pages are flushed it is safe now to copy InnoDB files back: root@localhost:/var/lib/mysql# cp /proc/14101/fd….19 sec) Conclusions Add to your monitoring system checks that InnoDB files ibdata and ib_logfile* do exist Do not restart MySQL…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON DELETE CASCADE Trying to add in child table, in index `par… helper threads, on Windows it however can be adjusted by innodb_file_io_threads variable. For each helper thread you can see… inside InnoDB Main thread process no. 10099, id 88021936, state: waiting for server activity Number of rows inserted 143, updated 3000041, deleted…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… the table after the backup has been taken. The variable innodb_file_per_table must be enabled. Then, our first step is…-10 | | 10008 | 52668 | 2000-03-10 | 2000-07-31 | +——–+——–+————+————+ mysql> DELETE FROM salaries WHERE emp_no=10008; The next step is… information from main tablespace which is not stored in .ibd file. innodb_import_table_from_xtrabackup=1 should be enabled for such…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…_id), -> FOREIGN KEY (parent_id) REFERENCES parent(id) -> ON DELETE CASCADE -> ) ENGINE=INNODB; — 0 Tickets Used Query OK, 0 rows affected (0… innodb_file_per_table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… Innodb tablespace got corrupted. In such 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… Running in innodb_force_recovery mode Innodb becomes read only for data operations and so you can’t insert or delete any data…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
… lost: MySQL had a dedicated partition on XFS file system Server was running innodb_file_per_table There was a production master and… written some junk data as that would have overwritten the deleted files. Now, here’s what I learned while working on this… file recovery tools for xfs – apparently they are all targeting specific file types and sure enough InnoDB is not one of the supported files…
