quick question

[Hervey Liu]

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,
   when datetime DEFAULT '-00-00 00:00:00' NOT NULL,
   browser varchar(255) NOT NULL,
   ipaddress varchar(20) NOT NULL,
   activity enum('user','quote','liquidate','manage','finale') DEFAULT
'quote' NOT NULL,
   userid int(10) unsigned NOT NULL,
   symbolid int(10) unsigned,
   PRIMARY KEY (when, userid)


thank you
hervey

Re: centos server's mysql version's problem

[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 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...

RE: centos server's mysql version's problem

[David Brian Chait]

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 mailto: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

[Yang Yang]

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

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

[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 

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

Re: centos server's mysql version's problem

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

centos server's mysql version's problem

[Yang Yang]

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