runtime_bloom_filter_max_size specifies the maximum memory usage in bytes allowed for the runtime filter of the BLOOM_FILTER type.
Note
This variable was introduced in OceanBase Database V4.2.0.
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 2147483648 |
| Value range | [0, 9223372036854775807] |
| Effective scope |
|
| Read-only | No |
| Involved in serialization | Yes |
| Effective only after restart | No |
Examples
set runtime_bloom_filter_max_size = 2 * 1024 * 1024 * 1024;
set global runtime_bloom_filter_max_size = 20 * 1024 * 1024;