Hi Jay, Im trying to get up to speed, on the development here so excuse my silly question.
What were these benchmarks against? 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
