PS_GameLog_Data Doubts, Help

05/11/2018 20:21 trysten#1

I noticed that PS_GameLog_Data over time is becoming a gigantic file. greater than 10GB. I would like to know without some way to clean the logs without affecting the server's functions and configurations. because it is consuming a lot of space on my machine. Someone can help in this part.
Sorry my english google translator

05/11/2018 23:29 XareL#2

idk but if u want clear logs execute this query ;

DELETE FROM PS_GameLog.dbo.ActionLog ---- clear in game actions
DELETE FROM PS_ChatLog.dbo.ChatLog ----- clear in game chats

05/13/2018 14:14 [MXD]Takeshi#3

Quote:

Originally Posted by XareL

idk but if u want clear logs execute this query ;

DELETE FROM PS_GameLog.dbo.ActionLog ---- clear in game actions
DELETE FROM PS_ChatLog.dbo.ChatLog ----- clear in game chats

Hello, sorry but from delete you dont clear ur IDENTITY....
use this command for clear all...

Code:

TRUNCATE TABLE PS_GameLog.dbo.ActionLog
TRUNCATE TABLE PS_ChatLog.dbo.ChatLog

also you wanna clear all tables of database?
use this command...

Code:

USE PS_GameLog
EXEC sp_MSforeachtable 'TRUNCATE TABLE ?'

all table of ps_gamelog clear

05/13/2018 15:52 XareL#4

you may only need to delete certain tables, as some special databases may have plugins for ps_gamelog.

05/13/2018 20:18 [MXD]Takeshi#5

Quote:

Originally Posted by XareL

you may only need to delete certain tables, as some special databases may have plugins for ps_gamelog.

is right.... i has just add a few commands is possible that someone other need it :)
anyway i has understand that him need clear only data, just for clear use this command "TRUNCATE", for remove something use "DELETE"

05/13/2018 21:09 {Skrillex}#6

Hi,
i think you have to shrink your database too.

Regards

05/30/2018 08:28 trysten#7

Quote:
Originally Posted by [MXD]Takeshi
Hello, sorry but from delete you dont clear ur IDENTITY....
use this command for clear all...
Code:
TRUNCATE TABLE PS_GameLog.dbo.ActionLog
TRUNCATE TABLE PS_ChatLog.dbo.ChatLog
also you wanna clear all tables of database?
use this command...
Code:
USE PS_GameLog
EXEC sp_MSforeachtable 'TRUNCATE TABLE ?'
all table of ps_gamelog clear

I used all the procedure. I cleaned the tables of Ps_game_log still continues with + 10GB