I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program… the transaction is not interrupted until the transaction is finished/committed? A example of a program is worth a 1000 instructions…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… and final, and this is not a “maybe.” We have committed to running the conference in 2013 and it will definitely… Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and… also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… | +——+ transaction2> START TRANSACTION; transaction2> INSERT INTO t VALUES(26); transaction2> COMMIT; transaction1> select * from t where i > 20 FOR UPDATE; +——+ | i…/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level so it…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places…-based types, as well as microseconds in SHOW PROCESSLIST Group commit for the binary log makes the server much faster with… group commit fix, and MySQL 5.6 offers microsecond timestamp support, as well as a lot of optimizer improvements. Even the standard MySQL…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New HA solution. Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited…
Comment: InnoDB's gap locks
April 13, 2012 By 14 Comments
… sessions with REPEATABLE READ transaction isolation level. mysql> show create table t\G *************************** 1. row *************************** Table:…> update t set c=”baron” where i=3; session2> commit; session2> select * from t; +——+——-+ | i | c | +——+——-+ | 3 | baron | |…
Comment: InnoDB's gap locks
April 4, 2012 By 14 Comments
Statement 1: “it behaves as if you use READ COMMITTED for all write queries, in spite of your chosen transaction … ISOLATION to READ COMMITTED will help you to avoid all those extra locks” But if MySQL behaves as if READ COMMITTED is used… ISOLATION is set to READ COMMITTED or REPEATABLE READ, MySQL would still behave as if READ COMMITTED is used according to statement 1…
Comment: InnoDB's gap locks
April 4, 2012 By 14 Comments
Miguel, SO MySQL does indeed behave differently depending on whether ISOLATION is set to READ COMMITTED or REPEATABLE READ? I’m just… in the article: “it behaves as if you use READ COMMITTED for all write queries, in spite of your chosen transaction… which level you set ISOLATION to, MySQL is just going to behave as if READ COMMITTED is being used. Maybe you could…
Comment: How Does Semisynchronous MySQL Replication Work?
March 17, 2012 By 23 Comments
Official MySQL documentation says the following : “If semisynchronous replication is enabled on … slave, a thread that performs a transaction commit on the master blocks after the commit is done and waits until at least… a commit returns successfully, it is known that the data exists in at least two places” – (cf http://dev.mysql.com/doc…
