… Innodb tables – Innodb when Innodb does crash recovery it would print position in master log files up to which replication was done: InnoDB: In a MySQL… take LVM Snapshot (assuming you’re only using Innodb tables and not touching your MyISAM system tables) and use this position to…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_… tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed needs … of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM background there …
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
…innodb_force_recovery=4 was confirmed to be added in 5.0.33, meaning you could not really recover corrupted Innodb…things: Versions later than MySQL 5.0.33 …Innodb tables rarely become corrupt Indeed even if you leave out crashes in my experience Innodb tables become corrupted more seldom than MyISAM…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb … INFILE be optimized same way as for MyISAM tables by separate phase of building Indexes ?… things inside Innodb to unleash performance such as multiple purge threads or parallel log recovery features,…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…latency critical. Now what is about MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable …having only one IO at the time if Innodb or MyISAM tables are used. There is read-… last snapshot) you may be able to minimize recovery time significantly by switching to that backup – …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… application (storing billions of rows in tens of thousands tables) Innodb was better choice mainly because of thouse other behaviors … well… of items you need to keep into account while using MyISAM tables. Recovery. MySQL was running stable for us, giving us false sense… make sure you have decent myisam_sort_buffer_size and large myisam_max_sort_file_size otherwise recovery may be done by key…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server… point in time recovery. Store your binlogs offsite for disaster recovery scenarios. Run pt-… Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough …need events in binary log – even for backup recovery, for example dealing with temporary tables (unless … Innodb tables are created as BLACKHOLE. However you can’t do the same with MyISAM tables, because MyISAM…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…Innodb tables to be OK in most cases. There are still some edge cases such as modifying meta data stored in MyISAM…Innodb corruption or soft crash which you can’t recover promptly enough. In this case most typically you would plan recovery… of vendors offering solution for MySQL is R1Soft. Though I …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… for people to work as MySQL DBAs or be involved with MySQL Performance in some way …you’re using Innodb tables. Innodb tables are much more sensitive to buffer size compared to MyISAM. MyISAM may …increase recovery times so be careful. I normally use values 64M-512M depending on server size. innodb_…
