Welcome to DBbenchmarks.com, a publicly accessible database that tracks anonymously submitted data about MySQL server performance. We need your help populating the database and in return you get hard facts about how your hardware and configuration compares to the performance of other setups. You can use this site to see research the performance of certain types of hardware when running MySQL. Our open-source benchmarking script is free to own, use, audit, and modify. We only ask that you allow the script to connect to this database and submit the results anonymously. We only track the following data from the server and do not collect any other information. See below for the variable list.
Download and contribute your stats!
- Download the benchmarking script for free: click here
- Read the super quick installation instructions here: click here
- Then, check your benchmark results here: go to the benchmark database.
Current Stats Tracked
- MYSQL_VERSION = MySQL version
- MYSQL_INNODB_BUFFER_POOL_SIZE = MySQL InnoDB buffer pool size
- MYSQL_SYNC_BINLOG = MySQL binlog sync setting
- MYSQL_TX_ISOLATION = MySQL transaction isolation level
- MYSQL_INNODB_FLUSH_TX = MySQL innodb_flush_log_at_trx_commit setting
- CPU_MODEL / MODEL = CPU brand/model
- CPU_QUANT / CORES = CPU core quantity
- MEMORY_TOTAL_BYTES / MEM_TOTAL= operating system memory total size
- MEMORY_FREE_BYTES / MEM_FREE = operating system memory free size
- MEMORY_CACHED_BYTES / MEM_CACHED= operating system memory cached size
- MEMORY_ACTIVE_BYTES / MEM_ACTIVE = operating system memory active size
- SWAP_TOTAL_BYTES / SWAP_TOTAL = operating system swap total size
- SWAP_FREE_BYTES / SWAP_FREE = operating system swap free size
- SYSTEM_OS / OS = operating system type
- SYSTEM_KERNEL / KERNEL = operating system kernel version
- SYSTEM_ARCH / ARCH = operating system architecture (32bit, 64bit)
- INSERT_OLTP_YES / INDEX_TX_Y = benchmark used transactions
- INSERT_OLTP_NO / INDEX_TX_N = benchmark did not use transactions
- SELECT_INDEX_YES_SEQ / SELECT_INDEX_SEQ = benchmark for indexed sequential selects
- SELECT_INDEX_YES_RAND / SELECT_INDEX_RAND = benchmark for indexed random selects
- SELECT_INDEX_NO_SEQ / SELECT_SEQ = benchmark for non-indexed sequential selects
- SELECT_INDEX_NO_RAND / SELECT_RAND = benchmark for non-indexed random selects
Current operating systems supported
- Linux – kernel version 2.6 (tested on Redhat, Fedora, Ubuntu, Debian, CentOS)
- Mac OSX – version 10.6 (tested on Intel hardware) note: PPC might work, try it out and let us know!
- FreeBSD – Release 8.1 tested
- OpenBSD – Release 4.7 tested
- MySQL: version 5.0 or later
- Python: version 2.4 or later, requires the MySQLdb module.
We’re in the process of writing benchmarking scripts for Oracle, SQL Server, PostgreSQL, and various NoSQL database servers.
- Improvements, suggestions: email “contact at kontrollsoft dot com”.
- Bug reports: click here -> http://code.google.com/p/dbbenchmark/issues/list