Re: Can MySQL handle 120 million records? - Michael She - com.mysql.lists.mysql

100 messages in com.mysql.lists.mysqlRe: Can MySQL handle 120 million reco...

From	Sent On	Attachments
Jeremy Zawodny	17 Dec 2002 19:16
David T-G	17 Dec 2002 20:30
Qunfeng Dong	17 Dec 2002 20:43
JamesD	17 Dec 2002 20:59
Jeremy Zawodny	17 Dec 2002 21:07
Jeremy Zawodny	17 Dec 2002 22:19
Michael She	17 Dec 2002 23:36
Michael She	17 Dec 2002 23:38
B.G. Mahesh	18 Dec 2002 00:10
B.G. Mahesh	18 Dec 2002 00:51
David T-G	18 Dec 2002 05:11
Peter Vertes	18 Dec 2002 06:46
Michael T. Babcock	18 Dec 2002 07:09
Michael T. Babcock	18 Dec 2002 07:11
Jeremy Zawodny	18 Dec 2002 08:06
Jeremy Zawodny	18 Dec 2002 08:08
Jocelyn Fournier	18 Dec 2002 08:40
Muruganandam	18 Dec 2002 08:55
Michael She	18 Dec 2002 09:15
W. D.	18 Dec 2002 09:37
Qunfeng Dong	18 Dec 2002 09:47
Michael T. Babcock	18 Dec 2002 09:48
Jocelyn Fournier	18 Dec 2002 09:49
David Brodbeck	18 Dec 2002 10:09
Michael T. Babcock	18 Dec 2002 10:22
Jeremy Zawodny	18 Dec 2002 10:22
Michael Bacarella	18 Dec 2002 10:26
Jocelyn Fournier	18 Dec 2002 10:33
Gerald Jensen	18 Dec 2002 10:41
Greg...@sandwich.pfizer.com	18 Dec 2002 10:59
Gary Hostetler	18 Dec 2002 11:04
Csongor Fagyal	18 Dec 2002 11:05
Paul DuBois	18 Dec 2002 11:14
R. Hannes Niedner	18 Dec 2002 11:25
Michael T. Babcock	18 Dec 2002 11:26
Paul DuBois	18 Dec 2002 11:33
W. D.	18 Dec 2002 11:37
Michael T. Babcock	18 Dec 2002 11:50
Joe Stump	18 Dec 2002 11:54
Michael T. Babcock	18 Dec 2002 11:59
Wayne Lewis	18 Dec 2002 12:02
Adam Nelson	18 Dec 2002 12:31
Michael She	18 Dec 2002 12:35
Michael T. Babcock	18 Dec 2002 12:42
Qunfeng Dong	18 Dec 2002 13:06
Qunfeng Dong	18 Dec 2002 13:17
Aaron Clausen	18 Dec 2002 13:27
Joe Stump	18 Dec 2002 13:35
Csongor Fagyal	18 Dec 2002 14:25
R. Hannes Niedner	18 Dec 2002 14:25
Jocelyn Fournier	18 Dec 2002 17:02
RBR...@mnd.philcom.com	18 Dec 2002 17:14
Ryan Fox	18 Dec 2002 17:45
JamesD	18 Dec 2002 20:05
Dyego Souza do Carmo	19 Dec 2002 02:08
Csongor Fagyal	19 Dec 2002 03:14
Dana Diederich	19 Dec 2002 05:50
Brent Baisley	19 Dec 2002 06:05
John Griffin	19 Dec 2002 07:44
Michael Bacarella	19 Dec 2002 08:59
Paul DuBois	19 Dec 2002 09:35
Richard E. Perlotto II	19 Dec 2002 10:25
Paul DuBois	19 Dec 2002 10:38
Iikka Meriläinen	19 Dec 2002 12:59
Eric Anderson	19 Dec 2002 13:30
Qunfeng Dong	19 Dec 2002 15:27
Adolfo Bello	19 Dec 2002 17:31
King...@yahoo.com	19 Dec 2002 20:48
Jeremy Zawodny	20 Dec 2002 15:28
Michael She	20 Dec 2002 18:24
JamesD	20 Dec 2002 21:00
JamesD	21 Dec 2002 00:32
Dean Harding	21 Dec 2002 00:45
JamesD	21 Dec 2002 09:08
SpamSucks86	21 Dec 2002 20:37
JamesD	21 Dec 2002 21:59
ri...@lorcom.com	21 Dec 2002 22:05
ri...@lorcom.com	21 Dec 2002 22:20
Jeremy Zawodny	22 Dec 2002 00:35
SpamSucks86	22 Dec 2002 05:56
Benjamin Pflugmann	22 Dec 2002 07:40
SpamSucks86	22 Dec 2002 08:13
Richard Clarke	22 Dec 2002 08:57
ri...@lorcom.com	22 Dec 2002 08:58
Michael T. Babcock	22 Dec 2002 19:41
Michael T. Babcock	22 Dec 2002 19:43
Jeremy Zawodny	22 Dec 2002 20:31
Gordon	23 Dec 2002 12:20
Dennis Salguero	23 Dec 2002 14:37
Amitié Plus	24 Dec 2002 05:07
Adolfo Bello	24 Dec 2002 05:21
Victoria Reznichenko	24 Dec 2002 07:54
Victoria Reznichenko	24 Dec 2002 07:54
Victoria Reznichenko	24 Dec 2002 07:54
Scott Pippin	24 Dec 2002 10:09
Richard Clarke	24 Dec 2002 10:10
Dan Nelson	24 Dec 2002 10:38
Larry Brown	24 Dec 2002 11:01
Richard Clarke	24 Dec 2002 11:20
Mark Matthews	24 Dec 2002 12:26

Subject:	Re: Can MySQL handle 120 million records?
From:	Michael She (mich...@binaryio.com)
Date:	12/18/2002 09:15:38 AM
List:	com.mysql.lists.mysql

At 08:06 AM 12/18/2002 -0800, Jeremy Zawodny wrote:

I have no problems using MySQL as a lightweight database for simple chores, but I'm a bit weary about putting into a mission critical environment.

Why, exactly?

Mainly for 2 reasons:

1. MySQL hasn't been "proven" yet in the corporate environment 2. Some of the comments in the mySQL manual... people losing data doing routine stuff like table optimizations, adding keys, etc. If a database is reliable, things like that shouldn't happen. Comments like those in the MySQL manual scared me.