QueueMetrics > MySQL storage and Qloaderd/Uniloader

database maintenance

<< < (2/2)

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! :)

Navigation

[0] Message Index

[*] Previous page