Re: centos server's mysql version's problem
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 use php+mysql MySQL 5.0 is past its active maintenance. The MySQL team is fixing critical bugs (if any are found) for customers who are paying for extended maintenance. Until now, builds with critical bugs fixed have also been made available to the community, but there is no promise this practice will be continued. I recommend to base any new installation on a post-5.0 version of MYSQL which is declared GA (generally available, production quality). Currently, for this you can choose between 5.1 and 5.5. While 5.5 is quite new in GA status, nonetheless the reactions (both internal and external) are very positive. Especially if you want to use InnoDB as your table engine in higher load situations, you should profit very much from several improvements contained in 5.5. So IMO 5.0 is a no for new installations, 5.1 could be considered, but 5.5 is to be preferred. 2.the my.cnf should i configure or where i can find some information? Some sample configuration files are contained in the distribution. You should create your own by looking at these samples, combining their parts according to your needs and ressources, and then fine-tuning it based on the results of tests, measurements, and real-life use data. HTH, Joerg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@oracle.com ORACLE Deutschland B.V. Co. KG, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven Amtsgericht Muenchen: HRA 95603 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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
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
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
-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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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
RE: centos server's mysql version's problem
Just so I am clear here, you have 8 different DB servers hosting the same data that is being accessed and potentially modified simultaneously? You may want to consider the replication issues involved in that sort of arrangement with mysql. Aside from that, I am currently hosting an 18gb mysql database that is passing roughly 6gb/hr without any issue utilizing a single Dell R710 and mysql 5.0.77. Your mileage may differ based on the low end hardware/storage that you plan to use, the number of writes and the amount of data that you can cache in memory. From: Yang Yang [mailto:dapiy...@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 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.commailto:dch...@invenda.com -Original Message- From: Yang Yang [mailto:dapiy...@gmail.commailto:dapiy...@gmail.com] Sent: Sunday, February 27, 2011 12:29 PM To: Johnny Withers Cc: mysql@lists.mysql.commailto: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
Re: centos server's mysql version's problem
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 performed well in testing. Our 5.0 installs are handling about 25gb of data and 1200qps during peak hours. On Feb 27, 2011 2:29 PM, Yang Yang dapiy...@gmail.com wrote: 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 updat...