A solution to keeping database size down?
Moderator: Moderators
- 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?
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
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
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
Leigh Hunt 1985-1992
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
- jtaylor
- Forum Administrator
- Posts: 1880
- Joined: Sat Jun 05, 2004 12:32 am
- Real Name: Julian Taylor
- Location: Wantage, OXON
- Contact:
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
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
Leigh Hunt 1985-1992
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
- 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
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!
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!
Jude Comber (nee Kelynack) 5's 5.38 1975-1980 Herts.
To Learn - read, to Know - write, to MASTER - Teach
To Learn - read, to Know - write, to MASTER - Teach
- jtaylor
- Forum Administrator
- Posts: 1880
- Joined: Sat Jun 05, 2004 12:32 am
- Real Name: Julian Taylor
- Location: Wantage, OXON
- Contact:
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
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
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
Leigh Hunt 1985-1992
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
- 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
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)
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
To Learn - read, to Know - write, to MASTER - Teach
- Mrs C.
- Button Grecian
- Posts: 2300
- Joined: Wed Feb 16, 2005 2:22 pm
- Real Name: Janet Chandler
- Location: C.H.
well something seems to have done the trick! Much better now! Amazing!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
Thank you!!
The best way to forget your troubles is to wear tight shoes.
- jtaylor
- Forum Administrator
- Posts: 1880
- Joined: Sat Jun 05, 2004 12:32 am
- Real Name: Julian Taylor
- Location: Wantage, OXON
- Contact:
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
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
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
Leigh Hunt 1985-1992
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
- 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
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!!!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'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
To Learn - read, to Know - write, to MASTER - Teach
- 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?
I'm basically in agreement too.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
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
- Mrs C.
- Button Grecian
- Posts: 2300
- Joined: Wed Feb 16, 2005 2:22 pm
- Real Name: Janet Chandler
- Location: C.H.
go ahead!! we know you`re busy, so if now is a good time.....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
The best way to forget your troubles is to wear tight shoes.
- jtaylor
- Forum Administrator
- Posts: 1880
- Joined: Sat Jun 05, 2004 12:32 am
- Real Name: Julian Taylor
- Location: Wantage, OXON
- Contact:
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
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
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
Leigh Hunt 1985-1992
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
- 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)
I thought it was me when I couldn't access the forum! All becomes clear having read the rest of this thread.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
Ma A, Mid A 65 -72