…Innodb bug (1%) Innodb recovery should be automatic and bring your database to consistent state. Depending on innodb_flush_lot_at_trx_commit setting you may…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…databases you’re likely to be shocked by MyISAM behavior (and default MySQL behavior due to this) – it will be corrupted…be locked while repair is going. If this is frequently used table you may have all your…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… or disk failure. Though it also can be things like Innodb corruption or soft crash which you can’t…the large portion of data trashed you may need to recover full database on all slaves which is best… stress on your network and backup storage and take a lot of time. It also may be extremely difficult …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…your database spanning across multiple volumes you will be in trouble as you will not get consistent snapshot across all the database. Some systems may be…Innodb if it is closer to you. In other cases snapshot may be …ensure your backup is consistent. Backing up database which was already corrupted is…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
…your database if power goes down during learning process. It may be fine for your data if not you may be able to get less penalty going from innodb…
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…database: Great to know it will be changed. I would emphasize it in current Limits section though. Isolation Modes: Innodb…may throw an error. Blob Handling: Just regarding your comment about blob materialization – Innodb…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… what is about MySQL/Innodb specifics ? First, in MySQL…is especially good if your IO needs are predictable…Firmware may have a glitch causing failure and data corruption …be significant concern to 1TB+ databases. My Take: I view SAN as solution for niche circumstances when it comes to MySQL. It may be…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… variables which may be adjusted to change behavior or for … example if you only have Innodb tables in your system does it mean …”mysql” database. Plus HEAP/MEMORY tables are used for temporary tables which may … Good for performance but tables will be badly corrupted on crash. delayed_insert_limit,…
Post: Monty unviels Maria and starts Blogging
January 29, 2008 By 4 Comments
…MVCC and row level locks functionally close to Innodb or Falcon. Though many internal architecture decisions …may be not in line with serious traditional DBMS thinking when data in theory never is corrupted and database …download maria and give it a try on your workload. It is also worth to note …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…be removed or overwritten A table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your… may take less time that trying to load a logical backup. Restoring your data…loop through each DB write out ALTER DATABASE DEFAULT CHARACTER SET
