Menu
How do you specify the Fill Factor when creating an index in MySql?
240
The fill-factor option is provided for fine-tuning index data storage and performance. When an index is created or rebuilt, the fill-factor value determines the percentage of space on each leaf-level page to be filled with data, reserving the remainder on each page as free space for future growth.
Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In an SQL Server, the smallest unit is a page, which is made of Page with size 8K. Every page can store one or more rows based on the size of the row.
If your system static and just read only, a default Fill Factor of 100 (or 0) is ideal. As there is no insert, update or delete, having all the pages filled up makes sense.
The default SQL Server Index Fill factor value is 0(100%). With the 100% usage of the page could bring the recital issues while performing large sized table or data updates on the table as there will be no space left for data modification/s.
You don't.
http://dev.mysql.com/doc/refman/5.0/en/create-index.html
However, it is an 'accepted' feature request for version 6.x: http://bugs.mysql.com/bug.php?id=18178
So, don't hold your breath on seeing it any time soon.
87
Assuming that you are using InnoDB, it seems like this is only supported at database level, not index level.
The setting is called innodb_fill_factor and defaults to 100 see
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_fill_factor for more details.
23
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
