database maintenance

[mwood]

Are there any tools included with queuemetrics to allow archiving of records? Our database is getting pretty big and we really need to offload old data in order to maintain enough room on the system for current data.

Thanks

[marcos]

Hi,

No. We don't provide any external tool able to archive old database logs.
What I can suggest is to move and/or drop the queue_log and qa_data tables through any sort of MySQL administration tool.
The qa_data contains information related to QA activities so it could be empty if you don't use this feature.

Thank you and regards,
Marco.

[mwood]

Can you recommend an adequate utility please. Also this would be good feature to add. Some sort of record archiving is standard in most ACD reporting packages.

Thanks
M Wood

[QueueMetrics]

Usually there is no need to do it, as the table is actually "cluster-indexed" - so even if it is very very large, its access performance does not change much.

[mwood]

We have hard drive constraints driving this need, so we need to trim the database.

[QueueMetrics]

OK in this case decide a timestamp and delete from the queue_log table all records that are below a certain point. Or better, make a complete table dump first (maybe from a  different server) and then do the deletion.


There are a number of online services that translate a date to a timestamp and vice-versa.


 

[mwood]

so is this correct?

DELETE FROM queue_log WHERE time_id < "timestamp of oldest desired record"

and then rebuild the indexes

[QueueMetrics]

Yes.
Make a backup first!