Hi,
I found a discussion about the index file not being able to be RAIDed, and
know that the OS Limit will apply in any case, but this is Solaris 8, so
that isn't a problem, but can't find anything that explicitly states it.
Even SHOW TABLE STATUS:
mysql> show table status like 'tt_tickets'\G
*************************** 1. row ***************************
Name: tt_tickets
Type: MyISAM
Row_format: Dynamic
Rows: 176206
Avg_row_length: 38
Data_length: 6713540
Max_data_length: 1099511627775
Index_length: 4264960
Data_free: 0
Auto_increment: NULL
Create_time: 2001-10-02 11:06:03
Update_time: 2001-10-31 15:53:03
Check_time: 2001-10-02 11:08:10
Create_options: max_rows=4294967295 pack_keys=1
Comment:
1 row in set (0.03 sec)
Shows "Max_data_length" - does the same limit apply to the index?
Quentin
-----Original Message-----
From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 3 November 2001 11:47 p.m.
To: Quentin Bennett
Subject: RE: Quick Question - quick reply please!
I seem to remember some discussion about this,
and that the index *is* subject to filesystem limits
i.e., it can't be split.
It has been discussed rather extensively at some
time in the near past; check the list archives.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
> -----Original Message-----
> From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 03, 2001 10:28 AM
> To: MySQL (E-mail)
> Subject: Quick Question - quick reply please!
>
>
> Hi,
>
> Assuming that a 'table' has been defined with MAX_ROWS high
> enough to allow
> the table to be > 4Gbytes, does the same size limit apply to the index as
> the data file, or is the index file subject to a different limit?
>
> Thanks for a speedy response
>
> Quentin Bennett
> Transport Systems Division
> Infinity Solutions
> www: http://www.infinity.co.nz
> mailto:[EMAIL PROTECTED]
> Phone: +64 9 358 9720
> Fax: +64 9 309 4142
>
>
> The information contained in this email is privileged and confidential
> and intended for the addressee only. If you are not the intended
> recipient, you are asked to respect that confidentiality and not
> disclose, copy or make use of its contents. If received in error
> you are asked to destroy this email and contact the sender immediately.
> Your assistance is appreciated.
>
> ---------------------------------------------------------------------
> 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
>
>
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
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
