… on these same benchmarks in Tokyo tyrant. All to often people force themselves into using a database like MySQL with no thought… may contain all the vital stats for the game, be updated and stuffed back into the database. You would be surprised… do. Using this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… http://www.mysqlperformanceblog.com/files/benchpbxt/mysql.start and script to run whole loop of benchmarks http://www.mysqlperformanceblog.com/files/benchpbxt…: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method of benchmark: 1. Prepare table with 1,000,000 records…. It is also interesting to check PBXT performance on INSERT/UPDATE queries taking into account PBXT way to handle such queries…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
… what maximal amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high-end… take these as variable parameters and run simple benchmark. I took sysbench update_key scenario ( update indexed field on simple table) and used…-9.1 for benchmarks. All used partitions are formatted in XFS and mounted with nobarrier option. I run update key for various…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… hardware is different – MySQL benchmark use Sun Fire X4100 available in Nov 2005 using Opteron 285 CPU, PostgreSQL benchmarks use Sun Fire X4200… on published SpecJAppServer benchmark while still working for MySQL I remember we spot number of issues in MySQL exposed by this benchmark with only… getting at least 800 JOPS on updated software and hardware configuration, so I would argue MySQL is Slower. On the other hand…
Post: Mystery Performance Variance with MySQL Restarts
February 20, 2013 By 18 Comments
… up the benchmarks run to go over night in the loop, doing the benchmark run for 5 runs when restarting MySQL server and… to be a lot more careful with benchmarks. We need to do multiple runs with MySQL restarts in the end to get… with MySQL 5.6 being slower, yet the worse case performance difference looks lower than 26% I wrote about. I will update…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… Server/XtraDB based on the MySQL 5.5 code line. The answer: Yes, we are. My benchmarks here are based on Percona… a different way. UPDATE By request from commenter I put also results with different innodb_io_capacity for MySQL 5.5.8… used for benchmarks on FusionIO: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on… as you get on normal EC2 servers with EBS. I benchmarked the largest available RDS instance, which is listed as “High… RDS instance performed at various thread counts on the OLTP benchmark. Update Vadim and Peter have rightly pointed out that I shouldn…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… capacity of MySQL system ? We can look at CPU and IO consumption per Query and compare it to estimated (or benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL we can use Innodb…_WRITTEN: 0 ROWS_FETCHED: 485139 ROWS_UPDATED: 0 TABLE_ROWS_READ: 610954 SELECT_COMMANDS: 181243 UPDATE_COMMANDS: 0 OTHER_COMMANDS: 0 COMMIT…
Post: MySQL 5.5.4 in tpcc-like workload
April 21, 2010 By 25 Comments
….percona.com/docs/wiki/benchmark:mysql:554-tpcc:start I took MySQL-5.5.4 with InnoDB-1.1, tpcc-mysql benchmark with 200W ( about… 5.5-GA. UPDATE: (9-May-2010) I posted results with innodb_io_capacity=500 and 2000 for MySQL 5.5.4. http://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start#io_capacity_for_bp_24gb_mysql_554…
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 our … looking into different benchmarks, and one of them is TPCE. Yasufumi made some efforts to make TPCE working with MySQL, and we…, there is stats for 10 seconds: | Com_select | 46272 | | Com_update | 5214 | | Com_delete | 385 | | Com_insert | 3468 | | Com_commit | 5404…
