…very frequent cases with performance problems with MySQL is what they happen every so often or … it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, …Do push concurrency too high Many developers will test script with multiple level of concurrency and…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration… cause downward spikes in performance. Other then that, I have also disabled query cache to avoid contention caused by query cache on write heavy workload. OK, so that was all about the configuration of the EC2 instance and MySQL. Now…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…size is not going to provide the best possible query performance. As I mentioned at the start that BKA …look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M … workload. I intend to run tests to see what specific types of queries would benefit from Hash Join …
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… exceeded; try restarting transaction transaction2 > INSERT INTO t VALUES(31); Query OK, 1 row affected (0.00 sec) After running the… log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163 localhost msandbox TABLE LOCK table `test`.`t` trx id… gaps locks in your transactions affecting the concurrency and the performance you can disable them in two different ways: 1- Change…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… how MySQL‘s Transactions work with DDL, In particular ALTER TABLE. When ALTER TABLE is Performed …(before dump has completed) mysql> alter table C add i int not null; Query OK, 1 row …-23 7:27:18 SESSION1: mysql> select * from C; +——+—+ | t | i | +——+—+ | test | 0 | +——+—+ 1 row in …
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
Shard-Query is an open source tool kit which helps improve the performance of queries against a MySQL database by distributing the work over… testing was limited to a subset of Vadim’s test queries (see that post). As this new test schema is normalized, Vadim’s test queries must…, and additionally two new test queries have been added. To model real world complexity, each of the test queries feature at least one join…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory …2*Quad Core Xeon running CentOS5 was tested using ext2 filesystem and SysBench tool….queries/sec with multiple threads. So Innodb took very high hit supplied with high performance IO subsystem. But not only performance…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…MySQL interactive performance – serving simple standard web traffic is drastically impacted when some heavy queries…
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… set processing performance Shard-Query + ICE scales very well up to at least 20 nodes This post is a detailed performance analysis of… “cloud” test to show that this works over the network, in a real world environment. There is a slight performance oddity at… shows the same data in another way: Concurrency testing is important too. I tested a 20 node m1.large system at 1…
Post: MySQL Performance Blog now uses Sphinx for Site Search
February 15, 2008 By 52 Comments
… not have any query language so I always used Google search if I wanted to find something on MySQL Performance Blog. Today we… open source software in a few weeks – just want to test it a bit more and write proper documentation before announcing… for fun and for SEO. Hope this addition will make MySQL Performance Blog more useful for you. UPDATE: For those looking to…
