QueueMetrics > MySQL storage and Qloaderd/Uniloader

MySQL performance issues

<< < (3/3)

tsolaaa:
UPDATE:

We ran


--- Code: --- ALTER TABLE `queue_log` ORDER BY `time_id`
--- End code ---

Again, and it seemed to fix the problem. We currently set up a cron job to have this run twice a month.

Will update to see if this completely revolves the issue.

QueueMetrics:
It is weird that this happens - it is not supposed to since data is insert-only. Or do you have processes that edit/update that table?

Navigation

[0] Message Index

[*] Previous page

Go to full version