Re: centos server's mysql version's problem

2011-02-28 Thread Joerg Bruehe
HGi Yang, all! Yang Yang wrote: hi,i am a new guy for a company,and will make 1-3 server to mysql datacenter i have 2 question want to ask and hope receive responce 1.on centos or linux server,i should use 5.0 version or 5.1 version,which verison is better and can resolve many traffic

Re: centos server's mysql version's problem

2011-02-27 Thread Johnny Withers
I think the version CentOS (5.5) wants to use is 5.0.77-log. I don't think CentOS will be updating the repository 5.5 uses for updates to any later version of mysql. I just completed two MySQL 5.5 installs on some RHEL machines by using the remi repository. I followed this guide here:

Re: centos server's mysql version's problem

2011-02-27 Thread Yang Yang
thanks johnny what about 5.1,did it performance better than 5.0 on centos when it has large traffic? 5.1 is newer,but i know not newer is better thanks again 2011/2/28 Johnny Withers joh...@pixelated.net I think the version CentOS (5.5) wants to use is 5.0.77-log. I don't think CentOS will

RE: centos server's mysql version's problem

2011-02-27 Thread David Brian Chait
-Original Message- From: Yang Yang [mailto:dapiy...@gmail.com] Sent: Sunday, February 27, 2011 12:29 PM To: Johnny Withers Cc: mysql@lists.mysql.com Subject: Re: centos server's mysql version's problem thanks johnny what about 5.1,did it performance better than 5.0 on centos

Re: centos server's mysql version's problem

2011-02-27 Thread Yang Yang
e5520 - 2.26GHz 500 GB SATAII 2011/2/28 David Brian Chait dch...@invenda.com -Original Message- From: Yang Yang [mailto:dapiy...@gmail.com] Sent: Sunday, February 27, 2011 12:29 PM To: Johnny Withers Cc: mysql@lists.mysql.com Subject: Re: centos server's mysql version's

RE: centos server's mysql version's problem

2011-02-27 Thread David Brian Chait
...@gmail.com] Sent: Sunday, February 27, 2011 12:38 PM To: David Brian Chait Cc: Johnny Withers; mysql@lists.mysql.com Subject: Re: centos server's mysql version's problem about 8,000,000 visit,and about 40,000,000 sql do about 2g database,and the large table who aften use about 400m 2x Intel Xeon

Re: centos server's mysql version's problem

2011-02-27 Thread Johnny Withers
The only 5.1 version I tried was percona's. I only tested it in development. Can't speak for MySQL's version. 5.5 is GA now, its supposed to have many improvements for mulitiprocessor machines over 5.0 and 5.1. This will be my first production install of 5.5, real traffic has not hit yet, but it