Notifications table in Database

Software Support
1

Hi, trying to migrate my database on another server I found that the notifications table is hudge (about 2.5 mo)
How can i clean it ? via admin or phpmysql ?
thanks a lot for help
G

2

Hi @ruegama,

You can remove notifications via phpMyAdmin or similar by executing…

DELETE FROM notifications;
DELETE FROM notification_settings;

Off the top of my head, I don’t think removing these will have any negative impacts, beyond obviously the notifications themselves being gone.

Regards,
Alec Smecher
Public Knowledge Project Team

3

hello and thanks for your answer.
I cleaned manually the table, sorting it by date…

4

Hi @ruegama,

Could you post that question as a new topic, as it’s not related to this thread? That’ll help keep the forum organized.

Regards,
Alec Smecher
Public Knowledge Project Team

5

Hi, I am having the same problem, can I erase all the content of those tables (year < 2016) and i will no have problems? right now notifications has a size of 1GB and i can’t even have a backup

6

Hi @maguilar,

You should be able to remove all contents of notifications and notification_settings without side-effects (beyond, of course, all notifications being removed).

Regards,
Alec Smecher
Public Knowledge Project Team

7

Thanks a lot. I am promoving the use of OJS in honduras :smiley:

1 Like
8

Hi @asmecher ,
We were facing the notification loading issue. i think the notifications were overloaded, I clear all the notification through this command ```
DELETE FROM notifications;
DELETE FROM notification_settings;

the problem solved thank you so much