…not just for new connections as in MySQL. This is very helpful for measurement …number of tmp tables created in memory vs on-disk, percentage of queries that …0.1381 1.7% 909 0.0002 1.00 0.00 SELECT wp_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 0xCFC0642B5BBD9AC7 0…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: UNION vs UNION ALL Performance
October 5, 2007 By 15 Comments
When I was comparing performance of UNION vs MySQL 5.0 index merge algorithm Sinisa pointed out I should be using …: mysql> explain (select * from test.abc where i=5) union all (select * from test.abc where j=5 and i!=5) \G *************************** 1. row *************************** id: 1…
Post: More Gotchas with MySQL 5.0
July 27, 2007 By 23 Comments
Working on large upgrade of MySQL 4.1 running Innodb to MySQL 5.0 and doing oprofile analyzes we found very interesting issue of … much higher for MySQL 5.0 compared to MySQL 4.1 It was something like 2-3 for MySQL 4.1 vs 40-60 for MySQL 5.0 At the same… Sleep shows much smaller value which is close in MySQL 5.0 and 4.1 Hopefully this issue will be fixed sooner or later…
Page: Presentations
May 3, 2006 By
…. Download MySQL Performance 5.0 vs 4.1 MySQL Users Conference 2006, Santa Clara, CA This presentation shows in numbers performance differences in MySQL 4.1 and 5.0, showing… if you’re planing on upgrading to MySQL 5.0 Download Optimizing MySQL on Source Code Level MySQL Users Conference 2006, Santa Clara, CA This…
Comment: InnoDB benchmarks
January 3, 2007 By 15 Comments
Pete, I don’t think the reason of degradation is debug code. If you look at our peresentation 5.0 vs 4.1 http://www.mysqlperformanceblog.com/files/presentations/UC2006-MySQL-5.0-vs-4.1.pdf you will see 5.0 release has degradation comparing to 4.1.
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix …cache enabled thread trx=1, No binlog trx=1, Binlog sync=0 trx=1, Binlog sync=1 1 382.39 371.17…2188.38 There is still performance difference binlogs vs no-binlogs, but it is much smaller when…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… fix for this scalability problem and it is merged into MySQL 5.0.30 “Enterprise” but according to the tests I’ve done… see MySQL 4.1 actually scaled pretty well with Niagra, suffering slow regression with increased concurrency rather than quick drop. In MySQL 5.0 it… seen much better on this picture Linux vs Solaris comparison is also pretty interesting. With MySQL Linux has higher peak but Solaris…
Comment: Percona build7 with latest patches
November 24, 2008 By 26 Comments
… HAVE_ATOMIC_BUILTINS 1 so it should be ok for -highperf effect 
Few numbers so well comparing “standard” vs “persona” MySQL 5.0.67: – data… continuing- I’ve found MySQL is keeping workload much(!) more better with “nnodb_thread_concurrency=8″ rather “0” – it creating so many…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 446 BUSY_TIME: 74 CPU_TIME: 0 BYTES_RECEIVED: 0…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The difference is… KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method of benchmark: 1…
