… InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring…: ready for connections. Version: ’5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also, I don’t see how MySQL could be using any other conf file other than /etc…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) Threads 425080 (406936 + 18144) Dictionary memory… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… a bug in InnoDB. Can you file one at bugs.mysql.com with details from the mysqld error log? AFAIK, InnoDB… files and log files are on the same filesystem. But MySQL/InnoDB is not snapshot safe if DDL operations are in… between MySQL (frm files) and InnoDB is not atomic and some failures are not recoverable (which can cause problems for recovery after…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… as the donor machine. Every once in a while the recovery of the innodb in the target location fails, though, even…). We are using CentOS 5.x, LVM2, XFS and Oracle MySQL 5.5.x (x=16 on many boxes atm), but… have been experiencing this with many versions of MySQL. We are now using ‘service mysql stop’ instead of FLUSH TABLES WITH READ…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… # xtrabackup_55 –backup –innodb-file-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export –innodb-file-per-table –target-dir=/mnt/mysql/export ALTER TABLE data DISCARD TABLESPACE; # replace ibd with the… InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information.
Comment: Connecting orphaned .ibd files
April 6, 2012 By 12 Comments
… course. Try this way: ./ibdconnect -o /var/lib/mysql/ibdata1 -f “/var/lib/mysql/mydb/st_results#P#p_1.ibd” -d… file a bug here https://bugs.launchpad.net/percona-data-recovery-tool-for-innodb
Comment: Percona Server vs MySQL on Intel 320 SSD
March 21, 2012 By 21 Comments
Patrick, There are two factors: 1. Speed of recovery is much better in MySQL/Percona Server 5.5 2. Having on SSD makes it also much faster. So having big log files is practical under these conditions. It still may be long, but that that painful as in old InnoDB.
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
… least be able to recover the data with the Innodb recovery tool of Aleksandr Kuzminsky a colleague on the Percona European… all this in place, recovery the data was just another Bash script: #!/bin/bash CURRENT_ID=1 mysql -u root “create database… staging) contained an extra column. With a modified schema, the recovery completed. The customer was able to download the tables in…
Post: Upcoming webinar on Data Recovery for MySQL
April 6, 2011 By 5 Comments
…-50 minute long webinar on 26th of April on data recovery for MySQL. Almost every long serving DBA has been faced with… is free. What you can learn by attending: * Prepare for recovery (prerequisites) * Preparing your data * Identifying the structure and state of… * Restoring from recovered data During this Webinar the Percona-InnoDB-Recovery-Tool will be used on Linux. To register: https://percona…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… may know this, but there are precious few innodb crash recovery tests available. Some folks have noticed this and asked for… unfortunately, no tests have been created for the main MySQL branch. The MySQL at Facebook branch has a number of tests that… was having an effect on the test tables between crash/recovery/validate cycles. To examine this for yourself during a run…
