percona-discussion team mailing list archive

[Xaprb <baron@xxxxxxxxx>]

Public bug reported:

As far as I know currently InnoDB splits a page when it is 15/16 full.
It would be good to be able to control this.  Two things I can think of:

1) make it a server variable
2) add it to the data dictionary so each table and index can be specified to have its own fill factor, perhaps passed in a comment or an extension to the syntax of CREATE TABLE

** Affects: percona-patches
     Importance: Undecided
         Status: New

-- 
FR: allow to specify InnoDB page fill factor
https://bugs.launchpad.net/bugs/320453
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona patches.

Status in Patches for MySQL by Percona: New

Bug description:
As far as I know currently InnoDB splits a page when it is 15/16 full.  It would be good to be able to control this.  Two things I can think of:

1) make it a server variable
2) add it to the data dictionary so each table and index can be specified to have its own fill factor, perhaps passed in a comment or an extension to the syntax of CREATE TABLE