Skip to content
This repository was archived by the owner on Apr 16, 2021. It is now read-only.

Configure MySQL to create an innodb file per table to prevent ibdata1 growing indefinitely #388

Closed
@GoogleCodeExporter

Description

@GoogleCodeExporter
http://stackoverflow.com/questions/3456159/how-to-shrink-purge-ibdata1-file-in-m
ysql

"But you can configure MySQL so that each table, including its indexes, is 
stored as a separate file. In that way ibdata1 will not grow as large. 
According to Bill Karwin's comment this is enabled by default as of version 5.6 
of MySQL.

It was a while ago I did this. However, to setup your server to use separate 
files for each table you need to change my.cnf in order to enable this:"

[mysqld]
innodb_file_per_table

Original issue reported on code.google.com by doug.bu...@gmail.com on 5 Sep 2013 at 6:31

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions