InnoDB System Variables SET_VAR  Hint Applies No Type String Default Value ibdata1:12M:autoextend 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. 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” . 3235 Command-Line Format --innodb-ddl-log-crash-reset- debug[={OFF|ON}] System Variable innodb_ddl_log_crash_reset_debug Scope Global Dynamic Yes SET_VAR  Hint Applies No Command-Line Format --innodb-data-home-dir=dir_name System Variable innodb_data_home_dir Scope Global Dynamic No SET_VAR  Hint Applies No Type Directory name • innodb_data_home_dir • innodb_ddl_log_crash_reset_debug