Differences

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

--- mysql_mariadb_galera:repair_and_optimization [2025/07/31 16:53]
57.141.0.11 old revision restored (2025/06/14 20:57)
+++ mysql_mariadb_galera:repair_and_optimization [2025/07/31 18:56] (current)
57.141.0.14 old revision restored (2025/06/05 15:04)
@@ 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 ======

Chucks notes and stuff