Post Profile

MySQL 8.0 General Tablespaces: File per Database (and no FRM files)

In this blog post, we’ll look at MySQL 8.0 general tablespaces. Introduction MySQL 8.0 (the DMR version is available now) has two great features (among others): The new data dictionary completely removed .frm files, which is great The ability to create a tablespace and assign a group of tables to it (originally introduced in 5.7). […]
read more


Related Posts

MySQL 5.6 Transportable Tablespaces best practices

Programming / Database Development : MySQL Performance Blog

In MySQL 5.6 Oracle introduced a Transportable Tablespace feature (copying tablespaces to another server) and Percona Server adopted it for partial backups which means you can now take individual database or table backups and your d...

Recovering CREATE TABLE statement from .frm file

Programming / Database Development : MySQL Performance Blog

So lets say you have.frm file for the table and you need to recover CREATE TABLE statement for this table. In particular when we do Innodb Recovery we often get.frm files and some mess in the Innodb tablespace from which we have to ...

Examining the TokuDB MySQL storage engine file structure

Programming / Database Development : MySQL Performance Blog

As we know different storage engines in MySQL have different file structures. Every table in MySQL 5.6 must have a.frm file in the database directory matching the table name. But where the rest of the data resides depends on the sto...

How to recover table structure from .frm files with MySQL Utilities

Programming / Database Development : MySQL Performance Blog

Table structures are stored in.frm files and in the InnoDB Data Dictionary. Sometimes, usually in data recovery issues, we need to recover those structures to be able to find the lost data or just to recreate the tables. There are d...

Showing the hidden tables in MySQL 8 data dictionary

Programming / Database Development : The Data Charmer

The freshly released MySQL 8.0 includes a data dictionary, which makes MySQL much more reliable. Thanks to this features, we don't have any '.frm' files, and querying the information_schema is 30x to 100x faster than previous versio...


Copyright © 2016 Regator, LLC