A solution to keeping database size down?

Anything that doesn't fit anywhere else, and is NON CH related - chat about the weather, or anything else that takes your fancy.

Moderator: Moderators

User avatar
jtaylor
Forum Administrator
Posts: 1880
Joined: Sat Jun 05, 2004 12:32 am
Real Name: Julian Taylor
Location: Wantage, OXON
Contact:

A solution to keeping database size down?

Post by jtaylor »

Here's an idea - we could enable auto-pruning (sounds painful!) on the "General Chat - Non CH" section, which would automatically remove any topic which hasn't been accessed for any specified period - e.g. 3 months?.

We'd have to ensure that topics which need keeping are moved into appropriate sections, as if they merit keeping (as they have a specific relevence to CH or Old Blues) then they probably should be in another section?

Thoughts??

This is a simple thing to do, and doesn't require any work/time to implement....

J
Julian Taylor-Gadd
Leigh Hunt 1985-1992
Image
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
User avatar
Mrs C.
Button Grecian
Posts: 2300
Joined: Wed Feb 16, 2005 2:22 pm
Real Name: Janet Chandler
Location: C.H.

Post by Mrs C. »

sounds good to me!
( does that mean it should start working faster again??)
The best way to forget your troubles is to wear tight shoes.
User avatar
jtaylor
Forum Administrator
Posts: 1880
Joined: Sat Jun 05, 2004 12:32 am
Real Name: Julian Taylor
Location: Wantage, OXON
Contact:

Post by jtaylor »

Not sure about the speed thing - it's really slow at the moment, but yes it may make a difference.
Julian Taylor-Gadd
Leigh Hunt 1985-1992
Image
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
User avatar
Jude
Button Grecian
Posts: 1477
Joined: Wed Nov 16, 2005 7:21 pm
Real Name: Jude Comber nee Kelynack 5.38 1975-1980
Location: Stonehouse, Gloucestershire

Post by Jude »

It sounds like a good Idea Julian - especially the lines that double or triple up on the same subject! (I know we all tend to veer away from the topic a tad!) It might also be good if we let you know when a topic WE have started feels "complete" there are a couple I started, which I feel have run their life and could easilly be removed / archived etc...

Is everyone in agreement? It's not fair to make Julian or Simon deal with the topics and make those decisions - and if we create a topic then I feel in some way we are "responsible for it"

I think Keeping cool in the heatwave can go - as it will now be along the lines of how to stay warm in the winter!

:wink:
Jude Comber (nee Kelynack) 5's 5.38 1975-1980 Herts.
To Learn - read, to Know - write, to MASTER - Teach
Katharine
Button Grecian
Posts: 3285
Joined: Mon Dec 26, 2005 10:44 pm
Real Name: Katharine Dobson
Location: Gwynedd

Post by Katharine »

I like the idea of auto pruning in Non-CH after a three month (?) time. If that is easy for you it should be good for us as well.
Katharine Dobson (Hills) 6.14, 1959 - 1965
User avatar
jtaylor
Forum Administrator
Posts: 1880
Joined: Sat Jun 05, 2004 12:32 am
Real Name: Julian Taylor
Location: Wantage, OXON
Contact:

Post by jtaylor »

I've just enabled compression on the database - seems to have speeded it up for me? Same for everyone else???

Re. closing your own topics - there's been complaints before about topics being deleted which contain other people's comments, but at the request of the originator of the topic....not sure about this one....
Locking the topic is easy though....

J
Julian Taylor-Gadd
Leigh Hunt 1985-1992
Image
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
User avatar
Jude
Button Grecian
Posts: 1477
Joined: Wed Nov 16, 2005 7:21 pm
Real Name: Jude Comber nee Kelynack 5.38 1975-1980
Location: Stonehouse, Gloucestershire

Post by Jude »

Julian - here are my posts that are old and out of form now - these are just in the non ch area! :

GOT ME BUTTONS!!!!!!!!!!!!!!!!!
Shana Tova to you all!
Poll ] BBC - Going off the rails?????

I am NOT A GRANDMOTHER!!!
Help required - bed and board + pocket money

[ Poll ] Health MATTERS
A - Z of composers.....(classical gender please)

I am very happy that you remove these! (OR LOCK EM - whichever is best)
Jude Comber (nee Kelynack) 5's 5.38 1975-1980 Herts.
To Learn - read, to Know - write, to MASTER - Teach
User avatar
Mrs C.
Button Grecian
Posts: 2300
Joined: Wed Feb 16, 2005 2:22 pm
Real Name: Janet Chandler
Location: C.H.

Post by Mrs C. »

jtaylor wrote:I've just enabled compression on the database - seems to have speeded it up for me? Same for everyone else???
Re. closing your own topics - there's been complaints before about topics being deleted which contain other people's comments, but at the request of the originator of the topic....not sure about this one....
Locking the topic is easy though....

J
well something seems to have done the trick! Much better now! Amazing!
Thank you!!
The best way to forget your troubles is to wear tight shoes.
User avatar
jtaylor
Forum Administrator
Posts: 1880
Joined: Sat Jun 05, 2004 12:32 am
Real Name: Julian Taylor
Location: Wantage, OXON
Contact:

Post by jtaylor »

It's still a bit variable though.....

One thing I can try is to delete and recreate the database - this will take 15 mins, disabling the forum during that time - can do it now if nobody minds???

J
Julian Taylor-Gadd
Leigh Hunt 1985-1992
Image
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
User avatar
Jude
Button Grecian
Posts: 1477
Joined: Wed Nov 16, 2005 7:21 pm
Real Name: Jude Comber nee Kelynack 5.38 1975-1980
Location: Stonehouse, Gloucestershire

Post by Jude »

This is much better - thank you Julian - I don't have to go and make a cup of tea while the page refreshes! :wink: :wink:
Jude Comber (nee Kelynack) 5's 5.38 1975-1980 Herts.
To Learn - read, to Know - write, to MASTER - Teach
User avatar
Jude
Button Grecian
Posts: 1477
Joined: Wed Nov 16, 2005 7:21 pm
Real Name: Jude Comber nee Kelynack 5.38 1975-1980
Location: Stonehouse, Gloucestershire

Post by Jude »

jtaylor wrote:It's still a bit variable though.....

One thing I can try is to delete and recreate the database - this will take 15 mins, disabling the forum during that time - can do it now if nobody minds???

J
I have no problem - maybe I can go and make myself some dinner - it will make me get away from the pc for a while!!!

I'm happy to log off -

Jude
Jude Comber (nee Kelynack) 5's 5.38 1975-1980 Herts.
To Learn - read, to Know - write, to MASTER - Teach
User avatar
Mid A 15
Button Grecian
Posts: 3172
Joined: Thu May 19, 2005 1:38 pm
Real Name: Claude Rains
Location: The Patio Of England (Kent)

Re: A solution to keeping database size down?

Post by Mid A 15 »

jtaylor wrote:Here's an idea - we could enable auto-pruning (sounds painful!) on the "General Chat - Non CH" section, which would automatically remove any topic which hasn't been accessed for any specified period - e.g. 3 months?.

We'd have to ensure that topics which need keeping are moved into appropriate sections, as if they merit keeping (as they have a specific relevence to CH or Old Blues) then they probably should be in another section?

Thoughts??

This is a simple thing to do, and doesn't require any work/time to implement....

J
I'm basically in agreement too.

The one thing I think would be nice though is if we could keep some of the more serious debates we've had in this section as there have been some excellent posts from all viewpoints that deserve better than consignment to cyber hell or heaven.

Just my view though.

Maybe thread originators could suggest those that they would like to keep?
Ma A, Mid A 65 -72
User avatar
Mrs C.
Button Grecian
Posts: 2300
Joined: Wed Feb 16, 2005 2:22 pm
Real Name: Janet Chandler
Location: C.H.

Post by Mrs C. »

jtaylor wrote:It's still a bit variable though.....

One thing I can try is to delete and recreate the database - this will take 15 mins, disabling the forum during that time - can do it now if nobody minds???

J
go ahead!! we know you`re busy, so if now is a good time.....
The best way to forget your troubles is to wear tight shoes.
User avatar
jtaylor
Forum Administrator
Posts: 1880
Joined: Sat Jun 05, 2004 12:32 am
Real Name: Julian Taylor
Location: Wantage, OXON
Contact:

Post by jtaylor »

Few - got it back!

Relief is an understatement........

I took a backup, which then wouldn't upload because it was too big...........php is limited to a 2Meg upload at a time, when the backup is 80Meg....

Tried starting from scratch, with the latest version of phpbb, but still couldn't get the restore to work properly.

Got it back in the end with a great util called "bigdump" (sure that should get filtered!)

At least it proves that restoring a backup does work, but only with difficulty.

Not trying that again for a while....

J
Julian Taylor-Gadd
Leigh Hunt 1985-1992
Image
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
User avatar
Mid A 15
Button Grecian
Posts: 3172
Joined: Thu May 19, 2005 1:38 pm
Real Name: Claude Rains
Location: The Patio Of England (Kent)

Post by Mid A 15 »

jtaylor wrote:Few - got it back!

Relief is an understatement........

I took a backup, which then wouldn't upload because it was too big...........php is limited to a 2Meg upload at a time, when the backup is 80Meg....

Tried starting from scratch, with the latest version of phpbb, but still couldn't get the restore to work properly.

Got it back in the end with a great util called "bigdump" (sure that should get filtered!)

At least it proves that restoring a backup does work, but only with difficulty.

Not trying that again for a while....

J
I thought it was me when I couldn't access the forum! All becomes clear having read the rest of this thread.
Ma A, Mid A 65 -72
Post Reply