How MySQL stores data

• Databases are stored as directories.
• Tables are stored as files.
• Columns are stored in the files in dynamic length or fixed size format. In BDB tables the data is stored in pages.
• Memory-based tables are supported.
• Databases and tables can be symbolically linked from different disks.
• On Windows MySQL supports internal symbolic links to databases with .sym files.