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 <[email protected]> > update your mysql. > > 2009/7/3 Tiago Gomes <[email protected]> > >> 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 >> [email protected] >> >> _______________________________________________ >> 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 [email protected]
_______________________________________________ List info: http://lists.roundcube.net/users/
