…. Test environment These tests were done on a relatively fast machine with a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1.6TB) and 128GB memory. For the hot test, the data fits in the…) run. I did some investigation during the testing and found that InnoDB does more IO than MyISAM when the database is cold…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…, change configuration and restart it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells… server has GTID_MODE OFF, Error_code: 1593 These simple tests answer the first two questions: replication works only if all… not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table has been created…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… this post. Similarly, reloading the data will be a very IO intense operation (redo logs, binlogs, etc) as well further polluting… disclosure, here are the versions I was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…’t like DRBD with virtual machines. First is the disk IO performance hit that comes with DRBD. When you run a… start to degrade. If you’re just setting up a test environment to get familiar with the technology, certainly there’s…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… level was less than half of xfs for the tpcc test and that’s maybe just normal. We didn’t try… run a server with hundreds of snapshots. With LVM, your IO performance drops to 33% after the first snapshot so keeping…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… in my previous benchmark run. A small handful of additional tests were also performed using the Cisco UCS C250. The operating… take a look at the data. With the sysbench fileIO test in asynchronous mode, read performance is an extremely steady 3202MiB… 205,000 read IOPS. When we switch over to synchronous IO, we find that the card is quite capable of matching…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… look at some numbers. vCache vs. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under… experiments. First, the baseline configuration plus: innodb_read_io_threads = 16 innodb_write_io_threads = 16 We call this configuration B. The… benchmarks were conducted with the following: sysbench –num-threads=32 –test=tests/db/oltp.lua –oltp_tables_count=32 \ –oltp-table-size…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… in Percona Server showed fairly close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of… 1M rows each (about 2.1GB) for his tests, while in our original tests we used a much larger one, 16 tables… innodb_file_per_table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… handle such OLTP workloads in the CPU and IO-bound cases. For this test we used a PowerEdge R720 box with a…=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max…=100000001 -c config/MyConfig.properties -l command line to run test for 10x dataset: ./bin/linkbench -D requesters=64 -D dbid…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload (which is TokuDB’s…-tk/sysbench/insert-roll-2, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root…_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio…
