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
