Has anyone tried changing the isolation level instead of using OUTFILEs. SET TRANSACTION ISOLATION LEVEL READ COMMITTED; INSERT INTO TemporaryTable SELECT … FROM HighlyContentiousTableInInnoDb; See my…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… that works for all situations. For example, mixtures of transactional and non-transactional tables are a nightmare. Here are a few ideas… it has a complete transaction‘s worth of events (not a single statement), and hand the whole transaction to the worker thread… common cases will require use of InnoDB with the proper transaction isolation level, at a minimum. This behavior is going to have to…
Comment: SELECT LOCK IN SHARE MODE and FOR UPDATE
January 30, 2010 By 51 Comments
… mind also that the transaction isolation level must be set to at least repeatable read to ensure serializability. Lower levels allow for more concurrency but then you will have to check whether your transactions keep the database in…
Comment: InnoDB's gap locks
April 6, 2012 By 15 Comments
… chosen transaction isolation level” is that transactions will be REPEATABLE READ until the first write (or SELECT FOR UPDATE) happens, at which point the transaction…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… state of Innodb scalability with multiple threads and multiple concurrent transactions ? HT: The scalability in my opinion is ‘mediocre’, and we… is already implemented in 5.1: if you set the transaction isolation level READ COMMITTED, then InnoDB normally does not lock the ‘gaps…. MySQL’s binlog and InnoDB’s log must have the transactions in the same order, for a recovery based on MySQL…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
April 14, 2011 By 22 Comments
…Sylvain261 I tested SET TRANSACTION ISOLATION LEVEL READ COMMITTED; SET binlog_format = MIXED; INSERT INTO ….SELECT …
Comment: Some little known facts about Innodb Insert Buffer
December 14, 2010 By 12 Comments
… the table. I tested with autocommit=1 and even when transaction_isolation_level=seriazable. It seems Innodb is not doing locking properly. If…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
September 8, 2010 By 22 Comments
… slave with the one in your master : using READ COMMITTED transaction isolation level is the way to go, it’s much simpler than…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
…Sylvain261 I tested SET TRANSACTION ISOLATION LEVEL READ COMMITTED; SET binlog_format = MIXED; INSERT INTO ….SELECT … FROM …. …
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… at basic transactional properties such as deadlock detection, select for update handling and phantom reads in the repeatable read isolation level. Solid has OPTMISTIC (default) and PESSIMISTIC concurrency control, so it was interesting to test both. We used default isolation mode…
