[Tutorial] How to automatically optimize all database tables via a task

[MrAnderson]

This task doesn't optimize DB with 1.6.6.
DB size before and after this taks the same.
If after task I manually optimize my DB via ACP it became smaller.

Maybe there is nothing to optimize at the moment ?

[Maj]

Maybe there is nothing to optimize at the moment ?

No.
1. I run that task manually. Result - DB size doesn't changes.
2. Immediately after that I optimize DB manually via MyBB ACP option. Rusult - DB size becomes smaller.

Check it yourself.

[jard0n5]

I just did an optimize on my site and DB size went from 1.75GB to 1.50GB. Pretty good.

[Maj]

Perhaps you optimize the database via standard mybb "optimize option" and not by the task. Or you don't have latest mybb version.

I have tested this task on 2 forums. And I must say... it doesn't works.

DB size before optimization - 2.7 MB
DB size after this task - 2.7 MB
DB size after standard MyBB optimize option - 2.3 MB

So this task does not do anything.

[Euan T]

@Maj: Do you have any plugins installed that add new tables? This task only optimizes the core MyBB tables so the overhead may be coming from non-standard ones.

[Maj]

I don't have any plugins installed that add any tables. I suggest to check it with latest MyBB version and describe results here.

[pavemen]

6. Enter "*" in Time: Minutes, Time: Hours and Time: Days of Month. (as it should be by default).

7. Select "Sunday" from Time: Weekdays.

8. Select "Every Month" from Time: Months.

isn't this making it run every minute of every hour every sunday of every month?

Wouldn't it be better to specify the minutes and hours so it only runs once a week? Like 14 for minutes and 5 for hours so that it runs at 6:15am on Sundays?

[pinguy]

Thanks for this.