Bret Baptist ([EMAIL PROTECTED]) écrivait: > >I tried the MySQL indexing that is show here >https://mailman.fastxs.nl/pipermail/dbmail/2002-April/000435.html.
The link it's not working for me, can you give the exact modification to do in the indexing. I noticed the same thing with dbmail-imapd and a PHP Webmail, but not with Outlook, Netscape, Mozila. We have MySQL+InnoDB with a messageblks about 4.8Gb size on bi-proc 1.3Ghz pentium machine with 512Mb memory and UW-SCSI RAID 15Gb disk, there is a log of an IMAP request: -------------------------------------------------- Aug 15 20:10:43 groupware dbmail/imap4[6468]: SS_WaitAndProcess(): client @ socket 3 (IP: 127.0.0.1) accepted Aug 15 20:10:43 groupware dbmail/imap4[6468]: COMMAND: [00000000 CAPABILITY] Aug 15 20:10:43 groupware dbmail/imap4[6468]: COMMAND: [00000001 AUTHENTICATE LOGIN] Aug 15 20:10:43 groupware dbmail/imap4[6468]: IMAPD [PID 6468]: user (id 3, name [EMAIL PROTECTED]) login accepted @ 2002-08-15 20:10:43^M Aug 15 20:10:43 groupware dbmail/imap4[6468]: COMMAND: [00000002 CAPABILITY] Aug 15 20:10:43 groupware dbmail/imap4[6468]: COMMAND: [00000003 SELECT INBOX] Aug 15 20:10:44 groupware dbmail/imap4[6468]: COMMAND: [00000004 STATUS INBOX (MESSAGES RECENT UNSEEN UIDNEXT UIDVALIDITY)] Aug 15 20:10:44 groupware dbmail/imap4[6468]: COMMAND: [00000005 FETCH 1,2:21 (UID ENVELOPE BODY.PEEK[HEADER.FIELDS (Path Message-ID Newsgroups Followup-To References)] INTERNALDATE RFC822.SIZE FLAGS)] Aug 15 20:10:45 groupware dbmail/imap4[6468]: COMMAND: [00000006 FETCH 22,23:39 (UID ENVELOPE BODY.PEEK[HEADER.FIELDS (Path Message-ID Newsgroups Followup-To References)] INTERNALDATE RFC822.SIZE FLAGS)] Aug 15 20:10:46 groupware dbmail/imap4[6468]: COMMAND: [00000007 FETCH 39 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:46 groupware dbmail/imap4[6468]: COMMAND: [00000008 FETCH 39 BODY.PEEK [HEADER]] Aug 15 20:10:47 groupware dbmail/imap4[6468]: COMMAND: [00000009 FETCH 38 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:47 groupware dbmail/imap4[6468]: COMMAND: [0000000a FETCH 38 BODY.PEEK [HEADER]] Aug 15 20:10:47 groupware dbmail/imap4[6468]: COMMAND: [0000000b FETCH 37 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:47 groupware dbmail/imap4[6468]: COMMAND: [0000000c FETCH 37 BODY.PEEK [HEADER]] Aug 15 20:10:47 groupware dbmail/imap4[6468]: COMMAND: [0000000d FETCH 36 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:48 groupware dbmail/imap4[6468]: COMMAND: [0000000e FETCH 36 BODY.PEEK [HEADER]] Aug 15 20:10:48 groupware dbmail/imap4[6468]: COMMAND: [0000000f FETCH 35 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:48 groupware dbmail/imap4[6468]: COMMAND: [00000010 FETCH 35 BODY.PEEK [HEADER]] Aug 15 20:10:48 groupware dbmail/imap4[6468]: COMMAND: [00000011 FETCH 34 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:48 groupware dbmail/imap4[6468]: COMMAND: [00000012 FETCH 34 BODY.PEEK [HEADER]] Aug 15 20:10:48 groupware dbmail/imap4[6468]: COMMAND: [00000013 FETCH 33 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:49 groupware dbmail/imap4[6468]: COMMAND: [00000014 FETCH 33 BODY.PEEK [HEADER]] Aug 15 20:10:49 groupware dbmail/imap4[6468]: COMMAND: [00000015 FETCH 32 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:49 groupware dbmail/imap4[6468]: COMMAND: [00000016 FETCH 32 BODY.PEEK [HEADER]] Aug 15 20:10:49 groupware dbmail/imap4[6468]: COMMAND: [00000017 FETCH 31 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:49 groupware dbmail/imap4[6468]: COMMAND: [00000018 FETCH 31 BODY.PEEK [HEADER]] Aug 15 20:10:50 groupware dbmail/imap4[6468]: COMMAND: [00000019 FETCH 30 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:50 groupware dbmail/imap4[6468]: COMMAND: [0000001a FETCH 30 BODY.PEEK [HEADER]] Aug 15 20:10:50 groupware dbmail/imap4[6468]: COMMAND: [0000001b FETCH 29 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:50 groupware dbmail/imap4[6468]: COMMAND: [0000001c FETCH 29 BODY.PEEK [HEADER]] Aug 15 20:10:50 groupware dbmail/imap4[6468]: COMMAND: [0000001d FETCH 28 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:50 groupware dbmail/imap4[6468]: COMMAND: [0000001e FETCH 28 BODY.PEEK [HEADER]] Aug 15 20:10:51 groupware dbmail/imap4[6468]: COMMAND: [0000001f FETCH 27 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:51 groupware dbmail/imap4[6468]: COMMAND: [00000020 FETCH 27 BODY.PEEK [HEADER]] Aug 15 20:10:51 groupware dbmail/imap4[6468]: COMMAND: [00000021 FETCH 26 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:51 groupware dbmail/imap4[6468]: COMMAND: [00000022 FETCH 26 BODY.PEEK [HEADER]] Aug 15 20:10:51 groupware dbmail/imap4[6468]: COMMAND: [00000023 FETCH 25 (BODYSTRUCTURE FLAGS)] Aug 15 20:10:51 groupware dbmail/imap4[6468]: COMMAND: [00000024 FETCH 25 BODY.PEEK [HEADER]] Aug 15 20:10:52 groupware dbmail/imap4[6468]: COMMAND: [00000025 LOGOUT] Aug 15 20:10:52 groupware dbmail/imap4[6468]: IMAPD [PID 6468]: user (id:3) logging out @ (null)^M Aug 15 20:10:52 groupware dbmail/imap4[6468]: imap_process(): Closing connection for client from IP [127.0.0.1] Aug 15 20:10:52 groupware dbmail/imap4[6468]: SS_WaitAndProcess(): client @ socket 3 (IP: 127.0.0.1) logged out, connection closed ------------------------------------- It take 9 Sec to fetch 15 messages within a mailbox of about 40 messages. I got best results with Courier-IMAP... Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]
