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
