Are there any methods to calculate the size of a specific table in MemSQL?

Help
1

In MySQL, I use the method below to calculate the size of a specific table. It is shown as below:
mysql> use information_schema;
mysql> select table_name,table_rows,data_length+index_length,concat(round((data_length+index_length)/1024/1024,2),‘MB’) data from tables where table_schema=‘test’ and table_name=‘loan’;
±-----------±-----------±-------------------------±-------+
| table_name | table_rows | data_length+index_length | data |
±-----------±-----------±-------------------------±-------+
| loan | 5 | 16384 | 0.02MB |
±-----------±-----------±-------------------------±-------+
1 row in set (0.01 sec)

However, in memsql, this method doesn’t seems to work.

image
image.png1328×332 9.33 KB

So, how to deal with this thing?

2

MemSQL Studio has a way to get memory usage and disk usage per table from the Databases menu choice on the left:

image
image.png995×741 83 KB

3

This gives total memory (RAM) used per table:

select database_name, table_name, format(sum(memory_use),0) m 
from information_schema.table_statistics 
group by 1, 2;

This gives disk usage for columnstore tables:

select database_name, table_name, format(sum(compressed_size), 0) size
from information_schema.COLUMNAR_SEGMENTS
group by 1, 2;
4

Thanks so much for your prompt reply! I’ve tried just now, these two commands do work!!!
BTW, how could I get the installation package of MemSQL Studio?