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

Bug #320453 reported by Baron Schwartz
2
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Triaged
Wishlist
Unassigned
Percona patches
Invalid
Undecided
Unassigned

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

Revision history for this message
Evgeniy Stepchenko (evgeny-stepchenko) wrote :
Changed in percona-patches:
status: New → Invalid
Changed in percona-patches:
status: Invalid → New
Revision history for this message
Stewart Smith (stewart) wrote :

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

Changed in percona-server:
status: New → Triaged
importance: Undecided → Wishlist
Changed in percona-patches:
status: New → Invalid
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

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.

summary: - FR: allow to specify InnoDB page fill factor
+ FR: allow to specify per-table/per-index InnoDB page fill factor
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers