Long running queries at the search

pkp / pkp-lib

The library used by PKP's applications OJS, OMP and OPS, open source software for scholarly publishing.

https://pkp.sfu.ca

GNU General Public License v3.0

297 stars 443 forks source link

Long running queries at the search #9829

Open jonasraoni opened 5 months ago

jonasraoni commented 5 months ago

Describe the bug When searching for a single keyword in a large journal, the HTTP server often timeouts, while the database keeps processing the query for minutes.

Database: MySQL 8.3 + SSDK disk + ~4GB RAM allocated based on settings from https://github.com/major/MySQLTuner-perl

Row counts: submissions = 9K submission_search_keyword_list = 542K submission_search_objects = 69K submission_search_object_keywords = 18M

What application are you using? OJS 3.4

jonasraoni commented 5 months ago

@asmecher can you take a look on the PR below?

https://github.com/pkp/ojs/pull/4224

asmecher commented 2 months ago

With apologies for the delay -- I've added a comment on the PR.