… performance improvement when using READ COMMITED isolation level ? and in Repeatable read versus read committed for InnoDB . Serge in his post explains why READ COMMITED is better for… in READ-COMMITED then in REPEATABLE-READ. So both modes looks even for me, though some facts to consider: READ-COMMITED is used rare than REPEATABLE-READ (default…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…as deadlock detection, select for update handling and phantom reads in the repeatable read isolation level. Solid has OPTMISTIC (default) and PESSIMISTIC concurrency… However behavior is different from Innodb which will do READ-COMMITED for locking reads (SELECT FOR UPDATE/LOCK IN SHARE MODE) as only…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
… completed in 12 seconds for 1000 rows in a batch vs 40 seconds for single row statements. So with single statement…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…= ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log…was way bigger than 16G, I’ve repeated the random read (and write) benchmark with 8 threads and… the difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an important…
