What is the size of the text field you're fulltext indexing? How often is that index used? You might be best off to create a table containing only that column and a PK that is equal to the PK in the original table. You might also keep a portion of the text field (say 50 characters) in the original table, for head-first indexing.
Arthur On Tue, Mar 25, 2008 at 9:56 AM, J. Christian Hesketh <[EMAIL PROTECTED]> wrote: > Hi, > I have created a rather large table containing about 16M records. Most > of the indexed fields are smallint, but there is one field that is a > text field that I am using fulltext indexing on. The total size of the > smallint indexes is only about 30 MB, but the fulltext index brings > the total index size to about 2 GB. My question is: When mysql adds > indexes to the keycache, does it add each index individually or does > it dump the entire .MYI file to the keycache. If it is the latter, I > should move the fulltext index to another table. > Thanks in advance, > Christian > > -- > J. Christian Hesketh M.Sc. > CEO - Ion Channel Media Group > 2028 Harvard Avenue, Suite 103 > Montreal, QC > CANADA H4A 2V9 > > Tel: +1(514)245-8107 > > http://www.IonChannelMedia.com <http://www.ionchannelmedia.com/> > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
