EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #10127

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

Re: [EP-tech] DDoS of EPrints advanced search

CAUTION: This e-mail originated outside the University of Southampton.

Hi John,

in addition to that we also experience apparently regular race
conditions between selecting from and dropping cache tables, that may
lock database access which has actually happened quite often. After
killing the mysql process that runs for a long time (`mysql> show full
processlist;`), all waiting requests will be processed.


Kind regards
Florian

Am 30.05.25 um 15:39 schrieb John Salter:

I added a script to my server to log the number of search cache tables, and the min/max IDs of them for each hour.
I plan to use this to redirect requests with 'old' cache ids in the query-string to a static page, which will describe (to a human) how to re-run their search, but not provide a clickable link to do so.
If others are also seeing this pattern, I can share my stuff once it's ready.