Hi all,
I have some issues with my database. Everytime there is some database
action it is extremely slow and the mysql server is putting lines in the
"slow" log file.
Here is some from the log file:
# Query_time: 56 Lock_time: 0 Rows_sent: 447 Rows_examined: 9444548
SELECT message_idnr,headername,headervalue FROM dbmail_headervalue v
JOIN dbmail_messages m ON v.physmessage_id=m.physmessage_id JOIN
dbmail_mailboxes b ON m.mailbox_idnr=b.mailbox_idnr JOIN
dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr = 2700
AND message_idnr BETWEEN 15651805 AND 16208824 AND lower(headername) IN
('date','to','cc','from','subject','x-priority','importance','priority','content-type');
# Time: 070220 10:10:13
# [EMAIL PROTECTED]: dbmail[dbmail] @ [10.0.0.10]
# Query_time: 55 Lock_time: 0 Rows_sent: 447 Rows_examined: 9444581
SELECT message_idnr,headername,headervalue FROM dbmail_headervalue v
JOIN dbmail_messages m ON v.physmessage_id=m.physmessage_id JOIN
dbmail_mailboxes b ON m.mailbox_idnr=b.mailbox_idnr JOIN
dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr = 2700
AND message_idnr BETWEEN 15651805 AND 16208824 AND lower(headername) IN
('date','to','cc','from','subject','x-priority','importance','priority','content-type');
# Time: 070220 10:16:00
# [EMAIL PROTECTED]: dbmail[dbmail] @ [10.0.0.10]
# Query_time: 55 Lock_time: 0 Rows_sent: 2825 Rows_examined: 9444701
SELECT message_idnr,headername,headervalue FROM dbmail_headervalue v
JOIN dbmail_messages m ON v.physmessage_id=m.physmessage_id JOIN
dbmail_mailboxes b ON m.mailbox_idnr=b.mailbox_idnr JOIN
dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr = 2700
AND message_idnr BETWEEN 15651805 AND 16210400 AND lower(headername) IN
('date','to','cc','from','subject','x-priority','importance','priority','content-type');
I am not sure if the "Rows_examined" section is ok. But allmost 9,5
million rows looks very mucht to me. When i take a look in the mailq I
found the following messages:
87B3F1059C 3080 Mon Feb 19 20:35:45 [EMAIL PROTECTED]
(delivery temporarily suspended: lost connection with
10.0.0.10[10.0.0.10] while sending end of data -- message may be sent
more than once)
[EMAIL PROTECTED]
F3B76105A9 1752 Mon Feb 19 22:57:28 [EMAIL PROTECTED]
(delivery temporarily suspended: lost connection with
10.0.0.10[10.0.0.10] while sending end of data -- message may be sent
more than once)
maikel@@example.com
7699C1059A 7453 Mon Feb 19 20:30:02 [EMAIL PROTECTED]
(delivery temporarily suspended: lost connection with
10.0.0.10[10.0.0.10] while sending end of data -- message may be sent
more than once)
[EMAIL PROTECTED]
79694105AE 3181 Tue Feb 20 09:16:14 [EMAIL PROTECTED]
(lost connection with 10.0.0.10[10.0.0.10] while sending end of data --
message may be sent more than once)
[EMAIL PROTECTED]
I hope someone have a clue.
Thx in advance.
Maikel
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
