…PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference …useful for WAN deployments RSU, Rolling Schema Update. Schema change does not block operations… nodes XtraDB Cluster in 3 minutes Benchmarking Galera replication overhead Percona Server 5.5….
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… in 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables… directory or because random updates to 10000 distinct pages for index header updates not to mention modification time update is a lot of… in 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… 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: 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…
