Re: Fwd: how to handle a 10GB index-file?

2003-03-07 Thread Andreas Bourges
-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?

Fwd: how to handle a 10GB index-file?

2003-03-05 Thread Andreas Bourges
-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