Comments - what is the difference between MariaDB and Oracle?

9 years, 10 months ago Hartmut Holzgraefe

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 ...

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.