Re: Do you rebuild your indexes every night or do you leave them alone.

Thanks Mike!

I'm going on year 3 with a MariaDB server, dump the data for backup every night, never a problem.

Mike C

mbsoftwaresolutions@mbsoftwaresolutions.com wrote:

On 2016-11-09 15:20, Mike Copeland wrote:

...

Anyone have input on whether "checking the health of indexes...." is necessary or recommended in a MariaDB environment?

I use MariaDB. Never been an issue. Customers never complained about speed, and no problems with tables. And that's over a period of 10+ years (with MySQL being used prior to MariaDB).

--Mike

[excessive quoting removed by server]