100 messages in com.mysql.lists.mysqlRE: Can MySQL handle 120 million reco...
FromSent OnAttachments
Jeremy Zawodny17 Dec 2002 19:16 
David T-G17 Dec 2002 20:30 
Qunfeng Dong17 Dec 2002 20:43 
JamesD17 Dec 2002 20:59 
Jeremy Zawodny17 Dec 2002 21:07 
Jeremy Zawodny17 Dec 2002 22:19 
Michael She17 Dec 2002 23:36 
Michael She17 Dec 2002 23:38 
B.G. Mahesh18 Dec 2002 00:10 
B.G. Mahesh18 Dec 2002 00:51 
David T-G18 Dec 2002 05:11 
Peter Vertes18 Dec 2002 06:46 
Michael T. Babcock18 Dec 2002 07:09 
Michael T. Babcock18 Dec 2002 07:11 
Jeremy Zawodny18 Dec 2002 08:06 
Jeremy Zawodny18 Dec 2002 08:08 
Jocelyn Fournier18 Dec 2002 08:40 
Muruganandam18 Dec 2002 08:55 
Michael She18 Dec 2002 09:15 
W. D.18 Dec 2002 09:37 
Qunfeng Dong18 Dec 2002 09:47 
Michael T. Babcock18 Dec 2002 09:48 
Jocelyn Fournier18 Dec 2002 09:49 
David Brodbeck18 Dec 2002 10:09 
Michael T. Babcock18 Dec 2002 10:22 
Jeremy Zawodny18 Dec 2002 10:22 
Michael Bacarella18 Dec 2002 10:26 
Jocelyn Fournier18 Dec 2002 10:33 
Gerald Jensen18 Dec 2002 10:41 
Greg...@sandwich.pfizer.com18 Dec 2002 10:59 
Gary Hostetler18 Dec 2002 11:04 
Csongor Fagyal18 Dec 2002 11:05 
Paul DuBois18 Dec 2002 11:14 
R. Hannes Niedner18 Dec 2002 11:25 
Michael T. Babcock18 Dec 2002 11:26 
Paul DuBois18 Dec 2002 11:33 
W. D.18 Dec 2002 11:37 
Michael T. Babcock18 Dec 2002 11:50 
Joe Stump18 Dec 2002 11:54 
Michael T. Babcock18 Dec 2002 11:59 
Wayne Lewis18 Dec 2002 12:02 
Adam Nelson18 Dec 2002 12:31 
Michael She18 Dec 2002 12:35 
Michael T. Babcock18 Dec 2002 12:42 
Qunfeng Dong18 Dec 2002 13:06 
Qunfeng Dong18 Dec 2002 13:17 
Aaron Clausen18 Dec 2002 13:27 
Joe Stump18 Dec 2002 13:35 
Csongor Fagyal18 Dec 2002 14:25 
R. Hannes Niedner18 Dec 2002 14:25 
Jocelyn Fournier18 Dec 2002 17:02 
RBR...@mnd.philcom.com18 Dec 2002 17:14 
Ryan Fox18 Dec 2002 17:45 
JamesD18 Dec 2002 20:05 
Dyego Souza do Carmo19 Dec 2002 02:08 
Csongor Fagyal19 Dec 2002 03:14 
Dana Diederich19 Dec 2002 05:50 
Brent Baisley19 Dec 2002 06:05 
John Griffin19 Dec 2002 07:44 
Michael Bacarella19 Dec 2002 08:59 
Paul DuBois19 Dec 2002 09:35 
Richard E. Perlotto II19 Dec 2002 10:25 
Paul DuBois19 Dec 2002 10:38 
Iikka Meriläinen19 Dec 2002 12:59 
Eric Anderson19 Dec 2002 13:30 
Qunfeng Dong19 Dec 2002 15:27 
Adolfo Bello19 Dec 2002 17:31 
King...@yahoo.com19 Dec 2002 20:48 
Jeremy Zawodny20 Dec 2002 15:28 
Michael She20 Dec 2002 18:24 
JamesD20 Dec 2002 21:00 
JamesD21 Dec 2002 00:32 
Dean Harding21 Dec 2002 00:45 
JamesD21 Dec 2002 09:08 
SpamSucks8621 Dec 2002 20:37 
JamesD21 Dec 2002 21:59 
ri...@lorcom.com21 Dec 2002 22:05 
ri...@lorcom.com21 Dec 2002 22:20 
Jeremy Zawodny22 Dec 2002 00:35 
SpamSucks8622 Dec 2002 05:56 
Benjamin Pflugmann22 Dec 2002 07:40 
SpamSucks8622 Dec 2002 08:13 
Richard Clarke22 Dec 2002 08:57 
ri...@lorcom.com22 Dec 2002 08:58 
Michael T. Babcock22 Dec 2002 19:41 
Michael T. Babcock22 Dec 2002 19:43 
Jeremy Zawodny22 Dec 2002 20:31 
Gordon23 Dec 2002 12:20 
Dennis Salguero23 Dec 2002 14:37 
Amitié Plus24 Dec 2002 05:07 
Adolfo Bello24 Dec 2002 05:21 
Victoria Reznichenko24 Dec 2002 07:54 
Victoria Reznichenko24 Dec 2002 07:54 
Victoria Reznichenko24 Dec 2002 07:54 
Scott Pippin24 Dec 2002 10:09 
Richard Clarke24 Dec 2002 10:10 
Dan Nelson24 Dec 2002 10:38 
Larry Brown24 Dec 2002 11:01 
Richard Clarke24 Dec 2002 11:20 
Mark Matthews24 Dec 2002 12:26 
Subject:RE: Can MySQL handle 120 million records?
From:JamesD (ji@workinout.com)
Date:12/21/2002 09:08:16 AM
List:com.mysql.lists.mysql

Thanks Dean.

-----Original Message----- From: Dean Harding [mailto:dea@bigpond.net.au] Sent: Saturday, December 21, 2002 12:46 AM To: 'JamesD'; mys@lists.mysql.com Subject: RE: Can MySQL handle 120 million records?

It's just that the number of rows in a table is stored directly in the .MYD file (I believe) so a query like "select count(*) from table" will just return that value, rather than counting all the rows. It's not that the functions are "built-in", rather they're *optimized* - a totally different thing.

Dean.

-----Original Message----- From: JamesD [mailto:ji@workinout.com] Sent: Saturday, 21 December 2002 7:33 pm To: mys@lists.mysql.com Subject: RE: Can MySQL handle 120 million records?

Jeremy,

if i run the command

show tables; on some database it returns

"5 rows in set (0.02 sec)"

and if, on the same database i run the command

select count(*) from 'table'; it returns

+---------+ | count(*)| +---------+ | 47226322| +---------+ 1 row in set (0.00 sec)

now, i believe its reasonable to assume a CPU must spend more time to count 47 million records, than to count 5 tables. This is why I believe that many common selects are built-in to mysql in the code somewhere. make sense? Its a good idea actually, that building in commonly run selects when the process is idling and stuffing results into variables that can be called in an instant, saves us all time and money...

Jim

-----Original Message----- From: Jeremy Zawodny [mailto:Jer@Zawodny.com] Sent: Friday, December 20, 2002 3:28 PM To: JamesD Cc: mys@lists.mysql.com Subject: Re: Can MySQL handle 120 million records?

On Wed, Dec 18, 2002 at 08:05:46PM -0800, JamesD wrote:

i like mySQL, but it has a long way to go to gain the level of 'confidence' that oracle, db2 or mssql or sybase have when it comes to frontline mission critical stuff.

Can you explain why?

I think it will in time...thats why i stick with it. besides, confidence is often just a synonym for 'knowledge'

Really? I tend to see it more like confidence builds with experience (and therefore time). You don't need to know a lot about to become confident in its operation. Many of us don't *really* understand how gravity works, but we're quite confident in it.

select count(*) from x (0.00 seconds)

if you dig into the source, you will probably find this common select is built in and running all the time,

and we are all just getting a pre-filled variable returned from the method " select count(*) from (x) "

Please find it. I'll bet you money that it's not.

I hope someone can prove me wrong...

I think the burden of proof is on you.

Jeremy

-- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <Jer@Zawodny.com> | http://jeremy.zawodny.com/

MySQL 3.23.51: up 5 days, processed 219,909,773 queries (441/sec. avg)

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe- jim=work@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe- deanie=bigp@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-jim=work@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php