Two solutions to your problem: table full errors: check the 'AVG_ROW_LENGTH' and 'MAX_ROWS' option for create and alter table. You can change these on the fly using 'alter table', but it will take quite a time for a table your size (few hours-1 day depending on machine).
The exact values for these parameters are not all that important. just make it large enough. Usually, you run into this limit around 4 Gig Byte, but maybe you already set these parameters and need to increase them. Check 'show table status' to verify the current value. To reduce the size of you index file: try a 'repair table'. The 'alter table' will take care of it too. You can also drop and recreate this index. Side note: look at merge tables... they look like a pain at first, but once you get used to it they are quite handy for tables your size. > The data file .MYD of a certain table has a size of 7.3 Gig and the > corresponding index file .MYI has a size of 10Gig. When deleting records from > this table - will the index file automaticly be stripped down? IF not - is > there a way to trim the index-file to use less space?!? > > BTW: how is the maximum size of a index file determined? yesterday, one of > our databases refused to insert more data into the table, because there was > no space left in the index-file (17GB) - but the filesystem had plenty of > space left (SOLARS 8). > > Is the any Documentation regarding this issue? > > thanks, > > Andy > > - -- > [EMAIL PROTECTED] > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (GNU/Linux) > > iD8DBQE+ZgGpRrny/uOBVy4RAsPZAJ9XI/OrOuhfwMGEnBpbvBkKHyTtngCghoqJ > KRQc0/zSIAnQQkAG+V0zOns= > =oi3/ > -----END PGP SIGNATURE----- > > > --------------------------------------------------------------------- > 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 > > -- -------------------------------------------------------------------- [EMAIL PROTECTED] Collaborative Intrusion Detection join http://www.dshield.org --------------------------------------------------------------------- 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
