…–apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the …sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, …(thanks Bill Karwin!), the cumbersome part of this process is the DISCARD/IMPORT TABLESPACE step as …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… are no longer complete or useful for point-in-time recovery. Generally if you’re considering the binary log filtering approach… rules are processed. There are some informative flowcharts in addition to the textual explanation. Q: What is my recommendation for MySQL 5… mounted, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried, I got…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… the recovery process more straightforward. Now the scenario is worse because we don’t have a backup or the backup restore process doesn… in /root/recovery-tool/data. After the compile process we need to copy the salaries.ibd tablespace to the recovery-tool’s data… link: http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:generating_a_table_definition With the table definition on…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
… – and redo logs – ib_logfile*. MySQL keeps InnoDB files open all the time. The following recovery technique is based on this fact… 23:29 9 -> /var/lib/mysql/ib_logfile1 (deleted) where 14101 is the PID of mysqld process. However, we can’t copy… files ibdata and ib_logfile* do exist Do not restart MySQL until the further recovery strategy is clear
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… your tables are InnoDB the process is a little bit different story. With Oracle’s stock MySQL you cannot move your ibd… the second step the use of –export option runs a recovery process on the backup with innodb_fast_shutdown=0 and therefore… /var/lib/mysql/data/employees/ Import the new tablespace: mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries IMPORT TABLESPACE; mysql> set FOREIGN…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… still hoped new MySQL release will have this Innodb bug fixed) until today we got MySQL to crash during recovery process right after 17… data on per table basics. Also if MySQL crashes during recovery lower values of innodb_force_recovery normally would not work. Reading Documentation…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…a crash using mysql-bin 120619 13:21:19 [Note] Starting crash recovery… 120619 13:21:19 [Note] Crash recovery finished. 120619 …clustercheck user. mysql> grant process on *.* to ‘clustercheckuser’@'localhost’ identified by ‘clustercheckpassword!’; Query OK, 0 rows affected (0.00 sec) mysql> flush …
Post: New variable slave_max_allowed_packet for slave servers
July 24, 2012 By 2 Comments
…_allowed_packet. During the recovery process the slave_max_allowed_packet is not going to help us and our recovery process could fail. Conclusion…_allowed_packet. Training In September I’m going to deliver MySQL Training (Sep 3-6) in Madrid. This is the first… get more information. En Septiembre voy a impartir Formación de MySQL en Madrid (Sep 3-6). Está será la primera vez…
Post: What is the longest part of Innodb Recovery Process ?
December 20, 2007 By 1 Comment
In MySQL 4.1 and above the longest part of recovery after crash for Innodb tables could be UNDO stage – it … longest phase has to do with restarts more than crash recovery as it presents in normal restarts as well – “Opening Tables… as MyISAM so one could recompute them in background. Also MySQL should fix things so more than one table can be…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…forgot to remove (or still use for processing). Of course you will see these tables… (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) Threads 425080 (406936 + … is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate …
