Skip to content

Instantly share code, notes, and snippets.

@gdi

gdi/MySQL Benchmark Data (for ttserver comparison)

Created June 30, 2009 18:38
Show Gist options
  • Save gdi/138319 to your computer and use it in GitHub Desktop.
Save gdi/138319 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MySQL Benchmark Data (for ttserver comparison)
Script lives here: http://gist.github.com/138318
There is a spreadsheet of a bigger comparo here: http://spreadsheets.google.com/pub?key=rWBwk7nwt6RKn0zyq6RrCDA&output=html
Benchmarking mysql with 2888750 email records
MySQL ISAM / MySQL-Ruby / Indexed / Untuned
user system total real
find record by pk 0.000000 0.000000 0.000000 ( 0.000489)
find by message_id 0.000000 0.000000 0.000000 ( 0.000370)
pk_only message id 0.000000 0.000000 0.000000 ( 0.000263)
find by domain 0.540000 0.090000 0.630000 ( 1.911494)
pk_only domains 0.350000 0.010000 0.360000 ( 1.470128)
find by policy_id 0.650000 0.060000 0.710000 ( 2.103123)
pk_only policy_id 0.430000 0.010000 0.440000 ( 1.680393)
pk/ruby policy_id (b=1K) 1.110000 0.070000 1.180000 ( 4.822244)
gdis-imac-2:tokyo_performance drat$ ruby mysql_query_benchmark.rb
Benchmarking mysql with 2888750 email records
MySQL ISAM / MySQL-Ruby / Indexed / Untuned
user system total real
find record by pk 0.000000 0.000000 0.000000 ( 0.000518)
find by message_id 0.000000 0.000000 0.000000 ( 0.000380)
pk_only message id 0.000000 0.000000 0.000000 ( 0.000253)
find by domain 0.530000 0.090000 0.620000 ( 1.857743)
pk_only domains 0.360000 0.010000 0.370000 ( 1.485446)
find by policy_id 0.650000 0.060000 0.710000 ( 2.433397)
pk_only policy_id 0.430000 0.010000 0.440000 ( 1.701205)
pk/ruby policy_id (b=1K) 1.110000 0.070000 1.180000 ( 4.753596)
gdis-imac-2:tokyo_performance drat$ ruby mysql_query_benchmark.rb
Benchmarking mysql with 2888750 email records
MySQL ISAM / MySQL-Ruby / Indexed / Untuned
user system total real
find record by pk 0.000000 0.000000 0.000000 ( 0.000536)
find by message_id 0.000000 0.000000 0.000000 ( 0.000382)
pk_only message id 0.010000 0.000000 0.010000 ( 0.000253)
find by domain 0.530000 0.100000 0.630000 ( 1.881027)
pk_only domains 0.360000 0.010000 0.370000 ( 1.493075)
find by policy_id 0.650000 0.060000 0.710000 ( 2.102094)
pk_only policy_id 0.430000 0.010000 0.440000 ( 1.689580)
pk/ruby policy_id (b=1K) 1.110000 0.070000 1.180000 ( 4.736068)
gdis-imac-2:tokyo_performance drat$ ruby mysql_query_benchmark.rb
Benchmarking mysql with 2888750 email records
MySQL ISAM / MySQL-Ruby / Indexed / Untuned
user system total real
find record by pk 0.000000 0.000000 0.000000 ( 0.000570)
find by message_id 0.000000 0.000000 0.000000 ( 0.000404)
pk_only message id 0.000000 0.000000 0.000000 ( 0.000360)
find by domain 0.540000 0.090000 0.630000 ( 1.893256)
pk_only domains 0.350000 0.010000 0.360000 ( 1.469658)
find by policy_id 0.650000 0.060000 0.710000 ( 2.124684)
pk_only policy_id 0.450000 0.020000 0.470000 ( 1.804665)
pk/ruby policy_id (b=1K) 1.110000 0.060000 1.170000 ( 4.755688)
gdis-imac-2:tokyo_performance drat$ ruby mysql_query_benchmark.rb
Benchmarking mysql with 2888750 email records
MySQL ISAM / MySQL-Ruby / Indexed / Untuned
user system total real
find record by pk 0.000000 0.010000 0.010000 ( 0.000623)
find by message_id 0.000000 0.000000 0.000000 ( 0.000441)
pk_only message id 0.000000 0.000000 0.000000 ( 0.000253)
find by domain 0.530000 0.090000 0.620000 ( 1.861494)
pk_only domains 0.360000 0.010000 0.370000 ( 1.482972)
find by policy_id 0.660000 0.060000 0.720000 ( 2.163038)
pk_only policy_id 0.430000 0.010000 0.440000 ( 1.750769)
pk/ruby policy_id (b=1K) 1.120000 0.070000 1.190000 ( 4.946889)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment