CODEWITHSUNDEEP
mysqlindexingfillfactor
GateKiller
GateKiller

Reputation: 75929

MySql Index Fill Factor?

How do you specify the Fill Factor when creating an index in MySql?

Upvotes: 5

Views: 4002

Answers (2)

Nameless One
Nameless One

Reputation: 1646

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.

Upvotes: 1

Matt Rogish
Matt Rogish

Reputation: 24873

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.

Upvotes: 6

Related Questions