Configuration

innodb_data_file_path

TODO

 innodb_file_per_table

TODO

innodb_file_format

• The innodb_file_format configuration parameter is deprecated from MySQL 5.7 (MariaDB 10.2.2).

• The default file format for MySQL 5.7 and later is Barracuda.

show variables like 'innodb_file_format%'

InnoDB might use new file formats in the future. Each format will have an identifier from 0 to 25, and a name. The names have already been decided, and are animal names listed in an alphabetical order: Antelope, Barracuda, Cheetah, Dragon, Elk, Fox, Gazelle, Hornet, Impala, Jaguar, Kangaroo, Leopard, Moose, Nautilus, Ocelot, Porpoise, Quail, Rabbit, Shark, Tiger, Urchin, Viper, Whale, Xenops, Yak and Zebra.

Antelope

Supports the COMPACT and REDUNDANT row formats. (innodb_default_row_format)

Barracuda

Supports the COMPACT, REDUNDANT, DYNAMIC and COMPRESSED row formats.

innodb_page_size

TODO

innodb_segment_reserve_factor

TODO

open_files_limit

On Linux systems using systemd, the value cannot be set greater than LimitNOFile (this is DefaultLimitNOFILE, if LimitNOFile is not set); otherwise, on Linux, the value of open_files_limit cannot exceed ulimit -n. (1)

Check

SHOW TABLE STATUS

Bibliography & References