… followings. xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files… order_line.exp in directory /data/vadim/mysql/export/tpcc. ibd is regular InnoDB ® file, and exp is file with special export…
Post: MySQL 5.5.4 in tpcc-like workload
April 21, 2010 By 25 Comments
…:554-tpcc:start I took MySQL-5.5.4 with InnoDB-1.1, tpcc-mysql benchmark with 200W ( about 18GB worth of data), InnoDB… with innodb_io_capacity=500 and 2000 for MySQL 5.5.4. http://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start#io_capacity_for_bp_24gb_mysql_554 So when data fits into memory ( buffer_pool=24Gb), it seems innodb…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
… run tpcc-mysql benchmark with 500W using Percona Server 5.5.8. Here is relevant part of config what I used innodb…=4G innodb_adaptive_checkpoint=keep_average innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages = 0 innodb_write… with default innodb-log-block-size ( 512 bytes), and another with –innodb-log-block-size=4096. Full benchmark command is tpcc_start localhost…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… that just changing cfq to noop solved their InnoDB IO problems. I ran tpcc scripts against XtraDB on our Dell PowerEdge R900… innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=128M innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_write_io_threads=4 innodb_read_io_threads=4 innodb_io_capacity=800 innodb_adaptive…
Post: READ-COMMITED vs REPETABLE-READ in tpcc-like load
February 11, 2010 By 6 Comments
… poping up again and again. Recently it was discussed in InnoDB : Any real performance improvement when using READ COMMITED isolation level… for InnoDB . Serge in his post explains why READ COMMITED is better for TPCC load, so why don’t we take tpcc-mysql….1), and everything was run under XtraDB-9 ( based on InnoDB-plugin 1.0.6) So there are results: For 1000w…
Post: Clustrix benchmarks under tpcc-mysql workload
October 26, 2011 By 9 Comments
… on performance characteristics of Clustrix under tpcc-mysql workload. I tested tpcc 5000W (~500GB of data in InnoDB) on Clustrix systems with 3… node. Clustrix is able to handle such complex workload as tpcc, and automatically distributes load between nodes despite multi-statements transactions…
Post: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
… that PBXT team managed it. For initial runs I took tpcc 100 warehouses ( about 10GB of data) which fully fits into… on Wiki: http://www.percona.com/docs/wiki/benchmark:pbxt:tpcc:start there are graphs for 1 user: and 16 users… periodical drops which are very similar to periodical drops in InnoDB without adaptive checkpointing, and I guess it is also related…
Post: FlashCache: tpcc workload
May 25, 2010 By 18 Comments
… placed on Intel SSD card. This time I am using tpcc-like workload with 1000 Warehouses ( that gives 100GB of data… benchmark Wiki http://www.percona.com/docs/wiki/benchmark:flashcache:tpcc:start. Short version of results are on graph: In summary… O_DIRECT with proper blocksize), and you only rely on InnoDB in this case, and it takes about 30min+ to fill…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… used different values for innodb_buffer_pool_size, like 13GB, 52GB, and 144GB, for testing the tpcc-mysql database with size 100G… by the LRU list, then innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size do not matter… 5.1/InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
…-in InnoDB, InnoDB-plugin 1.0.6, and XtraDB 1.0.6-9 ( InnoDB with Percona patches). As benchmark engine I used tpcc-mysql… for InnoDB-plugin. Here we observe innodb_adaptive_flushing in action (which is ON by default), and I think innodb_adaptive_flushing in InnoDB… 88% worse than all files on FusionIO) To summarize MySQL InnoDB/InnoDB-plugin/XtraDB is not fully able to utilize throughput of…
