Hi! I noticed that mysql 'show full processlist' frequently show next request status:
Copying to tmp table | SELECT distinct(mbx.name), mbx.mailbox_idnr, mbx.owner_idnr FROM dbmail_mailboxes mbx LEFT JOIN dbmail_acl acl ON mbx.mailbox_idnr = acl.mailbox_id LEFT JOIN dbmail_users usr ON acl.user_id = usr.user_idnr WHERE ((mbx.owner_idnr = 33984) OR (acl.user_id = 33984 AND acl.lookup_flag = 1) OR (usr.userid = 'anyone' AND acl.lookup_flag = 1)) We want create mass mail system on DBMail and now we serve est. 18 000 IMAP4/POP3 account via Cyrus. But I think than 'copying to tmp table' requests make velocity too badly. We will migrate in some next week to DBMail... How to disable too same requests? -- Ilyas _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
