[horde] Problem of slow with server-side sorting

[lst_hoe02 at kwsoft.de]

Zitat von Jose Luis Marin Perez <jolumape_al at hotmail.com>:

>
>> 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

Your MySQL Database is bogged down and you should consider using a PHP  
accelerator. The "wait" percentage is high, this could be a sign of  
overloaded disk I/O. Check what is doing most of I/O. It *may* be  
MySQL so have a look why.

Regards

Andreas