[mythtv-users] Slow MySQL query after delete
David Brodbeck
gull at gull.us
Wed Sep 5 16:46:26 UTC 2007
On Sep 5, 2007, at 1:22 AM, David Rees wrote:
> On 9/4/07, David Brodbeck <gull at gull.us> wrote:
>> It's been a long time since I ran a Postgres database, but I
>> recall having
>> to run a 'vacuum' script on it on a regular basis to keep it running
>> properly. So, probably six of one, half a dozen of the other. I
>> can run
>> VACUUM, or I can run OPTIMIZE TABLE. I don't really care which it
>> is.
>
> No longer needed (most of the time) on recent versions of Postgres if
> you set up the autovacuum daemon. It does it automatically in the
> background for you.
So it's still there, it's just hidden. I guess if MySQL (or MythTV)
quietly ran an OPTIMIZE TABLE once a week, instead of my scheduling
it in cron, people would stop complaining that MySQL is a "toy"
database -- even though the behavior would be exactly the same. ;)
More information about the mythtv-users
mailing list