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 revisionPrevious revision
Next revision
Previous revision
mysql_mariadb_galera:repair_and_optimization [2026/04/02 15:43] – old revision restored (2025/02/16 12:40) 114.119.148.233mysql_mariadb_galera:repair_and_optimization [2026/04/08 17:48] (current) – old revision restored (2025/06/20 18:34) 57.141.20.55
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.1775144613.txt.gz · Last modified: by 114.119.148.233