Site Tools


New release candidate 3 available: 2020-06-09 "Hogfather". upgrade now! [51.2] (what's this?)
New release candidate 2 available: 2020-06-01 "Hogfather". upgrade now! [51.1] (what's this?)
New release candidate available: 2020-06-01 "Hogfather". upgrade now! [51] (what's this?)
Hotfix release available: 2018-04-22c "Greebo". upgrade now! [50.3] (what's this?)
mysql_mariadb_galera:repair_and_optimization

Differences

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

Link to this comparison view

mysql_mariadb_galera:repair_and_optimization [2020/02/24 11:16]
127.0.0.1 external edit
mysql_mariadb_galera:repair_and_optimization [2020/06/09 10:45] (current)
46.30.112.131 [Repair and Optimization]
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: 2020/06/09 10:45 by 46.30.112.131