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