Notifications is killing certain sections of my forum

DSR! · Post by **DSR!** » Mon Aug 02, 2021 6:24 am

I manage a very old community with many users and themes which runs in a vps with everything updated and well configured.
But ... for some time now users are experiencing random mysql crashes.
Today after several tests I recognized the problem.
Sections with many subscribed users cause mysql to fail.
I listen to ideas to solve it

From what I understand the calls to $phpbb_notifications->add_notifications() run the notifications immediately ...?
When experiencing this error I assume that notifications do not depend on cron.
If so, it would be a good idea to pass some logic to a cron.

DSR! · Post by **DSR!** » Mon Aug 02, 2021 4:31 pm

fixed adding new hook event
https://github.com/phpbb/phpbb/pull/6257

david63 · Post by **david63** » Mon Aug 02, 2021 4:45 pm

How is adding an event going to fix the problem unless you create an extension?

DSR! · Post by **DSR!** » Mon Aug 02, 2021 5:53 pm

Tonight I do the development of the extension.
If they accept the pr I send the extension to customize db

bakasura · Post by **bakasura** » Tue Aug 15, 2023 4:14 pm

DSR!, could you tell us if this problem solved?