Unlike most storage engines, MariaDB ColumnStore does not store its data files in the datadir. Instead these are stored in the Performance Modules in what appears to be a strange numbering system. In this post I will walk you through deciphering the number system.
If you are still using InfiniDB with MySQL, the system is exactly the same as outlined in this post, but the default path that the data is stored in will be a little different.
The default path for the data to be stored is
“dbRoot” is the DB root number selected when the ColumnStore
system was configured.
From here onwards we are looking at directories with three digits
ending in “.dir”. Every filename will be nested in similar to
Now, to understand this you first need to understand how ColumnStore’s storage works. …[Read more]