Ik tried that and can't find any improvements. Jorge Bastos wrote: > [mysqld] > > sorry > > ----- Original Message ----- From: "Jorge Bastos" > <[EMAIL PROTECTED]> > To: "DBMail mailinglist" <[email protected]> > Sent: Tuesday, February 20, 2007 11:23 AM > Subject: Re: [Dbmail] Very slow database > > > Hum... one thing that may help for start, in my.ini in the [mysql] > secction > put > skip-name-resolve > > and restart mysql and see if there's any improvement > > > ----- Original Message ----- From: ""Maikel Dollé [Hebbizz BV]"" > <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, February 20, 2007 9:30 AM > Subject: [Dbmail] Very slow database > > >> 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 >> > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
