My Oracle Support Banner

MySQL Server Variable: innodb_data_file_path; How to Size the Main (System) InnoDB Table Space; ibdata1? (Doc ID 1365199.1)

Last updated on FEBRUARY 26, 2020

Applies to:

MySQL Server - Version 4.0 and later
Information in this document applies to any platform.

Purpose

Understand the advantages of using more than one InnoDB data file when storing the data in the system tablespace and learn how to find a trade-off between the number and size of the data files.

Scope

Detailed general guidance for DBAs already familiar with the InnoDB storage engine seeking guidance on how to best configure the size and number of InnoDB data files when using the system tablespace for storing the data.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.