… I published results of DBT2 performance while varying the number of idle connections here, but I had compiled MySQL with the debugging…-Server 11.2 without the debug options and did another benchmark run. The result is shown below: As you can see…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… the benchmarks. Updated version here. I recently had to work with many customers having large number of connections opened in MySQL and…_conn.php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh -h 10.2.2… benchmarks. During all the benchmarks, the CPU load on the laptop was never above 10%. I also hacked a bit the “run_mysql…
Page: Presentations
May 3, 2006 By
…MySQL Performance in DBT2 benchmark. Focuses mostly on Innodb but many findings are generally valid. Download MySQL/Innodb Performance: Server and Schema MySQL…. Download MySQL Benchmark and Testing Project MySQL Users Conference 2003, San Jose, CA Presentation about projects MySQL Benchmark Group …
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… investigate how much. I took DBT2, an OSDL’s implementation of TPC-C. Hardware used The benchmark was run on a DELL… take more than a second to execute; logging every query; MySQL was run with default settings except following: [mysqld] user=root… queries are logged. In general logging all queries can hurt MySQL and you should consider the load while using it, especially…
Post: Linux IO Schedulers and MySQL
January 30, 2007 By 7 Comments
… versions it is very hard to evaluate benchmark results. This could be noticed by benchmarks we’ve done over years. Long time ago “AS” scheduler could be several times slower than deadline for MySQL workloads such as SysBench or DBT2 when it went down to 30% difference…
Post: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
… you to use a lot of foreign constructs to “original” MySQL style – to process data via cursors, handle error via Handlers… helper Debug Storage Procedure which will log some information in MySQL table but it is not convenient enough. Bad Parser Error… Procedures Indeed can help to Improve MySQL Performance. For DBT2 benchmarks we’ve tried a while back MySQL 5.0 was about 10% slower…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…5x improvements in DBT2 benchmarks on 8cores boxes (benchmark results is coming …execution with microseconds granularity. mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST; +—-+——+———–+——+———+——+———–+———————————————-+———+ | ID | …
Comment: Watch out for Marketing benchmarks
August 24, 2006 By 7 Comments
… you application was not well optimized for MySQL 4 it may work much faster on MySQL 5 – for example if you used… well with index merge. 2) You may get benefit from MySQL optimizations – like index merge may improve performance, some changes making… for your application – for example as you could see in benchmarks DBT2 benchmarks can be made 30% faster with 5.0… but if…
Comment: How Percona Develops Open-Source Software
January 12, 2009 By 4 Comments
Giuseppe, Ivan. Ok, we are using mysql-test suite for everyday testing, and adding our own tests … significant changes we run stress-test as: sqlbench, sysbench, dbt2, tpcc, tpce benchmarks. There is no code coverage measurements to prove full…
