[RCU] High cpu overload

Tiago Gomes algodas at gmail.com
Sun Jul 5 02:01:39 CEST 2009


Olá Gutemberg, till ,


Já está atualizado , mysql 5 , gerei mysql.initial , mesmo assim ainda
apresenta o problema, O overload geralmente acontece quando há mais de 600
conexões , acabei de colocar o round robin no dns pra duas máquinas pra ver
se melhora. Algumas sugestão ? Abraço

Hello Gutemberg,


Already updated, mysql 5, generated mysql.initial nevertheless still shows
the problem, the overload usually occurs when there are more than 600
connections, just put in the round robin dns for two machines to see is
improvement. Some suggestion? Abraço



2009/7/4 Gutenberg Campos <gutenbergc at gmail.com>

> update your mysql.
>
> 2009/7/3 Tiago Gomes <algodas at gmail.com>
>
>> Hello everyone.
>> sorry because my poor english, congratulations to all the excellent
>> project roundcube mail. I have one problem, I installed all versions for
>> test, including svn / trunk (latest) and all creates overload on my server.
>> High cpu load
>>
>> I'm using the services:
>>
>> Apache:
>>
>> Server version: Apache/2.2.6 (Unix)
>> Server built:   Jul  1 2009 20:41:05
>> * - -with-mpm=worker*
>>
>> Php:
>>
>> PHP 5.2.6-1+lenny3 with Suhosin-Patch 0.9.6.2 (cli) (built: Apr 26 2009
>> 22:16:23)
>> Copyright (c) 1997-2008 The PHP Group
>> Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
>>
>> Mysql 5.0
>>
>> SERVER load average info after 10 minutes then restart the apache server:
>>
>> *top - 16:48:25 up  6:24,  3 users,  load average: 6.92, 2.89, 3.88*
>> Tasks:  84 total,   2 running,  82 sleeping,   0 stopped,   0 zombie
>> *Cpu(s): 98.1%us,  1.7%sy,  0.0%ni, 46.9%id,  0.2%wa,  0.0%hi,  0.0%si,
>> 0.0%st*
>> Mem:   2076288k total,  1079936k used,   996352k free,   297020k buffers
>> Swap:   498004k total,        0k used,   498004k free,   486532k cached
>>
>>
>>  PID USER      PR  NI  VIRT  RES  SHR S *%CPU* %MEM    TIME+
>> COMMAND
>>
>>
>> 14103 www-data  20   0  564m 125m 3536 S  *190*  6.2   6:28.57
>> httpd
>>
>> 14088 www-data  20   0  517m  89m 3464 S  * 118*  4.4  10:45.10 httpd
>>
>>
>>
>> the log error log from round roundcube mail:
>>
>> Only:
>>
>> *[03-Jul-2009 16:48:08 -0300] DB Error: MDB2 Error: constraint violation
>> Query: _doQuery: [Error message: Could not execute statement] [Last executed
>> query: EXECUTE
>> mdb2_statement_mysql_501fd0fc317c477d1c729158644dc2c5bd5f1d12d USING @0, @1,
>> @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message:
>> Duplicate entry '2557-INBOX.msg-13334' for key 2]  in /webhost/
>> webmail.atarde.com.br/program/include/rcube_mdb2.php on line 621 (GET
>> /?_task=mail&_mbox=INBOX&_page=1)
>>
>> [03-Jul-2009 16:48:08] MDB2 Error: constraint violation (-3): _doQuery:
>> [Error message: Could not execute statement]
>>
>> [Last executed query: EXECUTE
>> mdb2_statement_mysql_674a5a0876c6968d9d29cb5837c47123866f39a43 USING @0, @1,
>> @2, @3, @4, @5, @6, @7, @8, @9, @10]
>>
>> [Native code: 1062]
>>
>> [Native message: Duplicate entry '2557-INBOX.msg-13401' for key 2]
>> *
>> Can you Help me,  ? Thank's
>>
>> --
>> ----------------------------------------------------------------
>> Tiago Gomes Pereira http://www.tiagogomes.eti.br
>> LPI Certified
>> LPI ID - LPI000129445
>> IT Service Management - ITIL FOUNDATION V2
>> ID - SR341901
>> algodas at gmail.com
>>
>> _______________________________________________
>> List info: http://lists.roundcube.net/users/
>>
>>
>
>
> --
> AVISO LEGAL
> Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é
> dirigida, podendo conter informação confidencial e/ou legalmente
> privilegiada. Se você não for destinatário desta mensagem, desde já fica
> notificado de abster-se a divulgar, copiar, distribuir, examinar ou, de
> qualquer forma, utilizar a informação contida nesta mensagem, por ser
> ilegal. Caso você tenha recebido esta mensagem por engano, pedimos que nos
> retorne este E-Mail, promovendo, desde logo, a eliminação do seu conteúdo em
> sua base de dados, registros ou sistema de controle. Fica desprovida de
> eficácia e validade a mensagem que contiver vínculos obrigacionais, expedida
> por quem não detenha poderes de representação.
>
> --
> Roosevelth Gutenberg Ferreira Campos - M.Sc
> Membro do GTMSL - Governo Federal
> Linux User 370146
>



-- 
----------------------------------------------------------------
Tiago Gomes Pereira http://www.tiagogomes.eti.br
LPI Certified
LPI ID - LPI000129445
IT Service Management - ITIL FOUNDATION V2
ID - SR341901
algodas at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.roundcube.net/pipermail/users/attachments/20090704/9ffbda2f/attachment-0001.html>
-------------- next part --------------
_______________________________________________
List info: http://lists.roundcube.net/users/


More information about the users mailing list