… card. So I decided to run the same series of tests I did for other Flash devices. This is ioDrive2 Duo…), which can be connected together via software RAID. So I tested in two modes: single drive, and software RAID-0 over… version: 3.1.1. Now to the results. For this test I also use Cisco UCS C250 server, and on the…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
Following my series of posts on testing different SSD, in my last post I mentioned that SATA … getting closer to PCIe cards. It really makes sense to test it under MySQL workload, but before getting to that, let…
Post: Testing Virident FlashMAX 1400
May 4, 2012 By 3 Comments
… are getting close. Response time: In the conclusion, from all tested cards, Virident FlashMAX shows the most stable results and the…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
…. First case is random write asynchronous 8 threads IO, the test is done just after a secure erase operation on the…
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
… in set (0.00 sec) root@localhost:test 14:51:40> Transaction2: root@localhost:test 14:35:50>start transaction; Query OK… (HY000): Lock wait timeout exceeded; try restarting transaction root@localhost:test 14:38:03>insert into t values(23); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction root@localhost:test 14:44:37>insert into t values(31); ERROR 1205…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…Andy, I am not testing IO performance and instead trying to optimize writes, also the … loose 1 second worth of data, hence I did not test with innodb_flush_log_at_trx_commit=1. I would…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB options innodb…, for a total of 1 billion rows. I ran the test both with the table purchases_noindex which has no secondary…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
…, it will do so. In the function is_slave() the test for an output to a tmpfile, not for the content… say that this server is a slave, but later the test of “Slave_SQL_Running: Yes” fails, because the server is…
Comment: Choosing proper innodb_log_file_size
May 15, 2012 By 12 Comments
… user’s apps. IMO, you have to test it out on a copy / testing DB in peak time and off-peak hours…
Comment: New distribution of random generator for sysbench - Zipf
May 10, 2012 By 3 Comments
… to be able to handle broken connections gracefully and reconnect. Testing Percona XtraDB Cluster with HAProxy is a pain now as test is aborted once one of the nodes goes down. I’…
