…=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… let’s look at some numbers. vCache vs. vCache – MySQL parameter testing The first test was designed …mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… Percona Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested… datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_file…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… a results comparison on a single-node (on the left) vs. two-node (on the right) configuration. No surprises here, the…=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=9 –oltp…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… code for this benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘automatic_serialization’ => true ); $…73 ms/op) InnoDB fetch operation was 20% higher (~.06 ms/op) MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool (thus leading to a…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 3, 2013 By 10 Comments
… simplistic Memcache vs. Memcache observations: http://blog.ulf-wendel.de/2013/toying-with-peclmysqlnd_memcache-and-mysql-5-6-memcache-innodb/ HandlerSocket vs Memcache…. HS does not compile with MySQL 5.6 (yet). If you compare HS @ 5.5 with InnoDB Memcache @ 5.6 you should… features… see also http://de.slideshare.net/nixnutz/nosql-in-mysql Independent YCSB results would be interesting but require significant time…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… any information how memcached cache time expiry being apply into MySQL 5.6 memcached. e.g. if i want to store…. Can this apply to the MySQL innodb memcache? i.e. will the cache being delete off innodb table after 12hours or they remain… a comparison between performance of 5.6 memcached innodb write/read vs 5.6 innodb write/read with no memcached layer? Currently I…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… contains 8 indexes inside InnoDB, which is different from the number of indexes 7 defined in the MySQL This customer was running… the INFORMATION_SCHEMA.INNODB_SYS_INDEXES table, which exists in Percona Server 5.1, but doesn’t appear in MySQL until 5… Percona Server or MysqL 5.6. Another person (I’m looking at you, Baron) was adverse to trusting INNODB_SYS_INDEXES from…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far most of the benchmarks posted about MySQL 5…3776369 | | INNODB_BUFFER_POOL_READS | 191571 | | INNODB_DATA_PENDING_READS | 0 | | INNODB_DATA_READ | 3140882432 | | INNODB_DATA_READS | 191581 | | INNODB_PAGES_READ | 191570 | | INNODB_…
