Can you try adding the -fomit-frame-pointers to your CFLAGS like described below. Don't worry about the cpu flags.
------------- On Friday 24 October 2003 5:35 am, Shih Ming-Wei wrote: > > hi, > > > > I have solve the 99% CPU usage on Linux/sparc systems that > > we are using, apparently changing CFLAGS from "-O2 -pipe" to > > "-march=v8 -mtune=v9 -O2 -pipe -fomit-frame-pointer" cahnges > > the CPU usage from 99% to max 1.8% (avg 0.4 %). So my > > conclusion is this is not a dbmail bug but dbmail must trigger > > some bug in platform/compiler/glibc, ------------- Bret. On Thursday 20 November 2003 10:03 am, Keith Hopkins wrote: > 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) -- Bret Baptist Systems and Technical Support Specialist [EMAIL PROTECTED] Internet Exposure, Inc. http://www.iexposure.com (612)676-1946 x17 Web Development-Web Marketing-ISP Services ------------------------------------------ Today is the tomorrow you worried about yesterday.
