Skip to content

importccl: use direct datum workload generator by default#36250

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
dt:workload-import-default
May 7, 2019
Merged

importccl: use direct datum workload generator by default#36250
craig[bot] merged 1 commit intocockroachdb:masterfrom
dt:workload-import-default

Conversation

@dt
Copy link
Copy Markdown
Contributor

@dt dt commented Mar 27, 2019

This removes the COCKROACH_IMPORT_WORKLOAD_FASTER flag now that it has been tested for awhile,
and, critically, now that it is actually faster than writing/reading CSVs.

The difference is most pronouced when using distsql sorted IMPORT as it reads twice --
for sampling and then ingest -- but is also measurable in single-pass 'direct' ingest.

All checked passed when running 'fixtures import tpcc --warehouses=1000', and ingest time
using distsql import went from 55m via CSV to 41m using the worklaod reader directly.

Release note: none.

@dt dt requested review from a team and danhhz March 27, 2019 22:28
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

Copy link
Copy Markdown
Contributor

@danhhz danhhz left a comment

Choose a reason for hiding this comment

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

As discussed in #36106, I'm comfortable with this. Now that I'm sitting here with the Approve button in front of me, I'm getting cold feet about merging this before 19.1.0 goes out the door. This only affects roachtests run on master, but even with our due diligence, there's always a chance this destabilizes fixtures import and we really need to get every roachtest datapoint we can right now. Are you okay with waiting on this for a couple weeks?

@dt
Copy link
Copy Markdown
Contributor Author

dt commented Mar 28, 2019

SGTM

@danhhz
Copy link
Copy Markdown
Contributor

danhhz commented May 6, 2019

19.1.0 is out, should we merge this?

This removes the COCKROACH_IMPORT_WORKLOAD_FASTER flag now that it has been tested for awhile,
and, critically, now that it is actually faster than writing/reading CSVs.

The difference is most pronouced when using distsql sorted IMPORT as it reads twice --
for sampling and then ingest -- but is also measurable in single-pass 'direct' ingest.

All checked passed when running 'fixtures import tpcc --warehouses=1000', and ingest time
using distsql import went from 55m via CSV to 41m using the worklaod reader directly.

Release note: none.
@dt dt force-pushed the workload-import-default branch from 8a10324 to bd7e022 Compare May 7, 2019 00:42
@dt
Copy link
Copy Markdown
Contributor Author

dt commented May 7, 2019

bors r+

craig bot pushed a commit that referenced this pull request May 7, 2019
36250: importccl: use direct datum workload generator by default r=dt a=dt

This removes the COCKROACH_IMPORT_WORKLOAD_FASTER flag now that it has been tested for awhile,
and, critically, now that it is actually faster than writing/reading CSVs.

The difference is most pronouced when using distsql sorted IMPORT as it reads twice --
for sampling and then ingest -- but is also measurable in single-pass 'direct' ingest.

All checked passed when running 'fixtures import tpcc --warehouses=1000', and ingest time
using distsql import went from 55m via CSV to 41m using the worklaod reader directly.

Release note: none.

37136: telemetry: make telemetry endpoint read-only r=dt a=dt

Previously it was reusing the code used in periodic reporting exactly, which had the side-effect of clearing the report.
This changes the endpoint to pass a paramter to the report generation to prevent that.

It also makes explicit what the various callers of GetFeatureCounts want -- raw vs quantized, read-only vs resetting.

Release note: none.

Co-authored-by: David Taylor <tinystatemachine@gmail.com>
@craig
Copy link
Copy Markdown
Contributor

craig bot commented May 7, 2019

Build succeeded

@craig craig bot merged commit bd7e022 into cockroachdb:master May 7, 2019
@dt dt deleted the workload-import-default branch May 10, 2019 21:05
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants