[MariaDB] Kje se nahaja nastavitev za "innodb_file_per_table"?

Dobro jutro...

Imam sledeč sistem: Debian + MariaDB.

Če poženem ukaz:

SHOW VARIABLES LIKE 'innodb_file_per_table';

Dobim rezultat:

Variable_name        |Value|
---------------------|-----|
innodb_file_per_table|ON   |

Zanima me, kako naj najdem, kje je ta nastavitev shranjena?

Čisto iz firbca me zanima, da vem, če bi potreboval to spremenit na OFF, kje bi to naredil.

Spodnji ukaz:

grep -rnw /etc/mysql/ -e "innodb_file_per_table"

Mi ne verne nobenih rezultatov.

Skratka, ne najdem kje se to nastavi.

Še nekaj povezav:
https://dba.stackexchange.com/questions...
https://dev.mysql.com/doc/refman/8.0/en...
https://dba.stackexchange.com/questions...

Ni, ker bi pol grep ukaz moral to najti... Oz. /etc/my.cnf ne obstaja... ker je Debian, in ne BSD...?

Tole je v /etc/mysql/:

drwxr-xr-x 2 root root 4096 Mar 20 19:41 conf.d
-rw------- 1 root root  285 Jul 24  2020 debian.cnf
-rwxr-xr-x 1 root root 1731 Feb 19 10:41 debian-start
-rw-r--r-- 1 root root 1126 Aug  7  2020 mariadb.cnf
drwxr-xr-x 3 root root 4096 Mar 20 19:43 mariadb.conf.d
lrwxrwxrwx 1 root root   11 Feb 19 10:44 my.cnf -> mariadb.cnf
-rw-r--r-- 1 root root  839 Aug  3  2016 my.cnf.fallback

Tole je v /etc/mysql/mariadb.cnf:

# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 0. "/etc/mysql/my.cnf" symlinks to this file, reason why all the rest is read.
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# If you are new to MariaDB, check out https://mariadb.com/kb/en/basic-mariadb-articles/

#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]
# Port or socket location where to connect
# port = 3306
socket = /run/mysqld/mysqld.sock

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/

V conf.d in mariadb.conf.d so fajli, a v nobenem nisem našel innodb_file_per_table.

Mysql ima stotine nekih nastavitev, ki so povečini ok na default in jih zato sploh ni v config fajlih. Če jih želiš imeti tam, jih moraš vnesti sam. Ta, ki jo iščeš, je bila aktualna nekje pred 17 leti, ker so prve izdaje z innodb podporo pisale podatke v en sam file, ki je zato samo rastel in če si ga hotel zmanjšati, si moral narediti dump/restore. Takoj ko so podprli file_per_table opcijo, smo jo začeli uporabljati in sčasoma je postala privzeta. Zato ti danes ni več treba skrbeti zanjo.

Evo, da dodam. Drži.

nano /etc/mysql/mariadb.conf.d/50-server.cnf

[mysqld]
innodb_file_per_table = OFF


To je to.