/tools/metrics-prometheus blocks other http requests

27 views
Skip to first unread message

Cyril Oblikov

unread,
Mar 26, 2020, 11:18:03 AM3/26/20
to Orthanc Users

Using mysql plugin for index and S3 for storage.
6M entries in Resources table.

GET /tools/metrics-prometheus does some heavy sql requests such as:
SELECT CAST(COALESCE(SUM(uncompressedSize), 0) AS UNSIGNED INTEGER) FROM AttachedFiles

All other Orthanc rest api requests freeze until metrics collection finishes.

Sébastien Jodogne

unread,
Mar 30, 2020, 11:24:07 AM3/30/20
to Orthanc Users
Hello,

This is known limitation, as the MySQL plugin is not designed for speed right now. There are other pending changes related to performance in the mainline:

If your focus is on performance, please switch to PostgreSQL, as explained in the Orthanc Book:

Sébastien-
Reply all
Reply to author
Forward
0 new messages