… transparent learn cycle NOTE: Virtual disks stays in Write Back mode, if enabled, during transparent learn cycle. When the TLC completes…
Comment: Looking for RAID Controller without Battery Learning problems ?
April 26, 2013 By 11 Comments
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are, by definition, read-only transactions, so the server deals… –oltp-distinct-ranges=0 –oltp-skip-trx=on –oltp-test-mode=nontrx –oltp-read-only=off –oltp-index-updates=0 –oltp… –oltp-distinct-ranges=0 –oltp-skip-trx=on –oltp-test-mode=nontrx –oltp-read-only=off –oltp-index-updates=1 –oltp…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… at the data. With the sysbench fileIO test in asynchronous mode, read performance is an extremely steady 3202MiB/sec with almost…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… list causes performance drop = MySQL 5.6.10 – in autocommit mode 5.6.10 has no problem with transaction list scanning…
Comment: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… option to sysbench). The 2nd one is the default sysbench mode, i.e. “BEGIN; SELECT …; COMMIT” which is expected to provide lower TPS values than the “QPS” mode. 2) There was no fix from Percona at the time…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… created by a non-locking SELECT statement in the autocommit mode. The relevant optimization in MySQL 5.6 boils down to… at the following benchmark: This is the so-called QPS-mode POINT_SELECT benchmark, i.e. all queries are single-statement….6 does not kick in. The default sysbench POINT_SELECT mode benchmark does PK lookup SELECT queries wrapped into regular (i…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 2, 2013 By 10 Comments
… my mind, the cache settings allow for two distinctly different modes of operation and use cases. ‘innodb_only’ appears to be… on the same box). ‘caching’ covers both (although favors traditional mode as it goes to the cache first). The default is…
Comment: Using Flexviews - part two, change data capture
March 22, 2013 By 26 Comments
process_rows() always check table_ordinal_is_unsigned, why continue check it in bulk insert mode?
Post: Testing the Virident FlashMAX II
March 21, 2013 By 1 Comment
… will cause it to be formatted in “maxcapacity” mode rather than “maxperformance” mode (maxperformance reserves some additional space internally to provide better write performance). In “maxcapacity” mode, the device tested provides approximately 2200GB of space. In “maxperformance…
Post: Virtualization and IO Modes = Extra Complexity
March 21, 2011 By 12 Comments
… –num-threads=1 –test=fileio –file-num=1 –file-test-mode=rndwr –file-total-size=1M –max-requests=10000000 –max-time…() at the end of test, Enabled. Using synchronous I/O mode Doing random write test Threads started! Time limit exceeded, exiting…() at the end of test, Enabled. Using synchronous I/O mode Doing random write test Threads started! Time limit exceeded, exiting…
