|
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: Michael Ruf (michael.ruf
inxmail.de)
Date: Tue Aug 30 2005 - 05:02:53 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi Martin,
when i execute sql_recreateindex in dbmcli i got following error:
ERR
-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
regards
Michael
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,
>
> Martin.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]