Can a page size be changed in InnoDB?
Any help is appreciated! innodb_page_size can only be configured prior to initializing the MySQL instance and cannot be changed afterward. If no value is specified, the instance is initialized using the default page size. See Section 14.6.1, “InnoDB Startup Configuration”.
How to create new instance of InnoDB in MySQL?
If you want to create a MySQL Instance with a new size for innodb_page_size you must setup a new datadir with no data (but do not start mysqld) set the innodb_page_size to 32768 in the my.ini for that new instance start mysqld against that new my.ini and new datadir mysqldump the data out of the old instance load the mysqldump into the new instance
How big is the temporary table file in InnoDB?
By default, InnoDB creates a single auto-extending temporary tablespace data file named ibtmp1 that is slightly larger than 12MB in the innodb_data_home_dir directory. The default temporary tablespace data file configuration can be modified at startup using the innodb_temp_data_file_path configuration option.
What is the increment size of the InnoDB variable?
The innodb_autoextend_increment variable controls the increment size. To specify a maximum size for an auto-extending data file, use the max attribute following the autoextend attribute.
What’s the default value for the InnoDB plugin?
The default value is NULL, representing the MySQL plugin directory. You should not need to modify this parameter unless specifying a memcached plugin for a different storage engine that is located outside of the MySQL plugin directory. For more information, see Section 14.20.3, “Setting Up the InnoDB memcached Plugin” .
Why is MySQL 14.14 InnoDB status file large?
The –innodb-status-file option is intended for temporary use, as SHOW ENGINE INNODB STATUS output generation can affect performance, and the innodb_status. pid file can become quite large over time. For related information, see Section 14.17.2, “Enabling InnoDB Monitors” .