cube-js/cube

Set OLAP Mode for mySQL

Open

#5,850 opened on Dec 20, 2022

View on GitHub
 (2 comments) (0 reactions) (0 assignees)Rust (1,965 forks)batch import
help wanted

Repository metrics

Stars
 (19,563 stars)
PR merge metrics
 (Avg merge 5d 16h) (138 merged PRs in 30d)

Description

Is your feature request related to a problem? Please describe. MySQL and Planetscale, as a result, impose query timeouts when running on OLTP mode. Setting the mode to OLAP via a SQL set query resolves this.

Describe the solution you'd like Cube.js to support the setting of DB-level variables in the config file.

Describe alternatives you've considered I spoke to Rory from cube cloud support, and we tried multiple types of pre-aggregations over days.

Additional context Sample Error: (errno 2013) due to context deadline exceeded, elapsed time: 20.000298157s What I need to execute: SET workload=olap;

Contributor guide

Research direction
Examine the Cube.js configuration schema and database driver interface to add support for per connection SQL variables like 'SET workload=olap'.
Tech stack
javascripttypescriptnodejsmysql
Domain
backenddatabase
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
Git
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65