… of MySQL to gain better performance on Fusion-io ioDrive card. Full report is available in PDF For tests we used tpcc-mysql package, which generates TPCC-like workload on MySQL systems. Server hardware: Dell PowerEdge R815 Storage…
Post: READ-COMMITED vs REPETABLE-READ in tpcc-like load
February 11, 2010 By 6 Comments
… and again. Recently it was discussed in InnoDB : Any real performance improvement when using READ COMMITED isolation level ? and in Repeatable… explains why READ COMMITED is better for TPCC load, so why don’t we take tpcc-mysql bencmark and check on results. I… on row level having small dataset. I used as usually tpcc-mysql benchmark with 16 and 32 (for 10w) concurrent users. Also…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… a FusionIO 320GB MLC card. First, the results for tpcc-mysql, 500w (around 50GB of data) on RAID10. I used innodb… fix the buffer pool scalability issue. Let’s see how MySQL performance changes for the last workload if we set innodb_buffer…: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables server…
Post: Intel SSD 910 in tpcc-mysql benchmark
September 7, 2012 By 9 Comments
… is suitable to use with MySQL. Benchmark date: Sep-2012 Benchmark goal: Test Intel SSD 910 under tpcc-mysql workload and compare with…: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB… is about the same as with Fusion-io card. The performance of Intel SSD 910 is about ~30% worse, but it…
Post: Introducing tpce-like workload for MySQL
February 8, 2010 By 6 Comments
We have been using tpcc-mysql benchmark for long time, and there many results published in … TPCE. Yasufumi made some efforts to make TPCE working with MySQL, and we are making it available for public consideration. You… XtraDB/InnoDB performance research and/or compare with available Storage Engines for MySQL. The workload in tpce is quite different from tpcc. Tpcc is…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
…_buffer_pool_size settings: 13G, 52G, an 144G on a tpcc-mysql workload with 1000W (around 100GB of data). This combination of… I’ve seen NOTPM greater than 100,000 for a tpcc-mysql workload with 1000W. The main factors that allow us to… a good choice for if you are looking for high MySQL performance, and we tune Percona Server to get the most from…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
…_pool_size, like 13GB, 52GB, and 144GB, for testing the tpcc-mysql database with size 100G. This was needed in order to… get stable performance (as you may see from Dimitri’s post, http://dimitrik.free.fr/blog/archives/2010/12/mysql-performance-analyzing-perconas-tpcclike-workload-on-mysql-55.html). But you can’t really…
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
… rest time we played with performance trying to align XtraDB performance with MySQL 5.4 ® and also port all performance fixes to 5.0… 10 on 8 SAS disks. And again as usually our tpcc-mysql scripts with 100W (about 10GB of data) and 16 connection… benchmarks I made it 3GB. Raw results and rest of mysql parameters are here http://spreadsheets.google.com/ccc?key=tOWmcwiHDD6…
Post: Adaptive flushing in MySQL 5.6
September 4, 2012 By 8 Comments
… check what do we have now. For experiment I took tpcc-mysql workload (3 hours runs), 2500W ( ~250GB of data), on Dell… for MySQL 5.6. For an initial experiment, let’s see what the result we are getting in MySQL 5.5 ( MySQL 5…. You may see that bigger log files, again, improve overall performance, but not stability. With 2x8G logs, there is no sharp…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…? People usually run generic benchmark tools like sysbench, tpcc or mysqlslap that are good to know the….cnf or schema change can affect the overall performance of your application. In the example I’m… the load: percona-playback –mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db –query-log…
