• Networking: The investigation is still on the way, we've switched to backup telecom carriers since the episode but we're still working in settling everything as it must be. We'll add more updates as we have them available. Incoming and outgoing emails will be restricted, and user registration has been disabled until the issue is resolved.

kal_DB size problem ...

Newbie Spellweaver
Joined
Feb 28, 2006
Messages
65
Reaction score
3
Location
i dno
as our server is online for a long time, we got a problem ...
we got a kal_auth file of 63MB ==> a lot of accounts and all
but our kal_db size is going up too damn fast, we allready reached 28GB...server is starting to lag lately too, can anyone tell me how to fix this and make the DB smaller again, cuz this cant rly go on like this...
 
If your drop rate is high, the size will go up. Every item is saved in the database. Destroyed or not. Once it's picked up from a monster or NPC then it exists in the database.
 
Upvote 0
lol i know why the problem is caused, but i was asking for a solution, for example somehow delete all deleted items? something like that ...


EDIT : i'm running the server on a dual core CPU and still both always at 60-100% in use :-/
 
Upvote 0
Code:
backup log KAL_DB with truncate_only
DBCC SHRINKFILE(KAL_DB_Log,100, TRUNCATEONLY)

Code:
backup log KAL_AUTH with truncate_only
DBCC SHRINKFILE(KAL_AUTH_Log,100, TRUNCATEONLY)

The 100 is MB .. hf
 
Upvote 0
If your drop rate is high, the size will go up. Every item is saved in the database. Destroyed or not. Once it's picked up from a monster or NPC then it exists in the database.
Yep, kal got ZERO cleaning rutines.

I'm working on some ideas to solve it , but at the current moment I could just recomend you to try and do some manual cleaning.
 
Upvote 0
Back