Author Topic: compacting: database error, database archivisation freezing program  (Read 2296 times)

0 Members and 1 Guest are viewing this topic.

Offline zlotowinfo

  • Jr. Member
  • **
  • Posts: 55
  • Country: 00
    • Start Page
compacting database:
always with error

database archivisation:
freezing program & archivised file has half size

must archivising by myself

version v 0.95.12 build #23047 (19a91f4807) x64
« Last Edit: 30 05 2020, 19:28:43 by zlotowinfo »
start with: https://go.oga.pl
advertise: https://oga.pl
buy Tibia gold: https://zasms.pl
trade Tibia gold: https://tibiawt.pl
 

Offline ghazan

The preferrable variant is to restore the most recent database backup that could be compacted. If you don't have one, I'd recommend you to create a new profile & export the old one completely into it using service mode. To do that specify Import as the service plugin in the profile creation dialog:
« Last Edit: 03 06 2020, 08:08:17 by ghazan »
 

Offline zlotowinfo

  • Jr. Member
  • **
  • Posts: 55
  • Country: 00
    • Start Page
Its helped, but archive still too big.
I removed from history all except last year but archive still 15MB


Now deleted almost all messages & still 12MB
« Last Edit: 03 06 2020, 11:24:58 by zlotowinfo »
start with: https://go.oga.pl
advertise: https://oga.pl
buy Tibia gold: https://zasms.pl
trade Tibia gold: https://tibiawt.pl
 

Offline ghazan

zlotowinfo,
There's such thing like granularity, i.e. the amount of disk allocated for each table in a profile. Right now it's set to 2MB, so if there's one record, you get a profile of 2MB length. More records in another tables - more slices 2MB each.
 

Offline zlotowinfo

  • Jr. Member
  • **
  • Posts: 55
  • Country: 00
    • Start Page
I think you trying to tell me about constants size of each record in database.

Is there posibility to clean up contacts without messages?
« Last Edit: 03 06 2020, 13:29:22 by zlotowinfo »
start with: https://go.oga.pl
advertise: https://oga.pl
buy Tibia gold: https://zasms.pl
trade Tibia gold: https://tibiawt.pl
 

Offline ghazan

zlotowinfo,
no, that's not about record size, that's a space segment aka slice which is filled further with pages of data or indexes.
there're six segments in each profile