…. We went a step further 1) By turning logs into benchmarks so you use real user input (real queries) and not… benchmark virtualized servers with different workloads. We have made the same observations as you, but from a different angle. In fact the servers…-closer-look/3. We have applied it to MS SQL Server, not to MySQL yet, but it is the same idea and only…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… site. For example These Are results recently published for Microsoft SQL Server. Of course this is much more powerful system but still…: We can see MySQL capabilities to run complex analytics queries, in particular those presented in TPC-H benchmark are still subpar even with changes which are currently seen in MySQL 6.0 tree. There…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… worked on some of the previous SpecJAppServer Benchmarks several years ago while being employed by MySQL. These are great results, plus they… helped this benchmark because it has a lot of same queries an Prepared Statements can be more efficient on the server side… MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode…
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
…the server will be required, or because query cache does not work. I’ve done a simple benchmark… Save on data conversion and copying Avoid SQL Injection Save memory on handling blobs There …close prepared statements – Many memory leaks reported in MySQL Server turned out to be prepare statements or …
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… every testing itch. It is based on technology SQL Server was using in 1998 (MySQL began using it in ~2007, IIRC). So this…=xtrabackup_basic –basedir=/path/to/mysql –xtrabackup-path=/mah/path –innobackupex-path=/mah/other/path –default-server-type=mysql –no-shm Some next steps for dbqp include: 1) Improved docs 2) Merging into the Percona Server trees 3…
Post: Getting real life query speeds with MySQL
January 10, 2007 By 10 Comments
… workloads. The attempt to fix it is often using SELECT SQL_NO_CACHE or disabling QueryCache for the test. This works… caches inside MySQL (key_buffer and innodb_buffer_pool_size) which can be cleared by MySQL restart. Even if you restart MySQL server there… real world. Get large number of similar queries from your MySQL server logs or generate using different user ids etc but make…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…benchmarks. Let’s start with a table containing 4 million rows and one secondary key: mysql…sql $ mysqldump -uroot test –innodb-optimize-keys > dump_optimized.sql $ time mysql -uroot test < dump_unoptimized.sql… Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in Percona Server…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… with existing MySQL data sets and queries. Another advantage is that it works with all MySQL storage engines. This set of benchmarks evaluates… dimensional schema Test environment For this benchmark, a test environment consisting of a single commodity database server with 6 cores (+6ht) and…: The MySQL command line client was used to execute the a script file containing the 11 queries. This same SQL script was…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 20 Comments
… so I decided to use them for benchmarking. On the desktop, I installed Percona-Server-11.2 which I configured with the….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…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
… VoltDB with stored procedures, not with arbitrary SQL queries. It is designed to be very …services for VoltDB. We’re focused on MySQL software and services. I am not a …benchmarks at that scale — this is a mathematical model based on a smaller benchmark. Also note that these are not high-end servers…
