about log limit

[arisgamers 6]

how big our log (charlog, loginlog, etc; which are read only) can be?

is there any limitation for log files?

[Dastgir 1246]

how big our log (charlog, loginlog, etc; which are read only) can be?

is there any limitation for log files?

It can be as big as your hard disk capacity (i.e until your hd space runs out)

P.S: Those tables are not read only, server writes in it too.

[arisgamers 6]

do it have any self control (auto delete old row)?

[Dastgir 1246]

do it have any self control (auto delete old row)?

It doesn't do that, You might have to setup external scripts for that.

[arisgamers 6]

ok, thanks

[Dastgir 1246]

Some SQL Query to help:

Delete atcommandlog and other logs older than 1 month: (2592000 = (60sec*60min*24hours*30days))

 

DELETE FROM `atcommandlog` WHERE UNIX_TIMESTAMP(`atcommand_date`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `picklog` WHERE UNIX_TIMESTAMP(`time`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `zenylog` WHERE UNIX_TIMESTAMP(`time`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `branchlog` WHERE UNIX_TIMESTAMP(`branch_date`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `mvplog` WHERE UNIX_TIMESTAMP(`mvp_date`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `npclog` WHERE UNIX_TIMESTAMP(`npc_date`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `chatlog` WHERE UNIX_TIMESTAMP(`time`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `loginlog` WHERE UNIX_TIMESTAMP(`time`)<(UNIX_TIMESTAMP(NOW())-2592000); 

[arisgamers 6]

those table don't have primary key, can not be edited

 

solved, thanks

Edited May 27, 2014 by arisgamers

[jaBote 438]

They sure have all primary keys as you can see on sql-files/logs.sql. And in case they hadn't they could still be edited, but just not as efficiently as if they had.

 

Dastgir's queries seem fine to me.