ok that was not a very smart question as the log shows the timing. Main
problem is that your client is requesting the message in chunks of
10240 bytes which does not speed up things; the commands self are
pretty fast (1 sec each). I've noticed this behaviour of several
clients in an early stage of imapd development (for example netscape
v.4.77 (yes that's along time ago) 's mail does this) and added a
(very) simple caching mechanism to speed things up. Could be that we
need some optimization with indexes and such but AFAICT the commands
run pretty fast separately.
Op 20-nov-03 om 17:05 heeft Roel Rozendaal - IC&S het volgende
geschreven:
could you test on a telnet session to the imap server executing these
commands manually and timing them?
Op 20-nov-03 om 17:03 heeft Keith Hopkins het volgende geschreven:
This was really, really SLOW....
Nov 21 00:07:15 hades dbmail/imap4d[4121]: COMMAND: [52 UID fetch
358907 (BODYSTRUCTURE)]
Nov 21 00:07:16 hades dbmail/imap4d[4121]: COMMAND: [53 UID fetch
358907 (BODY[HEADER] BODY[1.MIME] BODY[2.MIME] BODY[3.MIME]
BODY[4.MIME] BODY[5.MIME])]
Nov 21 00:07:16 hades dbmail/imap4d[4121]: COMMAND: [54 UID fetch
358907 (BODY[1])]
Nov 21 00:07:16 hades dbmail/imap4d[4121]: COMMAND: [55 UID fetch
358907 (BODY[2]<0.10240>)]
Nov 21 00:07:17 hades dbmail/imap4d[4121]: COMMAND: [56 UID fetch
358907 (BODY[2]<10240.10240>)]
....
Nov 21 00:32:33 hades dbmail/imap4d[4127]: COMMAND: [1317 UID fetch
358907 (BODY[4]<3921920.10240>)]
Nov 21 00:32:34 hades dbmail/imap4d[4127]: COMMAND: [1318 UID fetch
358907 (BODY[4]<3932160.10240>)]
Nov 21 00:32:35 hades dbmail/imap4d[4127]: COMMAND: [1319 UID fetch
358907 (BODY[4]<3942400.10240>)]
It took 25 Minutes to download a 8.8M file attachement. Can that be
right? Do I have something seriously wrong with my systems? Any
pointers?
The server is a AMD 2400+(2.0G) system w/ 1.5G RAM running SuSE 8.1.
dbmail is 1.2.1 and mysql is mysql-3.23.52-106(SuSE flavor). The db
is InnoDB. Very little disk activity as seen on the md/sw IDE RAID5
array where /var/lib/mysql lives. top showed mysqld-max and
dbmail-imapd sharing the CPU, both staying in the 40%-45% range, with
the remaining 5-10% of CPU going to system time. mysql-max ate about
600M. dbmail-imapd only showed about 8M. mytop showed an average of
18trans/sec. swap used was 6M of 256M (I figured w/ 1.5G RAM, who
needs swap?) syslogd activity and system disk activity was fairly
light.
The client is a AMD 2400+(2.0G) system w/ 756M RAM running SuSE 8.2
w/ the Mozilla 1.5 mail client. CPU activity was < 10%.
The network cards and backbone are Gigabit.
(afterwards)
mysql> show table status;
+---------------+--------+------------+--------+----------------
+-------------+-----------------+--------------+-----------
+----------------+-------------+-------------+------------
+----------------+-------------------------+
| Name | Type | Row_format | Rows | Avg_row_length |
Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_time | Update_time | Check_time |
Create_options | Comment |
+---------------+--------+------------+--------+----------------
+-------------+-----------------+--------------+-----------
+----------------+-------------+-------------+------------
+----------------+-------------------------+
| aliases | InnoDB | Dynamic | 40 | 409 |
16384 | NULL | 32768 | 0 | 45
| NULL | NULL | NULL | | InnoDB
free: 1375232 kB |
| auto_replies | InnoDB | Dynamic | 0 | 0 |
16384 | NULL | 0 | 0 | 1
| NULL | NULL | NULL | | InnoDB
free: 1375232 kB |
| mailboxes | InnoDB | Dynamic | 183 | 89 |
16384 | NULL | 114688 | 0 | 479
| NULL | NULL | NULL | | InnoDB
free: 1375232 kB |
| messageblks | InnoDB | Dynamic | 376184 | 4070 |
1531412480 | NULL | 19775488 | 0 |
723172 | NULL | NULL | NULL | |
InnoDB free: 1375232 kB |
| messages | InnoDB | Dynamic | 78538 | 205 |
16138240 | NULL | 24936448 | 0 |
359182 | NULL | NULL | NULL | |
InnoDB free: 1375232 kB |
| tmpmessage | InnoDB | Dynamic | 0 | 0 |
16384 | NULL | 32768 | 0 | 305
| NULL | NULL | NULL | | InnoDB
free: 1375232 kB |
| tmpmessageblk | InnoDB | Dynamic | 0 | 0 |
16384 | NULL | 49152 | 0 | 625
| NULL | NULL | NULL | | InnoDB
free: 1375232 kB |
| users | InnoDB | Dynamic | 9 | 1820 |
16384 | NULL | 49152 | 0 | 11
| NULL | NULL | NULL | | InnoDB
free: 1375232 kB |
+---------------+--------+------------+--------+----------------
+-------------+-----------------+--------------+-----------
+----------------+-------------+-------------+------------
+----------------+-------------------------+
8 rows in set (0.44 sec)
--
Lost in Tokyo,
Keith
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_________________________
R.A. Rozendaal
IC&S
T: +31 30 63 55 739
F: +31 30 63 55 731
www.ic-s.nl
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_________________________
R.A. Rozendaal
IC&S
T: +31 30 63 55 739
F: +31 30 63 55 731
www.ic-s.nl
