On Wed, 15 May 2013 17:47:25 +0300
Pavlo Lavrenenko <[email protected]> wrote:
> Oh, you should have a staging system for such changes to be tested first.
I have, but it's not really suitable for performance tests.
> Also I don't see see dbmail_messages.sortfield field in a schema I am
> using. Neighter do I see that field in dbmail-3.0.2 src/dbmail-mailbox.c.
>
> What version of dbmail do you use? Can you attach your mysql db schema?
3.0.2 + some fixes from master for roundcube sort ordering. And no, I don't
see dbmail_messages.sortfield either.
> Can you provide the output of: DESCRIBE ... query?
Yes, I was looking at that (mail client will break lines; some
reformatting needed):
+----+-------------+-------+--------+----------------------------------------+-------------------+---------+-------------------------------------+------+----------------------------------------------+
| id | select_type | table | type | possible_keys |
key | key_len | ref | rows |
Extra |
+----+-------------+-------+--------+----------------------------------------+-------------------+---------+-------------------------------------+------+----------------------------------------------+
| 1 | SIMPLE | m | range | mailbox_status |
mailbox_status | 9 | NULL | 2 |
Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | eq_ref | PRIMARY |
PRIMARY | 8 | dbmail.m.physmessage_id | 1 |
Using index |
| 1 | SIMPLE | n | const | PRIMARY,headername |
headername | 767 | const | 1 |
Using index |
| 1 | SIMPLE | m | ref | unique_seen_index,status_mailbox_index |
unique_seen_index | 8 | dbmail.m.physmessage_id | 1 |
Using index |
| 1 | SIMPLE | h | ref | PRIMARY,headername_id,headervalue_id |
PRIMARY | 16 | dbmail.m.physmessage_id,dbmail.n.id | 1 |
Using index |
| 1 | SIMPLE | v | eq_ref | PRIMARY |
PRIMARY | 8 | dbmail.h.headervalue_id | 1 |
|
+----+-------------+-------+--------+----------------------------------------+-------------------+---------+-------------------------------------+------+----------------------------------------------+
What doesn't look right is the "Using temporary; Using filesort" there at
the first line. While I know something about smtp and email, I'm not enough of
a dba to get the indexes right, so I ask for some help here. Thanks in advance
:)
--
Jure Pečar
http://jure.pecar.org
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
