centos server's mysql version's problem
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 use php+mysql 2.the my.cnf should i configure or where i can find some information? thanks all ,hope receive responce
Re: centos server's mysql version's problem
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 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: http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/ http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/Install went well, server runs great. I'd suggest going with 5.5. JW On Sun, Feb 27, 2011 at 11:30 AM, Yang Yang dapiy...@gmail.com 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 use php+mysql 2.the my.cnf should i configure or where i can find some information? thanks all ,hope receive responce -- - Johnny Withers 601.209.4985 joh...@pixelated.net
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 Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 1TB SATAII(*4 raid 10) 8gb ram thanks 2x Intel Xeon Nehalem 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 problem 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 How much traffic is large traffic? How large is your database? How is it structured? What type of hardware are you using? -David