-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi, ...I have a quite critical problem and didn't find anything on mysql.com or via google :-( Maybe someone here has some hints for me? 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