Giulio Ferro wrote:
I'm having serious problems in a production environment with
slow queries.
S.o.: freebsd 7 stable amd64. DB: mysql5.1.28 compiled from source
The query that slows the db is:
SELECT messageblk, is_header FROM dbmail_messageblks WHERE
physmessage_id = xxxx ORDER BY messageblk_idnr
I've set up the db as instructed in the dbmail wiki. Everything was
smooth
for several days, than these queries have begun to slow the db server.
I know this probably depends on the db and not on dbmail, but any
suggestion
on how to solve this would be greatly appreciated...
Thanks.
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
try doing an explain select, but really that should be one of the
fastest queries in the thing.
how much ram do you have in the machine and how big is the database?
explain SELECT messageblk, is_header FROM dbmail_messageblks WHERE
physmessage_id = xxxx ORDER BY messageblk_idnr
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
