QueueMetrics > MySQL storage and Qloaderd/Uniloader

database maintenance

(1/2) > >>

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.

Navigation

[0] Message Index

[#] Next page