… will use two different schemas. The first schema is from sysbench, and the table looks like: CREATE TABLE sbtest$I ( id… this benchmark, the sysbench code is on Launchpad lp:~vadim-tk/sysbench/insert-roll-2, command line to run: sysbench –test=insert_roll…_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…conducted with the following: sysbench –num-threads=32 …innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
…=0 skip-name-resolve table_cache=2048 sysbench parameters /data/vadim/benchwork/benchmarks/sysbench/bin/sysbench –num-threads 1 –max-requests 0 –max…-user user –mysql-password –mysql-db sbtest –mysql-table-engine innodb –myisam-max-rows 1000000 run
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
… blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB‘s scalability as… on how it is used. In brief, the benchmarks are sysbench‘s read-only and read-write tests, and the server… were re-run with the same core counts and with sysbench on another machine, instead of taking 12 cores away from…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file_path=ibdata1:10M:autoextend innodb…_isolation=REPEATABLE-READ local-infile=1 At first I tried sysbench oltp read-only with 10mil rows (the datasize is about… removed for additional checking) In the next run I tested sysbench oltp read-write load, and the results are: Here starting…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
….com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The difference is I used new sysbench with Lua scripting language… script for sysbench http://www.mysqlperformanceblog.com/files/benchpbxt/phptest.lua The mysql.start script with startup parameters for InnoDB and PBXT… for MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…during “prepare” phase of sysbench. I found out that sysbench would not honor –file…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb… myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…* from test2; +—-+———–+ | id | names | +—-+———–+ | 1 | Mysql | | 2 | Solid | | 3 | MyISAM | +—-+———–+ Session1: mysql> begin; Query OK, 0 rows affected (…use SolidDB instead of Innodb complicated. P.S. After previous experiments I tried SolidDB under sysbench and got next (…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… CentOS5 was tested using ext2 filesystem and SysBench tool. Using 16K read sizes (matches Innodb page size) I could get 1.2GB… and sending it back to the client. I tested MyISAM with myisam_use_mmap option which did not seems to give any… from MyISAM (double of Innodb already) which scaled to 70.000 queries/sec peaking out at 16 threads. However even with MyISAM we…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
April 8, 2007 By 117 Comments
[...] This time I tested only READ queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The difference is I used new sysbench with Lua scripting language, so all queries were scripted [...]
