» »

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

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

HotBurek ::

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...
root@debian:/# iptraf-ng
fatal: This program requires a screen size of at least 80 columns by 24 lines
Please resize your window

misek ::

Morda /etc/my.cnf ?

HotBurek ::

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.
root@debian:/# iptraf-ng
fatal: This program requires a screen size of at least 80 columns by 24 lines
Please resize your window

Zgodovina sprememb…

  • spremenilo: HotBurek ()

misek ::

Potem pa pogrepaj cel folder /etc.

Ali pa tole: https://stackoverflow.com/questions/595...

Zgodovina sprememb…

  • spremenil: misek ()

pegasus ::

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.

HotBurek ::

Se pravi, da že bi želel dat na OFF (vse v en fajl), bi to vnesel nekam pod [mysqld].

Če pa želim na ON, sta pa dve opciji; da to ročno vnesem v config, ali pa da sploh ne vnesem. V obeh primerih bo na ON.
root@debian:/# iptraf-ng
fatal: This program requires a screen size of at least 80 columns by 24 lines
Please resize your window

Zgodovina sprememb…

  • spremenilo: HotBurek ()

HotBurek ::

Evo, da dodam. Drži.

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

[mysqld]
innodb_file_per_table = OFF


To je to. 8-)
root@debian:/# iptraf-ng
fatal: This program requires a screen size of at least 80 columns by 24 lines
Please resize your window

Zgodovina sprememb…

  • spremenilo: HotBurek ()


Vredno ogleda ...

TemaSporočilaOglediZadnje sporočilo
TemaSporočilaOglediZadnje sporočilo
»

problem pri sprembi root gesla v MySQL v Ubuntu

Oddelek: Pomoč in nasveti
231054 (634) killa bee
»

MySQL problem

Oddelek: Omrežja in internet
51189 (1136) trnvpeti
»

MySQL in czs

Oddelek: Izdelava spletišč
423283 (2373) krho
»

mysql linux problem

Oddelek: Omrežja in internet
141243 (1096) Trubadur
»

Linux sistem za podjetje

Oddelek: Operacijski sistemi
312153 (1717) BigWhale

Več podobnih tem