SYSDISKSTORES
October 18, 2021 · View on GitHub
Contains information about all disk stores created in the SnappyData distributed system.
See CREATE DISKSTORE.
| Column Name | Type | Length | Nullable | Contents |
|---|---|---|---|---|
| NAME | VARCHAR | 128 | No | The unique identifier of the disk store. |
| MAXLOGSIZE | BIGINT | 10 | No | The maximum size, in megabytes, of a single oplog file in the disk store. |
| AUTOCOMPACT | CHAR | 6 | No | Specifies whether SnappyData automatically compacts log files in this disk store. |
| ALLOWFORCECOMPACTION | CHAR | 6 | No | Specifies whether the disk store permits online compaction of log files using the snappy utility. |
| COMPACTIONTHRESHOLD | INTEGER | 10 | No | The threshold after which an oplog file is eligible for compaction. Specified as a percentage value from 0–100. |
| TIMEINTERVAL | BIGINT | 10 | No | The maximum number of milliseconds that can elapse before SnappyData asynchronously flushes data to disk. |
| WRITEBUFFERSIZE | INTEGER | 10 | No | The size of the buffer SnappyData uses to store operations when writing to the disk store. |
| QUEUESIZE | INTEGER | 10 | No | The maximum number of row operations that SnappyData can asynchronously queue for writing to the disk store. |
| DIR_PATH_SIZE | VARCHAR | 32672 | No | The directory names that hold disk store oplog files, and the maximum size in megabytes that each directory can store. |
Example
snappy> select * from sys.SYSDISKSTORES;
NAME |MAXLOGSIZE |AUTOCOMPACT|ALLOWFORCECOMPACTION|COMPACTIONTHRESHOLD|TIMEINTERVAL |WRITEBUFFERSIZE|QUEUESIZE |DIR_PATH_SIZE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STORE2 |456 |true |false |50 |1000 |19292393 |17374 |/build-artifacts/scala-2.11/snappy/&
STORE1-SNAPPY-DELTA |50 |true |false |80 |223344 |19292393 |17374 |/build-artifacts/scala-2.11/snappy/&
STORE2-SNAPPY-DELTA |50 |true |false |50 |1000 |19292393 |17374 |/build-artifacts/scala-2.11/snappy/&
GFXD-DEFAULT-DISKSTORE |1024 |true |false |50 |1000 |32768 |0 |/build-artifacts/scala-2.11/snappy/&
GFXD-DD-DISKSTORE |10 |true |false |50 |1000 |32768 |0 |/build-artifacts/scala-2.11/snappy/&
SNAPPY-INTERNAL-DELTA |50 |true |false |50 |1000 |32768 |0 |/build-artifacts/scala-2.11/snappy/&
STORE1 |1024 |true |false |80 |223344 |19292393 |17374 |/build-artifacts/scala-2.11/snappy/&
7 rows selected
snappy> select * from SYS.SYSDISKSTORES where NAME = 'STORE1';
NAME |MAXLOGSIZE |AUTOCOMPACT|ALLOWFORCECOMPACTION|COMPACTIONTHRESHOLD|TIMEINTERVAL |WRITEBUFFERSIZE|QUEUESIZE |DIR_PATH_SIZE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STORE1 |1024 |true |false |80 |223344 |19292393 |17374 |/build-artifacts/scala-2.11/snappy/&
1 row selected
snappy> select * from sys.sysdiskstores where DIR_PATH_SIZE like '%mytest%';
NAME |MAXLOGSIZE |AUTOCOMPACT|ALLOWFORCECOMPACTION|COMPACTIONTHRESHOLD|TIMEINTERVAL |WRITEBUFFERSIZE|QUEUESIZE |DIR_PATH_SIZE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TEST |1024 |true |false |50 |1000 |32768 |0 |build-artifacts/scala-2.11/snappy/work/localhost-server-1/mytest
TEST-SNAPPY-DELTA|50 |true |false |50 |1000 |32768 |0 |build-artifacts/scala-2.11/snappy/work/localhost-server-1/mytest/snappy-internal-delta
2 rows selected
Related Topics