what is the difference between MariaDB and Oracle?
I am new to this? I have just started to learn MariaDB and I am very impressed with MariaDB? I am just trying to understand something. I know that Oracle uses tablespaces to store their DATA. But what about MariaDB? what does MariaDB use to store DATA?
What is the purpose for the BLACKHOLE storage engine? when you are writing to blackhole nothing exists. So, what is the point of having it?
Any help is greatly appreciated,
Answer Answered by Hartmut Holzgraefe in this comment.
And on part #1: this depends on the storage engine used for a specific table.
MyISAM, MEMORY, ARCHIVE and CSV tables all use a "file(s) per table" approach and there is no concept of a table space at all. Tables are directly mapped into one or more files (e.g. a MyISAM table `test.t1` would have a pair of t1.MYD / t1.MYI index files in the 'test' database directory in the mysqld data_dir, a CSV table just a t1.CSV associated with it). InnoDB and ndb_cluster (in MySQL Cluster) tables on the other hand use a tablespace approach where there's no strict 1:1 mapping between files on disk and SQL level tables. InnoDB supports sort of a mixed mode though with "innodb-file-per-tabl", with a central table space for meta data, undo log entries (and a few other things) while actual table data resides in extra tablespace files that store data for just one specfic table each ...
