phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Get Involved
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
User avatar
ouiouiphoto
Registered User
Posts: 91
Joined: Mon Jun 15, 2015 5:30 am
Contact:

phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by ouiouiphoto »

Dear All

I have to free space in my dabase that reach my provider limit. I have see a table phpbb_notifications with 30000 Rows and a total size of 10Mb. I assume this is the notification send to users. In ACP i have limit this to 10 Days but the size does not change. Any idea tu reduce this table is welcome ;)

Thanks
User avatar
david63
Registered User
Posts: 20646
Joined: Thu Dec 19, 2002 8:08 am

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by david63 »

I am guessing that you (or at least your users) have a lot of unread notifications. If that is the case then there is nothing within the core to mark them read (sounds like the need for an extension to do that).

All I can think of is to run an sql query to mark them read (probably using a date so that new ones are not marked) and then they should roll out.
David
Remember: You only know what you know and - you don't know what you don't know!

I now no longer support any of my extensions but they will start to become available here
User avatar
ouiouiphoto
Registered User
Posts: 91
Joined: Mon Jun 15, 2015 5:30 am
Contact:

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by ouiouiphoto »

Thanks for this idea. I have 25514 lignes unread for a total of 27 492 lignes. I can probably pass the oldest ones to read
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by stevemaury »

If 10 MB of database space is critical, you need a new host.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
ouiouiphoto
Registered User
Posts: 91
Joined: Mon Jun 15, 2015 5:30 am
Contact:

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by ouiouiphoto »

You are right. I need a bigger database but in the meanwhile i just need some free space to be able to change my database not in a rush ;)
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by janus_zonstraal »

What search index are you using?
Sorry! My English is bat ;) !!!
User avatar
ouiouiphoto
Registered User
Posts: 91
Joined: Mon Jun 15, 2015 5:30 am
Contact:

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by ouiouiphoto »

janus_zonstraal wrote: Mon Apr 16, 2018 5:00 pm What search index are you using?
"Mysql full text" as far as i understand your question ;)
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by janus_zonstraal »

Ok that will not help you much to free some space.
Sorry! My English is bat ;) !!!
Locked

Return to “[3.1.x] Support Forum”