Search code examples
mysqlinnodb

MySql 5.6: Ignores innodb_page_size setting in my.ini

So I tried to increase the innodb_page_size to 32k, by setting this value in my.ini:

innodb_page_size=32k

I then stopped the MySql service, and restarted it. The service in Win looks like this:

"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56

And I edited the correct file, and it's saved:

enter image description here

but when I look at the variable in HeidiSql, I see the standard value of 16k:

enter image description here

I'm not sure what I am doing wrong.

Solution

  • https://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_page_size says:

    You can specify page size using the values 16k (the default), 8k, or 4k. Alternatively, you can specify page size in bytes (4096, 8192, 16384).

    This means 32k is not supported in MySQL 5.6.

    innodb_page_size can only be configured prior to initializing the MySQL instance and cannot be changed afterward.

    This means you can't change the page size, without dropping all InnoDB tablespaces.