James,
Ill upgrade only after tests... the mistake you did, I also did in the past and wont do it now :P Thanks for your feedback J Jorge, From: [email protected] [mailto:[email protected]] On Behalf Of James Greig Sent: terça-feira, 21 de Setembro de 2010 18:25 To: DBMAIL Developers Mailinglist Subject: Re: [Dbmail-dev] MySQL 5.5, anyone? 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 2950s with around 24GB+ of ram (see below) so this gives you an idea in terms of our setupJ [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 possibleJ Id 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: [email protected] [mailto:[email protected]] 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 Im 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 dont have any performance issues. Ive read that 5.5 will bypass the 5.1 performance issues, and will be faster evan than 5.0 . From: [email protected] [mailto:[email protected]] 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 wont be moving away from stable 5.0 from a long time... Kind Regards James Greig From: [email protected] [mailto:[email protected]] On Behalf Of Jorge Bastos Sent: 21 September 2010 16:47 To: 'DBMAIL Developers Mailinglist' Subject: [Dbmail-dev] MySQL 5.5, anyone? Howdy people, Id like to know if theres anyone in MySQL 5.5 (now RC). Id 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 [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
