User Tools

Site Tools



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 [2021/05/14 04:57] old revision restored (2021/05/08 01:04)
mysql_mariadb_galera:repair_and_optimization [2021/05/14 06:04] (current) old revision restored (2021/02/15 04:56)
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: 2021/05/14 06:04 by