OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: 16-Page Database Table Limit?

From: Dan Nelson (dnelsonallantgroup.com)
Date: Fri Jul 02 2004 - 21:13:38 CDT

In the last episode (Jul 02), David Blomstrom said:
> Rhino <rhino1sympatico.ca> wrote:
> > 2. What happens when you do 'select count(*)' on your new table?
>
> I'm not familiar with that command. If I type select count (*) into
> the "query" box on phpMyAdmin, it says count(*) = 0 Or is this a type
> of table query I do on my webpage?

First thing to try is a direct connection to mysql via the commandline
client. Don't use phpmyadmin to troubleshoot problems, unless you're
trying to debug phpmyadmin itself.

> I didn't realize there was a problem until today. At first, I was
> struck by the fact that MySQL can somehow squeeze 3,000 rows into 16
> pages!

Are you talking about 16 disk pages? That's reasonable, if your
records average 40 bytes in length and you have 8k disk blocks.

--
        Dan Nelson
        dnelsonallantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql