You, like me, are using 3.22 which does not have the myisam table type 
(or others for that matter).  ISAM I believe, has a lower limit.  They do 
support sizes less that 4GB (up to the OS file size limits). The three 
file extentions total do constitute the total table size, but I believe 
that each file must fall under the 4GB limit, not the total.  isamchk is 
the equivalent to myisamchk for ISAM table types.  

On Fri, 22 Feb 2002, Brian Warn wrote:

> Date: Fri, 22 Feb 2002 09:11:07 -0800
> From: Brian Warn <[EMAIL PROTECTED]>
> To: 'Gurhan Ozen' <[EMAIL PROTECTED]>,
>     'MySQL List' <[EMAIL PROTECTED]>
> Subject: RE: 3.22.32: max table size
> 
> I did see that reference, but found that myisamchk wasn't an option
> either.  I did find isamchk is available and have been seeing what
> information it is able to provide.  I'm wondering now whether summing
> the table.ISD, table.ISM, and table.frm filesizes that I get from a
> simple ls -l output will give me the total diskspace occupied by the
> table?
> 
> Brian
> sql,query
> 
> -----Original Message-----
> From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, February 22, 2002 8:58 AM
> To: Brian Warn; 'MySQL List'
> Subject: RE: 3.22.32: max table size
> 
> 
> Quoted from http://www.mysql.com/doc/T/a/Table_size.html is:
> 
> "By default, MySQL tables have a maximum size of about 4G. You can check
> the maximum table size for a table with the SHOW TABLE STATUS command or
> with the myisamchk -dv table_name. See section 4.5.6 SHOW Syntax. "
> 
> Gurhan
> 
> -----Original Message-----
> From: Brian Warn [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 22, 2002 11:28 AM
> To: 'MySQL List'
> Subject: 3.22.32: max table size
> 
> 
> As show table status doesn't appear to be supported in this older
> version I'm using, how did you who used this version get max table size
> information? I haven't been to find anything from the list
> archives/manual about this.
> 
> Brian
> sql,query
> 
> ---------------------------------------------------------------------
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to