How to free disk space after deleting a table.

[Dhruv Paranjape]

So I have a table that has 10 million records. I deleted the table but the size of .Rocksdb was the same... I observed most of the space was occupied by .Bin files which are for wal. So would setting max_wal_size keep these in control... Also how do I free up the actual disk space.

[Yoshinori Matsunobu]

Could you elaborate which types of files are occupying space? MyRocks has three major large file types
-- 1. sst (*.sst, under $datadir/.rocksdb), 2. WAL (*.log, under rocksdb_wal_dir), 3. Binary logs (under log-bin).
DROP TABLE triggers compactions and eventually delete sst files. WAL size is controlled by rocksdb_max_total_wal_size.

- Yoshinori

--
You received this message because you are subscribed to the Google Groups "MyRocks - RocksDB storage engine for MySQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to myrocks-dev...@googlegroups.com.
To post to this group, send email to myroc...@googlegroups.com.
To view this discussion on the web visit https://urldefense.proofpoint.com/v2/url?u=https-3A__groups.google.com_d_msgid_myrocks-2Ddev_50bbee7a-2Ddb86-2D4de8-2Dab64-2Da759d1e8447a-2540googlegroups.com&d=DwIFaQ&c=5VD0RTtNlTh3ycd41b3MUw&r=h7I09O8mW25YOy83cdKu0g&m=WEpbjrBHg4Cg-5tL2w3_0XyqIP5q2WYe7hgP6zouf60&s=0stO1Z3TvpalXoIzOSrVG2J15I0dan_W5LBfYoUbPUM&e= .
For more options, visit https://urldefense.proofpoint.com/v2/url?u=https-3A__groups.google.com_d_optout&d=DwIFaQ&c=5VD0RTtNlTh3ycd41b3MUw&r=h7I09O8mW25YOy83cdKu0g&m=WEpbjrBHg4Cg-5tL2w3_0XyqIP5q2WYe7hgP6zouf60&s=NCyic0hfXdsbvB42y0qAE-xU_OWHIQTsxh15QB9AfyM&e= .

[Dhruv Paranjape]

I don't have access to the machine now... Will write the files tomorrow.

But I did see a hell of a lot of *.bin files

I am guessing it's binary logs ? What exactly is that used for ? Can I disable it ?

[Yoshinori Matsunobu]

I assume they're binary logs. They're used for replication and point in time recovery.
See MySQL reference manual about binary logs in general, and how to purge older binary logs.
https://dev.mysql.com/doc/refman/5.7/en/purge-binary-logs.html

- Yoshinori

-----Original Message-----
From: myroc...@googlegroups.com [mailto:myroc...@googlegroups.com] On Behalf Of Dhruv Paranjape
Sent: Tuesday, March 21, 2017 9:44 AM
To: MyRocks - RocksDB storage engine for MySQL <myroc...@googlegroups.com>

--
You received this message because you are subscribed to the Google Groups "MyRocks - RocksDB storage engine for MySQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to myrocks-dev...@googlegroups.com.
To post to this group, send email to myroc...@googlegroups.com.

To view this discussion on the web visit https://urldefense.proofpoint.com/v2/url?u=https-3A__groups.google.com_d_msgid_myrocks-2Ddev_62dea14d-2D5394-2D404f-2D8f8d-2D3e969afb9f51-2540googlegroups.com&d=DwIBaQ&c=5VD0RTtNlTh3ycd41b3MUw&r=h7I09O8mW25YOy83cdKu0g&m=orSkl9azlIMUkr9jJHarBnrDqq4rvDA8DhhdLi5t43M&s=Hhb6_MUu2EPxJ9L0m7wJFdXuT7Oi76ZyxTH7yMGHg7U&e= .
For more options, visit https://urldefense.proofpoint.com/v2/url?u=https-3A__groups.google.com_d_optout&d=DwIBaQ&c=5VD0RTtNlTh3ycd41b3MUw&r=h7I09O8mW25YOy83cdKu0g&m=orSkl9azlIMUkr9jJHarBnrDqq4rvDA8DhhdLi5t43M&s=hW0_oZQ0aFzXIDbmT0AmpikdhUeI3_U-EArO7gAFpzE&e= .