Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Spanner Support #48

Merged
merged 11 commits into from Oct 27, 2021
Merged

Spanner Support #48

merged 11 commits into from Oct 27, 2021

Conversation

timveil
Copy link
Collaborator

@timveil timveil commented Oct 25, 2021 •
edited by lmwnshn

Closes #47.

related to issue #47

i've added basic spanner support and specifically added configuration for the ycsb benchmark. Testing was done using Spanner's emulator Docker image. I've included a readme that describes the configuration and usage of the Emulator. This should now allow interested parties to easily add additional benchmark configurations for Spanner.

@timveil timveil requested a review from lmwnshn October 25, 2021 17:52
@timveil timveil marked this pull request as ready for review October 25, 2021 17:52
@github-actions
Copy link

Commit Hash: fec2b89
POSTGRES : PostgreSQL 14.0 (Debian 14.0-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

auctionmark, 225.27968534184197
chbenchmark, 0.7499688882406423
epinions, 1993.7537545524553
hyadapt, 0
noop, 1000.0317573166183
resourcestresser, 0.233332252950558
seats, 648.2404293242814
sibench, 1752.4123251518213
smallbank, 100.01592981263923
tatp, 1912.491503597121
tpcc, 180.03154806248907
tpch, 14.666395973884976
twitter, 2255.0416160183595
voter, 716.5407388781427
wikipedia, 558.790298012764
ycsb, 2245.3573317586283

@github-actions
Copy link

Commit Hash: fec2b89
MYSQL : 8.0.27

auctionmark, 246.04994786201604
chbenchmark, 0.14999776170590023
epinions, 650.8304221363136
hyadapt, 174.91583519549826
noop, 1000.0395633704414
resourcestresser, 0.2999996304604552
seats, 199.04758043400906
sibench, 427.90535122676863
smallbank, 99.9967720625325
tatp, 667.0551779308669
tpcc, 65.98292923517953
tpch, 1.3333079654119508
twitter, 1437.777827602772
voter, 157.6331391240515
wikipedia, 305.56402580411003
ycsb, 901.3055669233706

@github-actions
Copy link

Commit Hash: fec2b89
COCKROACHDB : CockroachDB CCL v21.1.11 (x86_64-unknown-linux-gnu, built 2021/10/18 14:39:35, go1.15.14)

auctionmark, 41.826574300763795
chbenchmark, 0.2999894389917961
epinions, 727.4059250545039
hyadapt, 33.24987444237829
noop, 1000.0080420675877
resourcestresser, 0.129999878257714
seats, 150.0094831633271
sibench, 306.4491380849097
smallbank, 100.00281175821803
tatp, 868.1003448805341
tpcc, 44.74988370474806
tpch, 2.9332046939260885
twitter, 953.0048581747608
voter, 286.7859432749355
wikipedia, 148.8852754546969
ycsb, 1046.2710469730157

apavlo
apavlo approved these changes Oct 26, 2021
View reviewed changes
Copy link
Member

@apavlo apavlo left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

apavlo
apavlo reviewed Oct 26, 2021
View reviewed changes
Copy link
Member

@apavlo apavlo left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Quick question.

src/main/resources/benchmarks/ycsb/ddl-spanner.sql Outdated Show resolved Hide resolved
@timveil timveil requested a review from apavlo October 26, 2021 21:08
@github-actions
Copy link

Commit Hash: 00990c4
MYSQL : 8.0.27

auctionmark, 542.280370087441
chbenchmark, 1.6999996581017354
epinions, 1357.1850263133233
hyadapt, 194.74685202100207
noop, 1000.0918507682223
resourcestresser, 0.1499983359059616
seats, 394.72816000633185
sibench, 1104.1665922638235
smallbank, 99.99996290334708
tatp, 1383.1611303337156
tpcc, 118.48331725119773
tpch, 2.0000232879075237
twitter, 2109.7996796021744
voter, 397.7297907010569
wikipedia, 464.01264683230465
ycsb, 1673.6433423025726

@github-actions
Copy link

Commit Hash: 00990c4
POSTGRES : PostgreSQL 14.0 (Debian 14.0-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

auctionmark, 259.6624213591857
chbenchmark, 0
epinions, 2714.7236673334887
hyadapt, 0
noop, 1000.0569099281097
resourcestresser, 0.23332972150202053
seats, 826.7628732167962
sibench, 2532.0705260266277
smallbank, 100.0031195890667
tatp, 2559.558669069649
tpcc, 234.26634757247464
tpch, 10.998802464136208
twitter, 3031.0374655001724
voter, 983.5946608022824
wikipedia, 777.6088765679812
ycsb, 3056.7945237566023

apavlo
apavlo approved these changes Oct 27, 2021
View reviewed changes
Copy link
Member

@apavlo apavlo left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

@github-actions
Copy link

Commit Hash: 00990c4
MYSQL : 8.0.27

auctionmark, 608.1395307360791
chbenchmark, 1.5499902336923699
epinions, 1527.7512161366801
hyadapt, 194.64719859534426
noop, 1000.0260266765035
resourcestresser, 0.049999488757727424
seats, 435.2652691387038
sibench, 1402.7029155479017
smallbank, 99.99873840924964
tatp, 1545.722828382451
tpcc, 124.33174220615125
tpch, 1.6923235842024884
twitter, 2119.060942588613
voter, 470.1153010914106
wikipedia, 468.4820175313148
ycsb, 1817.9448751527989

@github-actions
Copy link

Commit Hash: 00990c4
POSTGRES : PostgreSQL 14.0 (Debian 14.0-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

auctionmark, 264.1159494774136
chbenchmark, 0.1999920107891502
epinions, 2094.2941161853955
hyadapt, 0
noop, 1000.0220575346225
resourcestresser, 0.31666316237711284
seats, 636.1833264625534
sibench, 2062.8053930913925
smallbank, 100.00613153074117
tatp, 1954.044588047136
tpcc, 177.4331636332984
tpch, 8.799296814754205
twitter, 2368.9285290709386
voter, 754.9554153144604
wikipedia, 577.9894187766099
ycsb, 2274.949953936409

@github-actions
Copy link

Commit Hash: 00990c4
COCKROACHDB : CockroachDB CCL v21.1.11 (x86_64-unknown-linux-gnu, built 2021/10/18 14:39:35, go1.15.14)

auctionmark, 40.42656167430432
chbenchmark, 0.7996249211376794
epinions, 717.6352807646282
hyadapt, 32.616307290951646
noop, 1000.0055065636119
resourcestresser, 0.17333316368465493
seats, 146.37301314334292
sibench, 265.6381398767955
smallbank, 100.00427199158678
tatp, 813.8295576185291
tpcc, 44.09925651372972
tpch, 2.933335550348342
twitter, 913.932679067207
voter, 285.1732303135533
wikipedia, 158.98921415581276
ycsb, 1001.8008823740452

@lmwnshn lmwnshn merged commit a3f1bbd into cmu-db:main Oct 27, 2021
timveil added a commit to timveil-cockroach/benchbase that referenced this pull request Oct 27, 2021
@timveil
Merge pull request #1 from cmu-db/main
c4b937d 
Add support for Spanner (cmu-db#48)
@timveil timveil mentioned this pull request Oct 27, 2021
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@apavlo apavlo apavlo approved these changes

@lmwnshn lmwnshn Awaiting requested review from lmwnshn

Assignees

@timveil timveil

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

Add Google Spanner support
3 participants
@timveil @apavlo @lmwnshn