MySQL Files
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.
https://mariadb.com/kb/en/innodb-file-format/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)
ulimit -n
cat /usr/lib/systemd/system/mysqld.service | grep LimitNOFILE | uniq
show variables like 'open_files_limit'
Check
SHOW TABLE STATUS
Bibliography & References
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-space.html
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_data_file_pathhttps://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_file_per_tablehttps://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_page_sizehttps://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_segment_reserve_factor
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html
https://dev.mysql.com/doc/refman/8.0/en/glossary.html#glos_pagehttps://dev.mysql.com/doc/refman/8.0/en/glossary.html#glos_extenthttps://dev.mysql.com/doc/refman/8.0/en/glossary.html#glos_segmenthttps://dev.mysql.com/doc/refman/8.0/en/glossary.html#glos_general_tablespace