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
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:
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
-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
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
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
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
hello
i am a noob in general
i just want to double check
can someone perhaps send me a screen shot of how the following data will
look in a mysql table
;
CREATE TABLE logins (
success
enum('Y','N[banned]','N[password]','N[panic]','N[activation]','N[authorization]')
DEFAULT 'Y' NOT NULL,