-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi,
On Wednesday 05 March 2003 16:05, Johannes Ullrich wrote: > 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. What's the limit for an index file? Since we install quite a few databases at customer sites, it would be good to know the limitations of mysql... ...and is it true - when deleting from a table, the INDEX file stays the same size? do i need to do an "repair table"? Thanks for any response, Andy - -- [EMAIL PROTECTED] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+aERmRrny/uOBVy4RApvGAKCvwT9pACYsJgqkKDG3gaQnmb3XKgCgj1qA hl0qyQbNHl7tpFXpMsdYQwE= =V7s1 -----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
