Hall of Fame

[dtiberio]

I had an issue where searches did not return results. the database had crashed. I ran a repair command on the database. however , you should do it nightly as a cron, or whenever you get an error that the database has crashed.

these are the 4 commands you execute:
"repair", "check", "analyze", "optimize"

so you enter:
repair table vibe_videos;
check table vibe_videos;
analyze table vibe_videos;
optimize table vibe_videos;

and you do that for every table and it fixes everything. if there is nothing wrong, it skips the table. it should be run nightly, even if you don't detect a problem.

[PHPVibe A.]

Adding an check in the admin like smf maintainance it's on the list of "to do"s.

[dtiberio]

it should be automated, it should run every night without the admin

in fact, you should also run it at any time you suspect that a table has crashed, so the site is usable again immediately. all of my tables on my live web server are read-only so they will not crash because the data never changes, so I don't have that problem, and I don't know the way to detect it.