Configuration Parameters

MyTile has several table and column parameters

Table Parameters

These are set upon table creation as follows:

SQL
create table test_array (
...
) engine=MyTile <table-parameters>; // e.g., array_type='SPARSE'

Property

Description

Default

Possible Values

Required

uri

Array URI

""

*

Yes

array_type

Array type

SPARSE

SPARSE, DENSE

No

cell_order

Cell order

ROW_MAJOR

ROW_MAJOR, COL_MAJOR

No

tile_order

Tile order

ROW_MAJOR

ROW_MAJOR, COL_MAJOR

No

capacity

Tile capacity

10000L

>0

No

Column Parameters

These are set upon table creation as follows:

SQL
create table test_array (
<column-parameters> // e.g., dim0 integer DIMENSION=1 lower_bound="0" upper_bound="100" tile_extent="1"
) engine=MyTile <table-parameters>;

Property

Description

Datatype

Default

Possible Values

Required

dimension

Column is a dimension

boolean

0

0, 1

No

lower_bound

Domain lower bound

string

"0"

Any value of datatype

No

upper_bound

Domain upper bound

string

Datatype MAX

Any value of datatype

No

tile_extent

Tile extent

string

"10"

Any Value of Datatype

No

TileDB Parameters

You can set any of the TileDB configuration parameters as follows:

SQL
set mytile_tiledb_config=<list-of-params>;
// E.g., set mytile_tiledb_config='vfs.num_threads=12,vfs.s3.aws_region=us-east-1';

MariaDB System Parameters

mytile_read_buffer_size

  • Description: Size in bytes of the buffers to use for each attribute/coordinates when performing a read.

  • Command line: --mytile-read-buffer-size

  • Scope: Global

  • Dynamic: Yes

  • Data Type: long

  • Default Value: 100M

mytile_write_buffer_size

  • Description: Size in bytes of the buffers to use for each attribute/coordinates when performing a write.

  • Command line: --mytile-write-buffer-size

  • Scope: Global

  • Dynamic: Yes

  • Data Type: long

  • Default Value: 100M

mytile_delete_arrays

  • Description: Controls if a delete table statement causes the array to be deleted on disk or just deregistered from MariaDB. A true value causes actual deletions of data.

  • Command line: --mytile-delete-arrays

  • Scope: Global

  • Dynamic: Yes

  • Data Type: boolean

  • Default Value: false