Hi Dan,
On 20/09/2024 15:18, Dan Pritts wrote:
Sorry for the late reply
We identified a problem with a similar old fuseki version. Using the
internal backup mechanism caused fuseki to slow down drastically and
take down our website, usually ending in us restarting.
Which version?
And is it a TDB1 database?
Andy
We disabled the fuseki internal backups and instead make Linux lvm
snapshots of the database and back it up via tdbdump.
We restart fuseki as part of the process to ensure a consistent
database. That’s fast enough that we just live with the outage.
Sent from Phone, apologies for typos and/or brevity
On Thu, Sep 5, 2024 at 8:08 AM Hugo Mills
<[email protected]> wrote:
Hi, all,
We’ve got a heavily-used webapp backed by Fuseki, and we’re having
issues with the load on the Fuseki server. It frequently heads
into a storm of high load average, with the CPU usage pegged at
600% (on 6 cores), and then the app grinds to a halt and we have
to restart the database. We’re trying to understand why this is
happening. Is there the ability in Fuseki to get a list of the
currently-running queries at any given point in time, including
the query text itself, and preferably also the amount of time each
one has been running for?
We’re running Fuseki from Jena 3.4.0, if that makes a difference
to the answer.
Thanks,
Hugo.
Hugo Mills
Development Team Leader
agrimetrics.co.uk <https://www.agrimetrics.co.uk/>
Reading Enterprise Centre, Whiteknights Road, Reading, UK, RG6 6BU
<https://www.linkedin.com/company/agrimetrics/>
<https://x.com/agrimetrics?s=21&t=h8BsEr4MroKUB8051AMAdA>
