FR: allow to specify per-table/per-index InnoDB page fill factor

[Baron Schwartz]

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

[Evgeniy Stepchenko (evgeny-stepchenko)]

moved to the blueprint https://blueprints.launchpad.net/percona-patches/+spec/control-page-fill-factor

[Stewart Smith (stewart)]

I have moved to percona-server as percona-patches is long obsolete.

[Laurynas Biveinis (laurynas-biveinis)]

Upstream 5.7 has implemented:
- innodb_fill_factor system variable: https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_fill_factor
- per-table MERGE_THRESHOLD setting: https://dev.mysql.com/doc/refman/5.7/en/index-page-merge-threshold.html, which is not what this feature requests asks for, but somewhat related.

The only thing missing from this request is having per-table/per-index innodb_fill_factor, converting the bug report to track this remaining bit.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2292