InnoDB, InnoDB-plugin, XtraDB on FusionIO

Final results (in TPM (transactions per minute), more is better)

• InnoDB plugin

-----io---- -system-- ----cpu----
   bi    bo   in   cs us sy id wa
 41051 98658 20385 140559 29  7 59  5
 43436 94316 21059 144872 31  7 57  5
 44303 82839 20804 149260 32  8 56  4
 43809 74366 21100 153793 34  8 54  4
 42103 69904 20078 151526 33  7 56  4
 40456 73857 20211 149467 32  7 56  4
 31659 122687 19476 125210 25  7 63  5
 31561 128700 19843 126811 26  7 62  5
 33729 120105 20025 132657 27  7 61  5
 36968 108753 20258 137592 28  7 60  5
 42471 98117 21000 143176 30  8 58  5
 43402 91892 20713 144396 30  7 57  5
 43594 81678 20481 148040 31  8 57  4
 41909 75269 20720 151355 33  8 55  4
 41940 71781 20245 150236 32  7 56  4
 39722 81094 20407 147106 32  7 57  4
 32824 120670 19712 127585 26  7 62  5
 32272 125461 19691 127268 25  7 63  5
 33234 118413 20105 133211 27  7 61  5
 37655 108487 20474 138681 28  7 60  5
 42143 97349 20671 141855 29  7 59  5

• XtraDB

-----io---- -system-- ----cpu----
   bi    bo   in   cs us sy id wa
 51114 134421 22905 205649 36 10 46  7
 51840 132237 23220 208544 37 10 45  8
 48186 128259 21810 195291 34  9 49  7
 50794 135846 23231 206181 36 10 46  8
 49754 139645 22754 202038 35 10 46  8
 51049 137849 23249 206211 36 10 46  8
 47769 138426 21983 193784 33 10 50  7
 50636 133560 22939 202904 35 10 47  8
 51656 135821 23074 209350 37 10 45  8
 51455 139247 23261 209126 37 10 45  8
 51249 140375 23128 207924 37 10 45  8
 50339 136161 22934 202535 35 10 48  8
 47266 138229 21709 191515 33  9 51  7
 50230 131910 22636 201585 35 10 47  8
 50545 133838 22570 202507 35 10 47  8
 51960 137144 23163 209788 37 10 45  8
 49953 138788 22550 200754 35 10 47  8
 51329 136162 23171 207429 37 10 45  8
 51432 134808 23159 205963 36 10 45  8
 48702 136023 22122 194867 33 10 50  8
 50506 133136 22682 203886 36 10 46  8

• InnoDB logs on FusionIO (Final result: 23038.283 NOTPM)
• Data files on RAID10 (for reference) (Final result: 2873.783 NOTPM)

• InnoDB

innodb_buffer_pool_size=26G
innodb_data_file_path=ibdata1:10M:autoextend
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=8M
innodb_log_files_in_group=3
innodb_log_file_size=512M
innodb_thread_concurrency=0
innodb_flush_method             = O_DIRECT

max_connections=3000
query_cache_size=0
skip-name-resolve
skip-grant-table

table_cache=10000

• InnoDB-plugin / XtraDB

ignore-builtin-innodb
plugin-load=innodb=ha_innodb_plugin.so


innodb_buffer_pool_size=26G
innodb_data_file_path=ibdata1:10M:autoextend
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=8M
innodb_log_files_in_group=3
innodb_log_file_size=512M
innodb_thread_concurrency=0
innodb_flush_method             = O_DIRECT

innodb_write_io_threads=8
innodb_read_io_threads=8
innodb_io_capacity=10000

TPCC-like workload, 1000 Warehouses (~90GB of data)

• 16 working threads, 1000 warehouses

tpcc_start localhost tpcc root ”” 1000 16 100 3600

Dell R900