Xibo

"STAT" ?

Asked by Cleidimar Viana

What STAT to the database? What does?

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
Cleidimar Viana
Solved:
Last query:
Last reply:
Revision history for this message
Dan Garner (dangarner) said : 		#1

I'm not completely sure what you mean...

If you are talking about the "stat" table in the database then this table records when the client plays media and layouts. The client will periodically send its information back to your server install.

Currently we do not expose this information anywhere in the web interface but there is a blueprint here: https://blueprints.launchpad.net/xibo/+spec/display-statistics to do something with them.

Cheers,
Dan

Revision history for this message
Cleidimar Viana (cleidimarviana) said : 		#2

It is because my table is growing very fast in 2 weeks already with 400,000 records. This is correct?

Revision history for this message
Dan Garner (dangarner) said : 		#3

I guess you have a lot of activity - how many displays are you running?

You can disable stats on each client by going into the "Xibo Options" program and un-checking the "enable statistics" option and saving. You may want to do this as we do not currently show the stats anywhere.

I did think that eventually there would be a process that occurs daily which would summarise all the stats and truncate the stat table - but this is not implemented!

Feel free to truncate that table.

Cheers,
Dan

Revision history for this message
Cleidimar Viana (cleidimarviana) said : 		#4

Thank you. I found here, is disabled. I was watching enable advantage to be. Therefore increasingly a file grows non-necessary.