…:16 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB…:16 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait… InnoDB: The…
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 15, 2012 By 11 Comments
Thanks for this new version. The IP addresses list feature is a very good … if a feature that will permit to skip some bases (innodb or myisam) in the cluster will be announced soon ? Because…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… the same way this blog post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… three digit number of servers, and in which we clone new slaves from existing slaves using mylvmbackup or a method that… up the new mysqld, which finds a crashed innodb, recovers this, and then it is being configured to become a new slave to the same master as the donor machine. Every once in a while the recovery of the innodb in…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most cases it… table once it is dropped, transaction also will see the new table which was created after transaction was started, including table…` char(255) NOT NULL, `i` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… and that is Nested Loop Join. MariaDB has introduced a new join algorithm Hash Join. This join algorithm only works with… 2.2G Innodb_data_reads 329115 355323 143808 335526 16164 15506 Innodb_pages_read 329115 355323 143808 358308 144798 144881 Innodb_rows_read… two other most important numbers are values for Innodb_buffer_pool_reads and Innodb_data_read. We can see that with appropriately…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New HA solution. Percona XtraDB Cluster provides: Synchronous replication. Transaction either….1-beta2 State of the art: Galera – synchronous replication for InnoDB Happy clustering! mbgc=’f5f5f5′;ww=’320′;mbc=’cecece’;bbc=’3F79D5…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… beta (1.9.2), only the version number has changed. New since 1.6: Percona XtraBackup can now save Galera replication… Percona XtraBackup against debug versions of InnoDB. This is only for very advanced users. The new features in Percona XtraBackup will be…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… its features might be helpful to you. So what’s new and great in MariaDB as compared to MySQL? A lot…, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might be…-out, as a sane user expects them to do. The new MariaDB release is a great development for MySQL users. Users…
Comment: InnoDB's gap locks
April 13, 2012 By 15 Comments
… to try to explain the following phrase with an example: “InnoDB provides REPEATABLE READ for read-only SELECT, but it behaves… NULL, `c` char(20) DEFAULT NULL, KEY `i` (`i`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 mysql> select * from t; +——+——–+ | i | c | +——+——–+ | 1…) but you can modify it (READ COMMITED). I open a new transaction again on the session 2 without closing the first…
