OPTIMIZE tables in galera cluster
Updated at by ospiComment out wsrep_provider in /etc/my.cnf
, add skip-networking
to prevent clients from connecting and restart MariaDB.
# wsrep_provider=/usr/lib64/galera/libgalera_smm.so
skip-networking
Default behaviour for mysqlcheck
and OPTIMIZE TABLE
is to write the statement to binlog. PIT recovery might be more fun with those included, but I rather not have them. So either
# mysqlcheck -o --skip-write-binlog woofwoof muchdata
or
MariaDB [woofwoof]> OPTIMIZE NO_WRITE_TO_BINLOG TABLE muchdata;
Revert changes to /etc/my.cnf
and restart MariaDB.