… MySQL has a table crash? It seems silly that the application would have to build in handlers for every query to detect whether some table has crashed… support for this right in MySQL. We turned on error logging and can get _some_ of the crashed tables to show up in…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… Software Repositories). Based on MySQL 5.1.66, including …privileges to modify a table (any non-temporary table) can inject … #917942 (Mark Callaghan, Laurynas Biveinis). Crash-resistant replication would break with… AUTO_INCREMENT columns where correctly detected, mysqldump prevented all such keys…
Post: Announcing Percona Server 5.5.24-26.0
June 1, 2012 By 9 Comments
… could crash with glibc detected memory corruption. This bug was introduced in MySQL 5.5.18 and Percona Server inherited it from MySQL. Bug… fixed #712055 (George Ormond Lorch III). A crash could leave behind an InnoDB temporary table with temporary indexes resulting in an unbootable…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…disk fails or the server crashes) because it acquired all the…running transactions. How would deadlock detection work? On a single node,…) node2 mysql> show create table autoinc\G *************************** 1. row *************************** Table: autoinc Create Table: CREATE TABLE `autoinc` ( `i…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…as fast as putting data back and standard MySQL crash recovery, and it can be reduced even further…of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES …is: snapshot: Required device-mapper target(s) not detected in your kernel – This means snapshot module …
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…in MySQL …Non-Recursive Deadlock Detection – Faster Locking …- Global Transaction Identifiers – Crash Safe Slave …Tables – - INNODB_METRICS – - Meta Data Information Tables – - Buffer Pool Information Tables – Improved PERFORMANCE_SCHEMA – - Reduced Overhead – - Simplified Configuration – - Table…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
…files and non-InnoDB tables. By doing a two-phase pass over the MySQL datadir with rsync (…. Bug Fixed: #737569 (Valentine Gostev) xtrabackup would crash if the –parallel option was specified with … the –safe-slave-backup option, innobackupex always correctly detected whether or not the host was a …
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 3 Comments
… available here and from the Percona Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it… would crash on a DDL statement if an XtraDB internal SYS_STATS table was corrupted or overwritten. This is now fixed by detecting the corruption and creating a new SYS_STATS table. Bug…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…updated or deleted because the MVCC system can detect that a row has been changed (and is…are things like backup, concurrency, ACID compliance and crash recovery. As a storage engine developer, what …locks when calling back into MySQL to do things like open a table, create a session structure (THD)…
Comment: MySQL Limitations Part 1: Single-Threaded Replication
October 29, 2010 By 16 Comments
…MASTER POS=XXXXX if table.n modified write to table n % max_slave_threads if table x engine …mysql master 2) read and classify binlog 3) execute in one or n connections statements on slave 4) if slave crashed/disconnected there is no way to detect slave exec position, but …
