Forum » Programiranje » [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:
Dobim rezultat:
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:
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...
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
fatal: This program requires a screen size of at least 80 columns by 24 lines
Please resize your window
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/:
Tole je v /etc/mysql/mariadb.cnf:
V conf.d in mariadb.conf.d so fajli, a v nobenem nisem našel innodb_file_per_table.
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
fatal: This program requires a screen size of at least 80 columns by 24 lines
Please resize your window
Zgodovina sprememb…
- spremenilo: HotBurek ()
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.
Č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
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.
nano /etc/mysql/mariadb.conf.d/50-server.cnf
[mysqld]
innodb_file_per_table = OFF
To je to.
root@debian:/# iptraf-ng
fatal: This program requires a screen size of at least 80 columns by 24 lines
Please resize your window
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 ...
Tema | Ogledi | Zadnje sporočilo | |
---|---|---|---|
Tema | Ogledi | Zadnje sporočilo | |
» | problem pri sprembi root gesla v MySQL v UbuntuOddelek: Pomoč in nasveti | 1274 (854) | killa bee |
» | MySQL problemOddelek: Omrežja in internet | 1394 (1341) | trnvpeti |
» | MySQL in czsOddelek: Izdelava spletišč | 3594 (2684) | krho |
» | mysql linux problemOddelek: Omrežja in internet | 1459 (1312) | Trubadur |
» | Linux sistem za podjetjeOddelek: Operacijski sistemi | 2597 (2161) | BigWhale |