Not all statistics are loading correctly or very slow. We did a upgrade from 1.4.3 to 1.7.3 and the develop server with xibo has only one client where it can collect statistics from. All other clients are not connected because of the database copy.
This enviroment is running for two weeks now.
Bandwidth is working perfect en loads instantly
Availability is loading very slow and doesnt show any data when finnished
Statistics is loading very slow but do show data
Have you got your maintenance script setup and running? It sounds like perhaps you’ve got months worth of stats stored in the database? They should be being purged every month or so (depending on what you’ve configured) otherwise the database will grind to a crawl as you’re experiencing
Thank you for getting back to me. You are right that we never did run a maintenance job and it looks like thats the cause.
I did run the maintenance job a couple of times now with the same results below and the mysql deamon is very busy when it runs. But still is load very slow and have no data result on availabilty. Tidy Stats is not given the Done. message.
Maybe a time-out is involved while cleaning? Mysql process calms down after 1 or 2 minutes after the result below. Is it also possible to clear all the data manual before 30 days by query? Or clear all stats if nessecary?
You can delete all stats easily. Run the following SQL on the database:
truncate stat;
That will clear all statistics records out. Alternatively you could construct a query to delete only records older than a certain date, but that’s exactly what the maintenance script is doing under the hood.