Re: [Dbmail] MySQL 5.0 vs 5.5

2012-06-13 Thread ITronic Harald Leithner
Hi Jorge, I upgraded form dbmail 2.2 to 3.0 and mysql 5.0 to percona server 5.5 but on a new hardware so I couldn't give you any good information about performance but I think Reindl Harald may have some information about the innodb compressed feature in mysql 5.5. regards, Harald Leithn

Re: [Dbmail] MySQL 5.0 vs 5.5

2012-06-13 Thread Jure Pečar
On Tue, 12 Jun 2012 23:52:04 +0100 "Jorge Bastos" wrote: > Is there anyone who moved from MySQL 5.0 to 5.5 with 3.0x version? > > Is there any performance impact? (5.1 has some performance problems) We use Percona build and have no problems with 5.1. -- Jure Pečar http://jure.pecar.org http:

Re: [Dbmail] sort in roundcubemail broken again

2012-06-13 Thread Jure Pečar
On Mon, 14 May 2012 11:45:42 +0200 Reindl Harald wrote: > hi > > http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_0&id=9e2f272541621d898d9485bfbf43818d7dce708c > > in 2da7411789e03a9b51f2e286ea1ea6cc4f3e4303 this seems to be broken again > as long i reset user-preferences and do not touch so

[Dbmail] memory leaks in 3.0.2

2012-06-13 Thread Jure Pečar
Hello, I'm observing decent memory leaks in all four dbmail daemons. In producton impad grows by about 300MB per day, others less since they're less utilized. Anyone else observing this? Is there an easy way to figure out where the memory is leaking without interrupting the service? -- Jur

Re: [Dbmail] memory leaks in 3.0.2

2012-06-13 Thread Reindl Harald
Am 13.06.2012 10:32, schrieb Jure Pečar: > > Hello, > > I'm observing decent memory leaks in all four dbmail daemons. In producton > impad grows by about 300MB per day, others less since they're less utilized. > > Anyone else observing this? > Is there an easy way to figure out where the memo

Re: [Dbmail] sort in roundcubemail broken again

2012-06-13 Thread Reindl Harald
Am 13.06.2012 10:21, schrieb Jure Pečar: > On Mon, 14 May 2012 11:45:42 +0200 > Reindl Harald wrote: > >> hi >> >> http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_0&id=9e2f272541621d898d9485bfbf43818d7dce708c >> >> in 2da7411789e03a9b51f2e286ea1ea6cc4f3e4303 this seems to be broken again >>

Re: [Dbmail] MySQL 5.0 vs 5.5

2012-06-13 Thread Reindl Harald
Am 13.06.2012 10:16, schrieb ITronic Harald Leithner: > Hi Jorge, > > I upgraded form dbmail 2.2 to 3.0 and mysql 5.0 to percona server 5.5 but on > a new hardware so I couldn't give you > any good information about performance but I think Reindl Harald may have > some information about the in

Re: [Dbmail] sort in roundcubemail broken again

2012-06-13 Thread Paul J Stevens
On 06/13/2012 11:00 AM, Reindl Harald wrote: > > > Am 13.06.2012 10:21, schrieb Jure Pečar: >> On Mon, 14 May 2012 11:45:42 +0200 >> Reindl Harald wrote: >> >>> hi >>> >>> http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_0&id=9e2f272541621d898d9485bfbf43818d7dce708c That fix (using DISTINCT)

Re: [Dbmail] MySQL 5.0 vs 5.5

2012-06-13 Thread Jorge Bastos
Hi Both, Thanks for your feedback's! Jorge, > -Original Message- > From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On > Behalf Of Reindl Harald > Sent: quarta-feira, 13 de Junho de 2012 10:05 > To: dbmail@dbmail.org > Subject: Re: [Dbmail] MySQL 5.0 vs 5.5 > > > > A

Re: [Dbmail] MySQL 5.0 vs 5.5

2012-06-13 Thread Jorge Bastos
One extra info, for both, Wich are the DB size each of you have? I have 120GB now, InnoDB, with file_per_table. Jorge,s > we are using compressed tables since 2009 / MySQL 5.1 in 5.1 you needed > innodb_plugin, 5.5 supports native > > be aware you need "innodb_file_per_table" for this feature >

Re: [Dbmail] MySQL 5.0 vs 5.5

2012-06-13 Thread Reindl Harald
around 10 GB and 6 messages e-mail is not our core business, it's only to provide all services at once (domain,dns,design, development,web...) but i am pretty sure you will also benefit from compression with 120 GB as long you are not cpu-bound because lesser disk-IO "innodb_io_capacity" may