Hi Jorge,
Apologies for the poor typing on my previous email, was talking to a colleague
at the same time. My main advice would be to test as much as possible on a new
setup prior to committing if your service is a production environment live to
customers. We made the mistake of tieing in an upgrade of hardware with an
upgrade of MySQL to 5.1 without any major testing. We currently use a number
of dell 2950's with around 24GB+ of ram (see below) so this gives you an idea
in terms of our setup:)
[Master-3] *Redacted*-6:/var/lib/mysql# free -m
total used free shared buffers cached
Mem: 24165 23969 195 0 54 1978
-/+ buffers/cache: 21937 2228
So, my main advice is test and test some more where humanly possible:) I'd
also delve into google and see what negatives people have regarding performance
for MySQL 5.5. Is it actually released as stable yet? As I thought it was
still in BETA?
James Greig
From: dbmail-dev-boun...@dbmail.org [mailto:dbmail-dev-boun...@dbmail.org] On
Behalf Of Jorge Bastos
Sent: 21 September 2010 18:13
To: 'DBMAIL Developers Mailinglist'
Subject: Re: [Dbmail-dev] MySQL 5.5, anyone?
Hi James,
Well... that leaves me with one foot behind.
Right now I'm on 5.0 also, with file_per_table configured for InnoDB, and with
a small P4 3.0 with HT with 3,2GB RAM (ya...3,2... stupid Motherboard!!), on
LinuxRAID, I don't have any performance issues.
I've read that 5.5 will bypass the 5.1 performance issues, and will be faster
evan than 5.0 .
From: dbmail-dev-boun...@dbmail.org [mailto:dbmail-dev-boun...@dbmail.org] On
Behalf Of James Greig
Sent: terça-feira, 21 de Setembro de 2010 17:10
To: DBMAIL Developers Mailinglist
Subject: Re: [Dbmail-dev] MySQL 5.5, anyone?
We moved our DBmail installation to MySQL 5.1 and that was a huge mistake, we
had massive performance problems. Note that We use DBMail 2.2 with 9000 users:
191G ./dbmail
We used separate innodb table files and the data has recently been dumped in
and out again reducing empty table space.
We won't be moving away from stable 5.0 from a long time..
Kind Regards
James Greig
From: dbmail-dev-boun...@dbmail.org [mailto:dbmail-dev-boun...@dbmail.org] On
Behalf Of Jorge Bastos
Sent: 21 September 2010 16:47
To: 'DBMAIL Developers Mailinglist'
Subject: [Dbmail-dev] MySQL 5.5, anyone?
Howdy people,
I'd like to know if there's anyone in MySQL 5.5 (now RC).
I'd like to plan my upgrade of DBMail with MySQL 5.5 on new hardware...
If anyone or Paul has feedback about this, please send some feedback,
Thanks,
Jorge,
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
