…346GB of RAM , and I ran the tpcc-mysql benchmark with 500W (about 50GB of data) on the… I will show different graphs: benchmark throughput – This is New Order Transactions per 10 seconds. dirty page – This …group = 2 innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_purge_threads=1 …
Post: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
… from the fact it is the only MySQL storage engine which defaults to HASH index …deletes per second while converting table to MyISAM I get about 600 deletes per second and about 4000 deletes per second for… was also disabled, meaning Innodb could delay writes and do all the changes directly in memory…
Post: Introducing tpce-like workload for MySQL
February 8, 2010 By 6 Comments
…been using tpcc-mysql benchmark for long time, and there many results published in… Storage Engines for MySQL. The workload in tpce is quite different from tpcc. Tpcc is write intensive, while…TradeResult) transactions, and the summary result in TpsE (transactions per seconds). Expect our results soon…
Post: Effect of adaptive_flushing
December 4, 2009 By 5 Comments
… one troubling thing: ~2GB of uncheckpointed data. mysql> SHOW INNODB STATUS\G …. Database pages 2318457… write activity, the system and/or innodb can become very slow (Yasufumi’s benchmarks… number of writes they can perform before failure. This means that more writes per second == shorter lifetime…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
…questions along the lines of “how many transactions per second MySQL can do” or “how many servers I …paper is using “real world” kind of application benchmark which emulates internet shop activit. According to … catastrophy if you are wrong. I should write about some techniques and formulas which you …
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…MySQL Version: 5.6.7-RC Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB of data) Benchmark…Measurements are taken every second. Parameters to vary: … files. MySQL configuration: [mysqld] gdb innodb_file_per_table =…read_io_threads = 16 innodb_write_io_threads = 16 innodb_…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
I recently was asked what maximal amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have… would not take these as variable parameters and run simple benchmark. I took sysbench update_key scenario ( update indexed field on… I used Percon-XtraDB-5.1.43-9.1 for benchmarks. All used partitions are formatted in XFS and mounted with…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total records: 10000000; write rows per sec…. During this last test box felt really sluggish responding 10+ seconds for as simple command as “ls” even though loadavg was…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
…write queries against a 20M rows table: sysbench –test=oltp –oltp-table-size=20000000 –mysql-table-engine=innodb –mysql-socket=/tmp/mysql_sandbox5524.sock –mysql…benchmark results showing the QPS over 5 second periods with the new DROP TABLE implementation (MysQL…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… it out. I could do benchmarks, but that would not be interesting — we already know that benchmarks are unrealistic, and we know…, we’re getting a couple megabytes per second of reads, and generally less than a megabyte per second of writes, but the performance (latency) is…
