InnoDB Startup Configuration •Memory Configuration •Page Size Configuration •Session Temporary Tablespace Configuration •Global Temporary Tablespace Configuration •Undo Tablespace Configuration •Redo Log File Configuration Specifying Options in a MySQL Option File Because MySQL uses data file, log file, and page size settings to initialize  InnoDB , it is recommended that you define these settings in an option file that MySQL reads at startup, prior to initializing  InnoDB . Normally,  InnoDB  is initialized when the MySQL server is started for the first time. You can place  InnoDB  options in the  [mysqld]  group of any option file that your server reads when it starts. The locations of MySQL option files are described in Section 4.2.2.2, “Using Option Files” . To make sure that  mysqld  reads options only from a specific file (and  mysqld-auto.cnf ), use the  -- defaults-file  option as the first option on the command line when starting the server: mysqld --defaults-file= path_to_option_file Viewing InnoDB Initialization Information To view  InnoDB  initialization information during startup, start  mysqld  from a command prompt, which prints initialization information to the console. For example, on Windows, if  mysqld  is located in  C:\Program Files\MySQL\MySQL Server 8.0\bin , start the MySQL server like this: On Unix-like systems,  mysqld  is located in the  bin  directory of your MySQL installation: If you do not send server output to the console, check the error log after startup to see the initialization information  InnoDB  printed during the startup process. For information about starting MySQL using other methods, see Section 2.10.5, “Starting and Stopping MySQL Automatically” . InnoDB  does not open all user tables and associated data files at startup. However, InnoDB  does check for the existence of tablespace files referenced in the data dictionary. If a tablespace file is not found,  InnoDB  logs an error and continues the startup sequence. Tablespace files referenced in the redo log may be opened during crash recovery for redo application. Review the following storage-related considerations before proceeding with your startup configuration. Note Important Storage Considerations shell>  bin/mysqld --user=mysql & C:\>  "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld" --console 3103