gi_debugger_entry table is Too Big

Moderator: crythias

Locked
daguilar
Znuny newbie
Posts: 24
Joined: 16 Jul 2014, 11:55
Znuny Version: 4.0.7
Real Name: Dani

gi_debugger_entry table is Too Big

Post by daguilar »

Hello.

I'having problems with database size ins mysql. current size is 10GB, and I watch that there is a table gi_debugger_entry table 5GB more or less.

Is It possible truncate this table? any problem produced if I do this?

Could I do any other action to reduce database size?

I'm working with OTRS 3.5 and mysql

thanks
wurzel
Znuny guru
Posts: 3273
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: gi_debugger_entry table is Too Big

Post by wurzel »

Hi,

check this, here are some examples to reduce database size.
http://otrs.github.io/doc/manual/admin/ ... uning.html

I can not tell you, if you can truncate this table, without issues. I do not work with Generic Interface.

Flo
OTRS 2025 SILVER (Prod)
OTRS 2025 auf Debian 12 (Test)
Znuny 7.x latest version testing auf Debian 12

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: gi_debugger_entry table is Too Big

Post by crythias »

An option:

Admin
Web Services
Pick a web service
Debugger
Clear

Your data is your responsibility. Not responsible for "Oh, I really wanted that". Make a backup first if you think it's important.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
EXG133
Znuny expert
Posts: 217
Joined: 06 Aug 2012, 18:12
Znuny Version: 3.1.7 & 4.04

Re: gi_debugger_entry table is Too Big

Post by EXG133 »

crythias wrote:An option:

Admin
Web Services
Pick a web service
Debugger
Clear

Your data is your responsibility. Not responsible for "Oh, I really wanted that". Make a backup first if you think it's important.
Speaking from experience this can take a LONG time so be patient.

@ daguilar : You might want to change your webservice log level from 'debug' to 'error'. If it's already set to 'error' you need to question whoever is invoking your webservice :)
Locked