User Tools

Site Tools


mysql_mariadb_galera:repair_and_optimization

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
mysql_mariadb_galera:repair_and_optimization [2022/12/04 20:32]
192.99.101.79 old revision restored (2022/11/27 16:32)
mysql_mariadb_galera:repair_and_optimization [2022/12/04 20:32] (current)
192.99.101.79 old revision restored (2022/12/03 03:47)
Line 1: Line 1:
 +====== Finding Problems ======
 +
 +The easiest way I have found to find problem tables is by using the following command
 +
 +<code sql>mysqlcheck -u root -p --check --all-databases |grep -vE ' OK'</code>
 +
 +This will check all tables and the "grep" will get rid of all tables that are OK from the output. You are left with only errors.
 +
 ====== Repair and Optimization ====== ====== Repair and Optimization ======
  
mysql_mariadb_galera/repair_and_optimization.txt ยท Last modified: 2022/12/04 20:32 by 192.99.101.79