0029292: High database load caused by a LiveVoting select query

[fluxdw]

@kzimmermannfhms (aus Mantis verschoben)

Since about 1 hour, we are observing a unusually high server load on the Mariadb machine. The general response times of ILIAS is satisfactory, but a bit slower than usual. Not many users are logged in.

An investigation with Jet Profiler indicates that the server is busy with a lot of these queries (see attached screenshot):
SELECT rep_robj_xlvo_config_n.* FROM rep_robj_xlvo_config_n WHERE rep_robj_xlvo_config_n.pin = 'ILVM'

Is it possible to optimize the query and thus improve the performance?

Additional info: today we have same behaviour again.
There are many slow queries, all of them like this:
SELECT rep_robj_xlvo_config_n.* FROM rep_robj_xlvo_config_n WHERE rep_robj_xlvo_config_n.pin = 'UCKV'