Xibo

Our webhost complaining about our table "log", to much traffic

Asked by Marcus Hultqvist

Hi!

We have got some complains from our webhost provider that in some of ours databses the table "log" is transfering to much traffic and is getting to big.

I know i can disable this by untick a setting on every screen, but our screens is not near us so we cant just visit every screen.

I know what is sended to this table, and we dont need to have it actually.

Can it be anny errors of some kind if we just delete this specific table in our databases? This would be a much simplier solution for us to solve theese complains from our provider.

Question information

Language:
English Edit question
Status:
Answered
For:
Xibo Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Alex Harrington (alexharrington) said : 		#1

Hi Marcus

In normal operation very little should be going to the table.

If you've enabled auditing in the clients then you need to turn that off.
It's only there for use when debugging specific situations.

Deleting the log table will cause problems.

You can run the maintenance script to clear out old log records.

Check that you don't have your server in test mode - it must be run in
production mode

Revision history for this message
Marcus Hultqvist (tulken-hultan) said : 		#2

I think it was a "miss " from my other collegues to not untick that.

So, we cant do it form our office with acces to the database och the admin ui then?

And yes, i know why the log is being filled up, some of the screen is on a very unstable network so thats why the log is filling up so fast, but the screents work great.

Here are a picture of the "eror" settings in the admin ui: http://i.imgur.com/ukrJ8nH.png

Revision history for this message
Alex Harrington (alexharrington) said : 		#3

Hi

Audit is disabled by default so they'd need to be manually ticking it.

Check in the Display settings you don't have audit enabled on an individual
display.

Other than that the next step would be to see what exactly is being logged?

Revision history for this message
Alex Harrington (alexharrington) said : 		#4

That's the display settings in the CMS

Failing that, what is actually going in the log table?

Can you help with this problem?

Provide an answer of your own, or ask Marcus Hultqvist for more information if necessary.

To post a message you must log in.