Joe Daly wrote:
Hi Jay,
Im trying to get up to speed, on the development here so excuse my silly
question.
Hi! Sorry for th delayed reply...
What were these benchmarks against?
These benchmarks are against each BZR revision of Drizzle on one of our
benchmarking machines (16-core x86 box).
You can read more about our benchmarks on this thread:
https://lists.launchpad.net/drizzle-discuss/msg03687.html
Cheers!
Jay
thanks
--Joe Daly
On Wed, May 13, 2009 at 9:21 AM, Jay Pipes <[email protected]> wrote:
Hi all!
Sorry for the delay in getting the data for analysis of our benchmark
revision history! Attached is a tarball containing a single SQL script to
populate a database with our data for revisions 980 through 1008.
To setup, do:
$> tar -xzf drizzle_stats.tar.gz
$> mysqladmin --user=root --password=$yourpass create drizzle_stats
$> mysql --user=root --password drizzle_stats < drizzle_stats.sql
<enter your password>
Here are the sysbench tables:
mysql> desc sysbench_runs;
+-----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+----------------+
| run_id | int(11) | NO | PRI | NULL | auto_increment |
| config_id | int(11) | NO | | NULL | |
| server | varchar(20) | NO | | NULL | |
| version | varchar(50) | YES | | NULL | |
| run_date | datetime | NO | | NULL | |
+-----------+-------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql> desc sysbench_config;
+-----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+----------------+
| config_id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | NO | | NULL | |
+-----------+--------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)
mysql> desc sysbench_run_iterations;
+---------------------------+---------------+------+-----+---------+
| Field | Type | Null | Key | Default |
+---------------------------+---------------+------+-----+---------+
| run_id | int(11) | NO | PRI | NULL |
| concurrency | int(11) | NO | PRI | NULL |
| iteration | int(11) | NO | PRI | NULL |
| tps | decimal(13,2) | NO | | NULL |
| read_write_req_per_second | decimal(13,2) | NO | | NULL |
| deadlocks_per_second | decimal(5,2) | NO | | NULL |
| min_req_latency_ms | decimal(10,2) | NO | | NULL |
| avg_req_latency_ms | decimal(10,2) | NO | | NULL |
| max_req_latency_ms | decimal(10,2) | NO | | NULL |
| 95p_req_latency_ms | decimal(10,2) | NO | | NULL |
+---------------------------+---------------+------+-----+---------+
10 rows in set (0.00 sec)
To see a view of the data which I've been showing on this list, I use this:
mysql> SELECT r.version, c.name, i.concurrency, AVG(i.tps) as TPS
-> FROM sysbench_config c
-> NATURAL JOIN sysbench_runs r
-> NATURAL JOIN sysbench_run_iterations i
-> WHERE r.server = 'drizzled'
-> GROUP BY r.version, c.name, i.concurrency;
which shows you data in this format:
*************************** 1. row ***************************
version: fix-bitset-regression-1009
name: innodb_1000K_readonly
concurrency: 2
TPS: 1080.706667
Have fun. :)
Cheers,
Jay
_______________________________________________
Mailing list:
https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss>
Post to : [email protected]
Unsubscribe :
https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss>
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
