about log limit

[arisgamers]

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

is there any limitation for log files?

 

[Dastgir]

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]

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

 

[Dastgir]

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]

ok, thanks

 

[Dastgir]

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]

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

solved, thanks

 

[jaBote]

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.