Difference between revisions of "MariaDB files"
Jump to navigation
Jump to search
Line 6: | Line 6: | ||
* <code>[[.MYD]]</code> | * <code>[[.MYD]]</code> | ||
* <code>[[.MYI]]</code> | * <code>[[.MYI]]</code> | ||
− | * <code>[[ | + | * <code>[[db.opt]]</code> |
[[file]] /var/lib/mysql/your_db_name/archive.frm | [[file]] /var/lib/mysql/your_db_name/archive.frm | ||
/var/lib/mysql/your_db_name/archive.frm: [[MySQL table definition file]] Version 10, type INNODB, MySQL version 100148 | /var/lib/mysql/your_db_name/archive.frm: [[MySQL table definition file]] Version 10, type INNODB, MySQL version 100148 | ||
Line 18: | Line 18: | ||
[[file]] /var/lib/mysql/your_db_name/searchindex.MYI | [[file]] /var/lib/mysql/your_db_name/searchindex.MYI | ||
/var/lib/mysql/your_db_name/searchindex.MYI: MySQL [[MyISAM]] index file Version 1, 3 key parts, 0 unique key parts, 3 keys, 24805 records, 1 deleted records | /var/lib/mysql/your_db_name/searchindex.MYI: MySQL [[MyISAM]] index file Version 1, 3 key parts, 0 unique key parts, 3 keys, 24805 records, 1 deleted records | ||
+ | |||
+ | [[file]] /var/lib/mysql/your_db_name/db.opt | ||
+ | /var/lib/mysql/your_db_name/db.opt: [[ASCII]] text | ||
Revision as of 18:26, 1 June 2022
/var/lib/mysql/your_db_name/
file /var/lib/mysql/your_db_name/archive.frm /var/lib/mysql/your_db_name/archive.frm: MySQL table definition file Version 10, type INNODB, MySQL version 100148
file /var/lib/mysql/your_db_name/file_name.ibd /var/lib/mysql/your_db_name/file_name.ibd: data
file /var/lib/mysql/your_db_name/searchindex.MYD /var/lib/mysql/your_db_name/searchindex.MYD: shared library
file /var/lib/mysql/your_db_name/searchindex.MYI /var/lib/mysql/your_db_name/searchindex.MYI: MySQL MyISAM index file Version 1, 3 key parts, 0 unique key parts, 3 keys, 24805 records, 1 deleted records
file /var/lib/mysql/your_db_name/db.opt /var/lib/mysql/your_db_name/db.opt: ASCII text
See also
- MariaDB:
mariadbcheck
,mariabackup
,mysqldump
, MyRocks,show (MariaDB)
MariaDB Changelog,50-server.cnf
, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.log, /var/log/mysql/mariadb-slow.log
, MariaDB files:.frm
,.ibd
,/etc/mysql/mariadb.conf.d/50-server.cnf
, replication, MariaDB slow queries,show databases;
, Aria, MyISAM, MariaDB SkySQL, binary log, 3306,/etc/mysql/
Advertising: