Topic: The status sweep on Firebird 2.5.2
Windows Server 2008 R2, Firebird 2.5.2 SuperClassic.
There is a database in the size of 355 Gb. On Friday on August, 3rd has been launched manual sweep in the evening. Two days parallely with sweep' the database worked on reading with enough considerable quantity of users. Since yesterday evening works in an exclusive mode.
If I am not mistaken, in 2.5.2 about sweep the beginning and the end is written to a broad gull only. I try to estimate approximate progress to indirect signs. In MON$IO_STATS found the data on launched gfix-sweep, and there was a following question.
So, a DB - 355 Gb (the exact size - 355 359 793 152). Page size - 8192 byte. That is in basis should be 43 378 881 pages. The same number can be seen in MON$PAGES in table MON$DATABASE.
MON$IO_STATS On gfix' with shows MON$PAGE_READS 254 000 000 (approximated) pages. That is gfix-sweep read much more pages, than contains in a database. fb_lock_print shows the big activity. Whether it is normal, what MON$PAGE_READS for process shows such great number of pages and whether it means, what went in cycles and for any reason reads basis many times successively empty?
Many thanks in advance.