… ago I was looking for a way to improve update performance for the application and I was replacing single value UPDATE… in the batch performance improved, especially for network tests, however going to batches of 100 and 1000 values performance started to degrade… 40 seconds for single row statements. So with single statement MyISAM was about 10% faster, which is quite expected but with…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
… read to be Innodb – even if writes are done in MyISAM table. So why was this done, being pretty bad for MySQL Performance…. So even if you’re operation in REPEATABLE-READ mode, this operation will be performed in READ-COMMITTED mode, potentially giving different result compared…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… to allow you to perform consistent read even if rows are locked or even modified unless you require locking read, in which case… | MyISAM | +—-+——–+ 3 rows in set (0.00 sec) So there are no phantom rows which is what we would expect from repeatable-read… | Solid | | 3 | MyISAM | +—-+——–+ 3 rows in set (0.00 sec) Test 3: Phantom rows (no phantom rows in repeatable-reads): Session1: mysql> begin…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…log-based architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to …using InnoDB in REPEATABLE READ mode, then there is essentially no difference in the isolation paradigm between the two engines. REPEATABLE READ is …
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 3 Comments
… improving performance dramatically. Actually packed indexes not a bit longer rows is frequent reason of MyISAM performing… looking at the key value and repeating it then repeating it for left or right half…. range/index scan will be fast (read_next) as MyISAM will remember previous position and will…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…ext2 filesystem and SysBench tool. Using 16K read sizes (matches Innodb page size) I …to repeat and test – just run Innodb from the RAM drive 
Next I tested MyISAM …MyISAM with myisam_use_mmap option which did not seems to give any significant performance benefit, may be even reducing performance…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…Innodb data dictionary the operation is slower than MyISAM tables. Though the difference can be related to… So innodb_open_files does not affect performance a lot on reads – what is about writes ? I tried…crash happen (how many unflushed changes we had) Repeating test with innodb_open_files=16384 I …
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… tend to access same data read from database multiple times. …for MySQL Performance tuning ? Not surpising associative array cache performs the best,…: If you would like to repeat my benchmark or experiment …255) default NULL, PRIMARY KEY (`k`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `test`…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_…size=64M transaction_isolation=REPEATABLE-READ local-infile=1 At first I tried sysbench oltp read-only with 10mil… it as next step, read detailed investigation what is the reason of performance drop in next post…
Post: More on table_cache
November 26, 2009 By 7 Comments
… how large table_cache actually can decrease performance. The “miss” path is getting more expensive …read all of them at once to make sure all table cache entries are populated. When I tried repeatedly reading… best case scenario for opening tables as MyISAM table headers which are being modified were…
