[horde] Problem of slow with server-side sorting
Jose Luis Marin Perez
jolumape_al at hotmail.com
Thu Jun 4 14:42:35 UTC 2009
> Date: Thu, 4 Jun 2009 09:27:21 +0200
> From: rsalmon at mbpgroup.com
> To: jolumape_al at hotmail.com
> CC: horde at lists.horde.org
> Subject: RE: [horde] Problem of slow with server-side sorting
>
>
> Jose Luis Marin Perez <jolumape_al at hotmail.com> a écrit :
>
> > Thanks for your answers.
> >
> > These hardware features:
> >
> > ML370 G4
> > Xeon 3.6 GHz CPU
> > 1 GB RAM
> > Hard Drive 300GB - Raid 1 - EXT3
> SAS or SATA ?
> did you disable atime on ext3 (Maildirs disk) ?
>
> > When accessing one of these accounts capture a sample of the TOP
> > command
> >
> > top - 09:37:51 up 4 days, 15:26, 2 users, load average: 5.07,
> > 4.85, 4.79
> > Tasks: 146 total, 1 running, 145 sleeping, 0 stopped, 0
> > zombie
> > Cpu(s): 46.5% us, 19.8% sy, 0.0% ni, 19.8% id, 13.9% wa, 0.0%
> > hi, 0.0% si
> > Mem: 1034512k total, 1008464k used, 26048k free,
> > 55592k buffers
> > Swap: 2048276k total, 143232k used, 1905044k free,
> > 516016k cached
>
> You definitely need more RAM! The load is pretty high. What is the
> running process?
>
> > On our server there are about 5000 mail accounts with more than
> > 1000 messages per account.
> >
> > As can enable an option _imp_hook_msglist_format and that benefits
> > could give me to solve my problem?
>
> The fact that we have the hook _imp_hook_msglist_format enabled really
> slow down accessing mailboxes (especially if they contains lots of
> emails) has IMP reads the content of each email to see if there are
> any attachments.
>
>
> Jose, can you reply after the message(instead of before)? It is easier
> to keep track of the discussion. thanks.
>
> Ronan.
Dear Ronan,
The server has 300GB SCSI RAID 1 - Ext3
Ext3 is the default has not changed anything in the configuration, this would help?
Based on your experience as it should increase the RAM?
This is an example of TOP to see the process:
top - 09:46:33 up 5 days, 15:35, 2 users, load average: 10.59, 13.92, 12.80
Tasks: 175 total, 2 running, 173 sleeping, 0 stopped, 0 zombie
Cpu(s): 36.1% us, 8.9% sy, 0.0% ni, 13.9% id, 41.1% wa, 0.0% hi, 0.0% si
Mem: 1034512k total, 1005808k used, 28704k free, 76620k buffers
Swap: 2048276k total, 163040k used, 1885236k free, 441280k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3184 mysql 15 0 886m 55m 2664 S 32.6 5.5 1732:33 mysqld
3760 daemon 16 0 22640 9.9m 4224 S 27.7 1.0 0:01.36 httpd
29351 daemon 16 0 28124 15m 4724 S 11.9 1.5 0:10.13 httpd
30238 daemon 16 0 22992 10m 4488 S 10.9 1.0 0:02.63 httpd
3891 root 16 0 3176 1048 768 R 2.0 0.1 0:00.62 top
32103 root 16 0 9444 4844 2524 R 2.0 0.5 0:00.73 crea_sentmail_c
1 root 16 0 2024 480 448 S 0.0 0.0 0:01.07 init
2 root RT 0 0 0 0 S 0.0 0.0 0:02.54 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:01.36 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:01.01 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:01.95 ksoftirqd/1
6 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
7 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1
8 root 6 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
9 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 kacpid
40 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0
41 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/1
42 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khubd
61 root 15 0 0 0 0 S 0.0 0.0 14:24.88 kswapd0
62 root 6 -10 0 0 0 S 0.0 0.0 0:00.00 aio/0
63 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 aio/1
207 root 25 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
450 root 16 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
452 root 16 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
470 root 7 -10 0 0 0 S 0.0 0.0 0:00.00 ata/0
471 root 7 -10 0 0 0 S 0.0 0.0 0:00.00 ata/1
472 root 7 -10 0 0 0 S 0.0 0.0 0:00.00 ata_aux
477 vpopmail 16 0 3312 260 212 S 0.0 0.0 0:00.00 qmail-popup
483 root 15 0 0 0 0 S 0.0 0.0 4:51.85 kjournald
738 qmailr 16 0 3272 504 420 S 0.0 0.0 0:00.00 qmail-remote
1139 daemon 15 0 22716 10m 4448 S 0.0 1.0 0:03.65 httpd
1147 root 6 -10 0 0 0 S 0.0 0.0 0:00.00 kauditd
1235 vpopmail 16 0 1900 264 212 S 0.0 0.0 0:00.00 qmail-popup
1342 vpopmail 16 0 3784 920 760 S 0.0 0.1 0:00.04 imapd
1408 vpopmail 16 0 3112 916 760 S 0.0 0.1 0:00.06 imapd
1759 root 6 -10 2296 364 360 S 0.0 0.0 0:00.00 udevd
1767 qmailr 16 0 2912 504 420 S 0.0 0.0 0:00.00 qmail-remote
How could you enable the option _imp_hook_msglist_format in the Horde?
Thank you for your patience and your support for this novice user.
Jolumape
_________________________________________________________________
Connect to the next generation of MSN Messenger
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
More information about the horde
mailing list