Memsql columnar on Disk storage != reported by studio ( 1.6TB vs 40GB)


#1

Hey all,

I have 3 columnar tables with 60M rows each, 3 fields which are var char, one datetime and one JSON.
The compression ratio for the JSON is 97% and the overall reported disk storage by memsql studio of all 3 tables is 25GB.

Last night the disk went out of storage with 1TB in use, by the leaf/data/blob folder.
Logs and anything else is < 20GB.

Any idea?

Ziv

Update: Issue currently solved by running a snapshot on the database.
Update 2: I’m using the latest beta 7 and issue should be resolved in the release.


#2

Glad you could get this resolved – and thanks for the final update!

Solution by @zmeidav:

Update: Issue currently solved by running a snapshot on the database.
Update 2: I’m using the latest beta 7 and issue should be resolved in the release.