sql,query
At 18:45 -0500 10/22/02, [EMAIL PROTECTED] wrote:
Indeed, setting MAX_ROWS lets me create the index. Thanks for the tip.
How would I find out what the MAX_ROWS setting on a table is?
SHOW CREATE TABLE tbl_name;
or
SHOW TABLE STATUS LIKE 'tbl_name';
----- Original Message -----
From: Ken Menzel <[EMAIL PROTECTED]>
Date: Tuesday, October 22, 2002 4:05 pm
Subject: Re: How to index a large table?
Just curious Chris, did you set MAX_ROWS option during table create
to a really large value? If not alter the the table with this and try
again, it affects the size of pointers used to create the index.
(See CREATE TABLE in the manual)
Hope it helps,
> Ken
---------------------------------------------------------------------
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
