… Percona Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested… MISLEADING. So we see that InnoDB performance steadily declines from 24000 tps to 18000 tps, but InnoDB can’t make 5h run. After… to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema….sock –oltp-point-selects=1 –oltp-simple-ranges=0 –oltp-sum-ranges=0 –oltp-order-ranges=0 –oltp-distinct-ranges=0 –oltp-skip-trx=on –oltp-test…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…two in the same way. The following graph shows sysbench OLTP performance for FlashCache vs. vCache with a 10% dirty threshold versus… #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… has announced the Linkbench benchmark that models the social graph OLTP workload. Sources, along with a very nice description of how… MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance… query_cache_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… –test=oltp –db-driver=mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table… –test=oltp –db-driver=mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_big –oltp-table… takes about 180 seconds. Yes you get it right. Performance of sysbench OLTP on small table drops more than 150 times when…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… a significant amount of time. Setting innodb_concurrency_tickets too high can have startlingly negative performance implications. On the other hand, if… much of a difference here: Details: sysbench –test=oltp –oltp-table-size=80000000 –oltp-read-only=off –init-rng=on –num-threads=16…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…. To get some initial impression about performance I decided to run some sysbench … –test=tests/db/oltp.lua –oltp-tables-count=16 –oltp-table-size=5000000 –oltp-read-only=on –rand…have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression …
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
… going to check impact of several memory allocators on the performance/scalability of MySQL server in the read-only workloads. For… each) ~50G data / CPU bound case innodb_buffer_pool_size=52G For every malloc allocator perform the following steps: start Percona server…) from sbtest$i FORCE KEY (PRIMARY)’ and then OLTP_RO for 600sec run OLTP_RO/POINT_SELECT test cases, duration 300 sec…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see SSD…-disk threshold, as famously happens in B-Tree inserts (see InnoDB vs TokuDB for example). This doesn’t mean that we… will see how the Amazon RDS instance performed at various thread counts on the OLTP benchmark. Update Vadim and Peter have rightly…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb… In the next run I tested sysbench oltp read-write load, and the results are:… detailed investigation what is the reason of performance drop in next post. And last one…
