… 10% of progress in 2hours qualifies as that). It is especially nasty as it is quite hard to predict. Both customers had MySQL crash… fixing it not MySQL/Sun but there are MySQL bugs not fixed for years too). Look for workarounds or ways to fix things yourself. In particular case workaround was rather easy – reducing Innodb buffer pool size to 4GB instead…
Comment: 10+ Ways to Crash or Overload MySQL
November 19, 2007 By 20 Comments
…: “Really – there are many ways to crash or otherwise made unavailable server with any MySQL version if you have access to it with normal privileges”, shouldn’t the title be something like “10+ Ways to keep alive MySQL“? Not to…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…to succeed (unless something weird happens like the disk fails or the server crashes…way up to…to node1 and see what happened: node1 mysql> commit; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction node1 mysql…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… way Innodb processes page data. The next comes trial and error approach: mysql…OK, 10 rows affected (0.00 sec) Records: 20 Duplicates: 10 Warnings: 0 mysql> … 300; ERROR 2013 (HY000): Lost connection to MySQL server during query As you … finally touch the row which crashes MySQL. In this case we can …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…many pieces. In extreme cases I’ve seen over 10 pieces in average per row – this is when … does not happen for all applications and there are ways to fight it but still watch out. Lack of …buffer to disk, but it also comes at great danger if MySQL Server crashes or power goes down. In case crash …
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… 1GB per 10 minutes of recovery time – instead you would need to apply load which is typical for your application, crash MySQL in the middle and watch it to recover. Doing this… the same transaction and crash in the middle recovery can take quite a long time. The only way you can reduce “undo…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…crash…MySQL first, then unmount the logical volume holding the MySQL data. This way you don’t have to deactivate/activate the original logical volume to…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…InnoDB table was corrupt and mysql shuts down Your server or RAID controller crashes and all data …we use these components to give our customers reliable backups? Think about the 10 example outages listed above… ways that could improve this in the future. Other details on Percona Remote DBA for MySQL …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…- you do not get to deal with recovering tables on the crash or partially executed statements… MyISAM but will start taking way too much time to do restore for Innodb. … not so common paths in the MySQL server – in particular Optimizer may have … it can be as much as 10-50 times for Innodb tables in …
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
…to get performance. The simplest way is to use libeatmydata. This is a small shared library designed to…to disk. This is perfect for running a test suite for a database server as if your machine crashes…to run (even with –big-test option to mysql…
