Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

DRAFT - Not yet in discussion

...

Below is an overview of a set of proposed guardrails with some example limits (which are subject to change):

ParameterExample LimitNotes
Single column size5 MBHard limit to prevent writing a large column value
Number of columns per Table50Hard limit to prevent creating too many columns per table
Number of items per Collection20

Soft limit to prevent creating collections with too many items

Number of fields per UDT10Hard limit to prevent creating large UDTs
Size of a collection5 MBSoft limit that warns when encountering large collections



Enable User-provided timestamps trueWhether to allow user-provided timestamps in write requests (USING TIMESTAMP...) 
Enable Read-before-write List operationstrueWhether to allow read-before-write list operations (setting/removing an item by index)



Disallowed Table properties

compression, compaction
List of table properties that are disallowed to be set by users
Disallowed write consistency levelsANY, ONE, LOCAL_ONE, ALLList of Consistency Levels that are disallowed to be used during writes



Number of secondary indexes per Table1Hard limit to prevent having lots of secondary indexes per table
Number of MVs per Table2Hard limit to prevent having lots of MVs
Total Number of User-created Tables100 (soft) / 200 (hard)Soft limit issues a warning when exceeded and hard limit issues a failure



Large partition size100 MBSoft limit that issues a warning when large partitions are being compacted
Number of partition keys in SELECT20Hard limit
Cartesian Product of values in IN condition25Hard limit. For example "a IN (1,2,...10) AND b IN (1,2...10)" results in cartesian product of 100



Disk usage 70% (soft) / 80% (hard)Local and Replica Disk usage are monitored to issue warnings/failures when the soft/hard limit is reached


Configuration of Guardrails

...