… for a customer benchmarking insert performance on Amazon EC2, and I have … Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5… insert rate of ~25k INSERTs Per Second, while with the table purchases_index, the avg. insert rate reduced to ~9k INSERTs Per Second…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…benchmark with 8 threads and total size of 256G. While the number of operations per second…inserts are done to random positions (not consecutive PK causing page splits) etc. Benchmark…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
…, either in operations per second or in throughput. If you require many operations per second, then it is …MySQL is probably closer to stock MySQL than it is to Percona Server. I haven’t run extensive benchmarks…, you can make certain workloads, such as insert-heavy, work better in the Amazon cloud …
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients…. Here is the chart of rows inserted per minute (click on the image for a… finer-grained samples, say, every 5 seconds instead of every minute, and some…we need a multi-threaded long-term insert benchmark such as IIBench. In the next…
Post: Introducing tpce-like workload for MySQL
February 8, 2010 By 3 Comments
… using tpcc-mysql benchmark for long time, and there many results published … stats for 10 seconds: | Com_select | 46272 | | Com_update | 5214 | | Com_delete | 385 | | Com_insert | 3468 | | Com_commit | 5404…) transactions, and the summary result in TpsE (transactions per seconds). Expect our results …
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total records: 10000000; write rows per sec… process list I could see some single value insert statements taking over 5 seconds… So it does not work very well. Note…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
I am a newbie to MySQL and am not getting the high insert throughput as in this benchmark. Could you post the my… multiple inserts per transaction for 1 innodb table (25 inserts or .2 seconds of data to be inserted) I got 1121, 1133, and 1166 inserts per second into that one table. using autocommit for innodb inserts I got 1125, and 1158 inserts per second…
Post: How expensive is a WHERE clause in MySQL?
October 31, 2008 By 16 Comments
… ) ENGINE=InnoDB DEFAULT CHARSET=latin1; insert into t(a) values(current_date); insert into t select * from t; ….01 seconds, ranging from 4.83 to 5.17 seconds. Next I ran it with a trivial WHERE clause: mysql> … about 2.95 seconds, or 351 nanoseconds per row. It doesn’t seem like much per row, but it …
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 16 Comments
… very important. Second thing – Partitioning. Unfortunately MySQL 5.5 leaves the huge bottleneck for write workloads in place – there is per index rw… your select queries dramatically. The inserts in this case of course are bulk inserts… using single value inserts you would get much lower…
Post: How many partitions can you have ?
December 5, 2009 By 18 Comments
…1000001) ); I used MySQL 5.1…inserted to them per insert statement. As I tested the UPDATE path on INSERT…inserts) the regression became even larger. 1 partition insert took 50 seconds to complete, 10 partitions 52, 100 partitions 72, 1000 partitions 290 seconds…. From this benchmarks the performance …
