Xibo

stat mysql table of 600 MB!!!

Asked by Mauro Cioffi

debug and audit of, production mode.
server 1.6.0

continuous warnings and about 600 mb of stat table of mysql db.

at least is possible to manually empty the stats table?

i set MAINTENANCE_STAT_MAXAGE from 30 to 1......this will empty partially the stats table?

i've reached the max disk space for mysql on the server!

thanks

Question information

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

You need to setup the maintenance script to run on your system to tidy old
logs and stats. It's in the manual

Revision history for this message
Mauro Cioffi (mauro-cioffi-2) said : 		#2

I run the maintenance scpript,
The result is tidy logs and stats done.....

But the mysql db, table stat is the same size.....no records deleted....
Whats wrong!?

Thanks

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

It will only delete statistics older than the configured value. MySQL may
not make the file any smaller even though the records have been deleted.
Please confirm that the number of rows in the database reduced.

You also need to ensure that the maintenance script is run regularly, eg
every 5 minutes

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

Would also be worth looking at this:

http://incomservice.net/icsblog/2011/software/decrease-mysql-database-size-after-deleting-records.html

Revision history for this message
Mauro Cioffi (mauro-cioffi-2) said : 		#5

Thanks!