… to test it under MySQL workload, but before getting to that, let me review the same workload on Fusion-io ioDrive PCIe… 107053 Following the format of previous benchmarks, first is random write async 16KB case. We can see some wave-like pattern…-500 MiB/sec. This is not usual for read-only workload to have such variety in throughput. It gets even more…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… query cache to avoid contention caused by query cache on write heavy workload. OK, so that was all about the configuration of… simultaneously to simulate 5 concurrent connections writing to the table, with each instance of iiBench writing 200 million single row inserts, for… choice. But for those applications that are write mostly or that rely a lot on write performance, reducing the no. of secondary…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… let me jump directly to results. First case is random write asynchronous 8 threads IO, the test is done just after… is 0.69ms. Now let me get back to random write case. I will try synchronous IO varying amount of threads… MySQL performance, and I am going to run some MySQL workloads on these cards to understand it better. If you are…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… I would not use more than 4 parallel processes heavily writing to database. Introduce Throttling Sometimes even single process overloads system…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…” with O_DIRECT case (sysbench fileio 16 KiB blocksize random write workload): ext4 1 thread: 87 MiB/sec ext4 4 threads: 74…, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems it is not…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage for me), and… are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and second, async mode… G6, filesystem: ext4, mounted with nobarrier. The results for random write case (8 async IO threads): It seems that InnoDB is…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… order to complete locking tables. This means if you have workload which includes some very long SELECT queries you can be… is no MYISAM like table lock priority problem with pending WRITE query blocks any READ queries to execute on the table… from the slave with –safe-slave-backup option, as preventing writes to the slave can be done by simply pausing replication.
Comment: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 26, 2012 By 10 Comments
Vadim, So Samsung 830 can handle 300MB+/sec writes and Stec Mach16 can handle 150MB/sec though Samsung has … what if you load Samsung lower than its full capacity, writing 150MB/sec as STEC can do or might be 200MB… avoid stalls while providing better performance than STEC ? For many workloads in reality you more care about what load system can…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage for me), and… are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and second, async mode… G6, filesystem: ext4, mounted with nobarrier. The results for random write case (8 async IO threads): In general it shows stable…
Comment: Testing STEC SSD MACH16 200GB SLC
April 26, 2012 By 7 Comments
… I would prefer MLC SATA for light workloads or PCI-Express drives for more write intensive load. By the way, Percona benchmarks…
