-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Mar 7, 2008, at 7:27 PM, Dave Overton wrote:
> And DONE! 10 hours?
> 10?!?
>
> 2nd question. Why? What have I got wrong? Maia eats
all its mail
> just
> fine, the mailq sits at nothing all day long, Mysql is
happy most of
> the
> time, so what is taking so long to expire? And can it
be fixed?
> Mysql
> needs to be faster? Method of indexing
"stats" is just too slow?
> Do we
> really need stats? Help?
Most of those pauses are the database running the query to
find all
the appropriate rows, and then it starts up again as it
deletes one
message set at a time.
Finding all the messages to expire can be a big job - say,
one day's
worth of mail if you run it once a day.
That said, if it's abnormally slow, it's probably a memory
or index
issue. Check the mysql schema and make sure that your
indexes match -
especially on maia_mail and maia_mail_recipients.
next, assuming you are using innodb, check your innodb
paramaters -
you need to dedicate a lot of memory to it. search the
mailing list
for mysql innodb tuning, there's been some discussions very
recently.
David Morton
Maia Mailguard http://www.maiamailguard
.com
mortonda dgrmm.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (Darwin)
iD8DBQFH0f0kUy30ODPkzl0RAiM5AJ4i8buBi/SI9I/18qxFdC4OyHpcWwCg
gsa6
ffHdsROU/NBZsbmV8eJrhso=
=Y1lg
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
|
