…to be very careful such as using sync-binlog innodb_flush_logs_at_trx_commit=1 and only using Innodb tables to…recover master you need to recover slaves to matching snapshot – either it has to be same state (which is hard to manage) or you need to… out so they can answer how they would handle at least…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… A disk failed, and RAID array does not recover You run into a InnoDB corruption bug that propagates via replication (not common… to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped. We are researching into how we…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb…to IO alignment yourself. In this case offset is correct, but file system is unaware how to align files properly. 4. Partition table…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…to use a non-conctextual primary key (NCPK – an auto_increment column) in nearly (emphasize nearly) every InnoDB table…how to create indexes. Foreign key references may add processing time to…
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
…-does-innodb-update-table-statistics-and-when-it-can-bite/ There are some variables to tune how that statistics are calculated but we need to… on InnoDB the rollback process could take even more time to finish than the original query. On the other hand, if the table… can’t be recovered. This particular example is not only a problem of ANALYZE. Other commands like FLUSH TABLES, ALTER, RENAME, OPTIMIZE…
Post: Upcoming webinar on Data Recovery for MySQL
April 6, 2011 By 5 Comments
… dropped table or from Hardware or Software failure. In this Webinar we will give you a walk through guide on how to restore your data after physical or logical failure, using practical examples to demonstrate how to tackle this challenging problem… state of tables * Retrieving data * Restoring from recovered data During this Webinar the Percona-InnoDB-Recovery-Tool will be used on Linux. To register…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…but also if you ever need to do roll forward recovery while recovering from backup. There are …to add more tables to be replicated to the slaves. Another issue is of course creating and altering tables. If you have Innodb tables… P.S It is in my todo to see how well MySQL 5.1 row based replication …
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
…as MySQL isn’t restarted it is possible to recover database fast. Let me illustrate how. Let’s simulate the accident. For …all InnoDB tables are reachable: mysql> select count(*) from sbtest; +———-+ | count(*) | +———-+ | 1000000 | +———-+ 1 row in set (0.19 sec) Conclusions Add to …
Post: Innodb Double Write
August 4, 2006 By 24 Comments
… interesting techniques Innodb uses is technique called “doublewrite” It means Innodb will write data twice when it performs table space writes – writes to log… it is inconsistent in the tablespace it is recovered from double write buffer. How much does double write buffer affect MySQL Performance…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… innodb data from the backup where Innodb fails to recover should be passed to your support provider for investigation. It might be related to Innodb itself or how… which are not handled if you have DDL however FLUSH TABLES WITH READ LOCK should prevent these.
