Also, use "myisamchk -dv tablename" Pay attention to datafile pointer (bytes) and Keyfile pointer (bytes) and the Max keyfile/datafile length. The keyfile pointer must be at least 4 bytes for a large table, if it says 3 you have a problem!
This is isn't clear from the CREATE TABLE section of the manual, but is in the "1.2.4 How Big Can MySQL Tables Be?". I don't know if there is any problem or change like this need for InnoDB, since Innodb is not mentioned I would suspect it is not needed. Ken ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Ken Menzel" <[EMAIL PROTECTED]> Cc: "Jocelyn Fournier" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 8:00 PM Subject: Re: How to index a large table? > 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
