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
Next revision Both sides next 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]
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: 2024/03/23 04:33 by 101.44.249.184