Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
Re: DB growing even when deleting tables/indeces
From: Michael Ruf (michael.rufinxmail.de)
Date: Tue Aug 30 2005 - 05:02:53 CDT
when i execute sql_recreateindex in dbmcli i got following error:
-24988,ERR_SQL: sql error
100,Row not found
With DBMGUI i got an ErrorDialog "0"
No errors are shown in krnldiag or krnldiag.err
Am Dienstag, 30. August 2005 10:48 schrieb Kittel, Martin:
> 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,
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb