cronjob to repair database each hour?

[nintendo]

Can a hack be made to do a cronjob each hour to repair the database?

[nexialys]

each hour would make your database to crash ...

but you can try this one: https://vborg.vbsupport.ru/showthread.php?t=67711

this is for optimization, but you can change the word optimize to repair, and that's it.

[nintendo]

And how would doing it just once an hour cause the database to crash?? I've done it five or six times in a row in the day using admincp/repair.php and it's never crashed, it just takes more than one optimizing before everything has been repaired. (Blame PHP v4.2.2.)

[nexialys]

it may crash the database if you have a lot of users, that's all... if you start optimizing or repair when you have 250 users hitting the board at the same time, you have an overhead of requests... if you do it too often, your system will start looping caches, and will crash after some unanswered requests...

anyway... you do that when you are not in control of your server usually...