OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
RE: DB growing even when deleting tables/indeces

From: Kittel, Martin (martin.kittelsap.com)
Date: Tue Aug 30 2005 - 03:48:05 CDT

Hi Michael,

>Is there any possibility to run some kind of compaction/repair
>which will
>delete this unused space. I've tried allready the DB check,
>which failed with
>-9041 Index not accessible.

you have bad/broken indices in your database. You should try and
recreate them using either dbmgui or 'sql_recreateindex' in dbmcli.
Once you do not have bad indices any more, a database structure check
will free unused pages.

Best wishes,

Martin.

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb