Hi John, your observation is absolut right. If you drop a table this will be done asynchronous by a server task. First the file directory of the correspondig file will be removed and then the b*tree is released. If you shutdown the dabase before this operation is finished you have unreferenced pages in your data area. The only way to remove them is:
bring the database in state cold resp. admin and execute one of the following commands: in 7.3: dbmcli -d .. -u .. util_execute verify in 7.4: dbmcli -d .. -u .. util_execute check data with update Regards, Torsten SAP DB, SAP Labs Berlin -----Original Message----- From: Gembus, John [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 4. Dezember 2003 16:44 To: '[EMAIL PROTECTED]' Subject: The number of data pages is increasing extraordinarily Hello, some days ago i posted a mail, because my number of pages are increasing. Now i can reproduce the problem. 1. starting database 2. drop table 3. create table 4. dataload ( 270.000 items ) during this process i watch the statistic in dbmgui. The pages after the drop table don't become free. After the dataload is finished the database works a lot and sets the pages step by step free. When i shutdown the computer before this process has stopped these old-pages becomes permanent data. So my database grows. number of pages start 13723 drop table 13723 dataload start increases dataload stop 17500 the database works 13723 Any Ideas what to do ? - I'd like to know, how to stop this situation - Is it possible to free the pages . I looked for a way to reorg the database. I think the pages a marked as old. How can i identify them John -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
