Difference between revisions of "Mariadbcheck"
Jump to navigation
Jump to search
Tags: Mobile web edit, Mobile edit |
|||
(22 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | + | {{lc}} | |
+ | <code>mariadbcheck</code> client performs [[table]] maintenance: It checks, [[repairs]], optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed and must be used wehn mysqld server is running. | ||
+ | <code>mariadbcheck</code> can checked [[InnoDB]] tables with CHECK TABLE, but not repaired them. | ||
https://mariadb.com/kb/en/mysqlcheck/ | https://mariadb.com/kb/en/mysqlcheck/ | ||
− | |||
+ | * <code>[[mariadbcheck --help]]</code> | ||
+ | * <code>[[mariadbcheck --all-databases]]</code> | ||
+ | * <code>[[mariadb-check --all-databases]]</code> | ||
+ | |||
+ | mariadbcheck | ||
+ | You forgot to give the arguments! Please see [[mariadbcheck --help]] for more information. | ||
+ | |||
+ | == Examples == | ||
+ | * <code>[[mariadbcheck]] --repair --all-databases</code> | ||
+ | |||
+ | <pre> | ||
+ | mariadbcheck --repair --all-databases | ||
+ | mysql.column_stats OK | ||
+ | mysql.columns_priv OK | ||
+ | mysql.db OK | ||
+ | mysql.event OK | ||
+ | mysql.func OK | ||
+ | mysql.gtid_slave_pos | ||
+ | note : The storage engine for the table doesn't support repair | ||
+ | mysql.help_category OK | ||
+ | mysql.help_keyword OK | ||
+ | mysql.help_relation OK | ||
+ | mysql.help_topic OK | ||
+ | mysql.host OK | ||
+ | mysql.index_stats OK | ||
+ | mysql.innodb_index_stats | ||
+ | note : The storage engine for the table doesn't support repair | ||
+ | mysql.innodb_table_stats | ||
+ | note : The storage engine for the table doesn't support repair | ||
+ | mysql.plugin OK | ||
+ | mysql.proc OK | ||
+ | mysql.procs_priv OK | ||
+ | mysql.proxies_priv OK | ||
+ | mysql.roles_mapping OK | ||
+ | mysql.servers OK | ||
+ | mysql.table_stats OK | ||
+ | mysql.tables_priv OK | ||
+ | mysql.time_zone OK | ||
+ | mysql.time_zone_leap_second OK | ||
+ | mysql.time_zone_name OK | ||
+ | mysql.time_zone_transition OK | ||
+ | mysql.time_zone_transition_type OK | ||
+ | mysql.user OK | ||
+ | .../... | ||
+ | </pre> | ||
+ | |||
+ | |||
+ | == Related terms == | ||
+ | * <code>[[error.log (MariaDB)]]</code> | ||
+ | * <code>[[systemctl status mariadb]]</code> | ||
+ | * <code>2020-05-05 5:56:00 139949468755712 [ERROR] mysqld: Table './xxxxx/[[searchindex]]' [[is marked as crashed and should be repaired]]</code> | ||
== See also == | == See also == | ||
+ | * {{mariadbcheck}} | ||
* {{MariaDB}} | * {{MariaDB}} | ||
+ | |||
+ | [[Category:MariaDB]] |
Latest revision as of 19:33, 15 December 2022
mariadbcheck
client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed and must be used wehn mysqld server is running.
mariadbcheck
can checked InnoDB tables with CHECK TABLE, but not repaired them.
https://mariadb.com/kb/en/mysqlcheck/
mariadbcheck You forgot to give the arguments! Please see mariadbcheck --help for more information.
Examples[edit]
mariadbcheck --repair --all-databases
mariadbcheck --repair --all-databases mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.gtid_slave_pos note : The storage engine for the table doesn't support repair mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.innodb_index_stats note : The storage engine for the table doesn't support repair mysql.innodb_table_stats note : The storage engine for the table doesn't support repair mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK .../...
Related terms[edit]
error.log (MariaDB)
systemctl status mariadb
2020-05-05 5:56:00 139949468755712 [ERROR] mysqld: Table './xxxxx/searchindex' is marked as crashed and should be repaired
See also[edit]
- mariadbcheck
- 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: