content_image/856137.jpg content_image/856150.jpg content_image/856149.jpg
<img src='content_image/856137.jpg'>

Defines the name, size, and attributes of InnoDB  system tablespace data files. If you do not specify a value for innodb_data_file_path , the default behavior is to create a single auto-extending data file, slightly larger than 12MB, named ibdata1 . 

The full syntax for a data file specification includes the file name, file size, autoextend  attribute, and max  attribute: 

file_name : file_size [:autoextend[:max: max_file_size ]] 

File sizes are specified in kilobytes, megabytes, or gigabytes by appending K , M  or G  to the size value. If specifying the data file size in kilobytes, do so in multiples of 1024. Otherwise, KB values are rounded to nearest megabyte (MB) boundary. The sum of file sizes must be, at a minimum, slightly larger than 12MB. 

For additional configuration information, see System Tablespace Data File Configuration. For resizing instructions, see Resizing the System Tablespace. 

• innodb_data_home_dir 

<img src='content_image/856150.jpg'>

The common part of the directory path for InnoDB  system tablespace data files. The default value is the MySQL data  directory. The setting is concatenated with the innodb_data_file_path  setting, unless that setting is defined with an absolute path. 

A trailing slash is required when specifying a value for innodb_data_home_dir . For example: 

[mysqld] innodb_data_home_dir = /path/to/myibdata/ 

This setting does not affect the location of file-per-table tablespaces. 

For related information, see Section 15.8.1, “InnoDB Startup Configuration” . 

• innodb_ddl_log_crash_reset_debug 

<img src='content_image/856149.jpg'>

