centos server"s mysql version"s problem

--000e0cd70decd579f0049d46ecf6
Content-Type: text/plain; charset=ISO-8859-1

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

--000e0cd70decd579f0049d46ecf6--

Re: centos server"s mysql version"s problem

--0016e649c77022c74e049d481430
Content-Type: text/plain; charset=ISO-8859-1

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/

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 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
johnny@pixelated.net

--0016e649c77022c74e049d481430--

Re: centos server"s mysql version"s problem

--20cf305e24b9ba11f6049d496992
Content-Type: text/plain; charset=ISO-8859-1

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

> 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/
>
> 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 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
> johnny@pixelated.net
>

--20cf305e24b9ba11f6049d496992--

RE: centos server"s mysql version"s problem

> -----Original Message-----
> From: Yang Yang [mailto:dapiyang@gmail.com]=20
> 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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: centos server"s mysql version"s problem

--000e0cd4d50e045c2b049d4989c8
Content-Type: text/plain; charset=ISO-8859-1

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

>
>
> > -----Original Message-----
> > From: Yang Yang [mailto:dapiyang@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
>
>

--000e0cd4d50e045c2b049d4989c8--

RE: centos server"s mysql version"s problem

--_000_2EF89273EACD8D47B3A11F12E863AB1113F2E4B4FBMAILWESTcor po_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Just so I am clear here, you have 8 different DB servers hosting the same d=
ata that is being accessed and potentially modified simultaneously? You may=
want to consider the replication issues involved in that sort of arrangeme=
nt with mysql. Aside from that, I am currently hosting an 18gb mysql databa=
se 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 hardwa=
re/storage that you plan to use, the number of writes and the amount of dat=
a that you can cache in memory.


From: Yang Yang [mailto:dapiyang@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 >


> -----Original Message-----
> From: Yang Yang [mailto:dapiyang@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


--_000_2EF89273EACD8D47B3A11F12E863AB1113F2E4B4FBMAILWESTcor po_--

Re: centos server"s mysql version"s problem

--001485f27cda7f5e38049d4af655
Content-Type: text/plain; charset=ISO-8859-1

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" 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


>
> I think the version CentOS (5.5) wants to use is 5.0.77-log. I don't think
CentOS will be updat...

--001485f27cda7f5e38049d4af655--

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.bruehe@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=gcdmg-mysql-2@m.gmane.org