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

Post Reply
User avatar
Mid A 15
Button Grecian
Posts: 3189
Joined: Thu May 19, 2005 1:38 pm
Real Name: Claude Rains
Location: The Patio Of England (Kent)

Post by Mid A 15 »

Great Plum wrote:I would be wary of this becoming 'official' as I think that some of the more 'cathartic' threads would be censored...
Hear! Hear!
Ma A, Mid A 65 -72
Top
User avatar
J.R.
Forum Moderator
Posts: 15835
Joined: Wed Mar 09, 2005 4:53 pm
Real Name: John Rutley
Location: Dorking, Surrey

Post by J.R. »

Mid A 15 wrote:
Great Plum wrote:I would be wary of this becoming 'official' as I think that some of the more 'cathartic' threads would be censored...
Hear! Hear!

WHERE ???


WHERE ???
John Rutley. Prep B & Coleridge B. 1958-1963.
Top
User avatar
blondie95
Button Grecian
Posts: 2590
Joined: Tue Jun 06, 2006 4:41 pm
Real Name: Amy Leadbeater
Location: Kent
Contact:
Contact blondie95

Post by blondie95 »

i agree, i like the unoffical bit it means truth-official means cover up!
Top
midget
Button Grecian
Posts: 3186
Joined: Tue Nov 01, 2005 3:49 pm
Real Name: Margaret O`Riordan
Location: Barnstaple Devon

Post by midget »

I agree, but so cynical for one so young!
Thou shalt not sit with statisticians nor commit a social science.
Top
User avatar
J.R.
Forum Moderator
Posts: 15835
Joined: Wed Mar 09, 2005 4:53 pm
Real Name: John Rutley
Location: Dorking, Surrey

Post by J.R. »

midget wrote:I agree, but so cynical for one so young!
Quite so, Midget.

Leave the cynicism to us of more mature years, eh ?
John Rutley. Prep B & Coleridge B. 1958-1963.
Top
User avatar
blondie95
Button Grecian
Posts: 2590
Joined: Tue Jun 06, 2006 4:41 pm
Real Name: Amy Leadbeater
Location: Kent
Contact:
Contact blondie95

Post by blondie95 »

sorry J.R cynicism is all for you
Top
User avatar
J.R.
Forum Moderator
Posts: 15835
Joined: Wed Mar 09, 2005 4:53 pm
Real Name: John Rutley
Location: Dorking, Surrey

Post by J.R. »

blondie95 wrote:sorry J.R cynicism is all for you
Bless you, my child ! :heart:
John Rutley. Prep B & Coleridge B. 1958-1963.
Top
User avatar
jhopgood
Button Grecian
Posts: 1886
Joined: Mon Jun 07, 2004 6:26 pm
Real Name: John Hopgood
Location: Benimeli, Alicante

Post by jhopgood »

J.R. wrote:
blondie95 wrote:sorry J.R cynicism is all for you
Bless you, my child ! :heart:
Such a mature reply.
Top
User avatar
jtaylor
Forum Administrator
Posts: 1887
Joined: Sat Jun 05, 2004 12:32 am
Real Name: Julian Taylor
Location: Wantage, OXON
Contact:
Contact jtaylor

Post by jtaylor »

Well, I spotted an issue with the phpbb_sessions table this evening.

It had 55Meg of "overhead".
Tried an overhead, tried a repair - mysqladmin wouldn't let me do it, "The handler for the table doesn't support optimize" and same message for repair.

Copied the table, renamed old one, and overhead has gone.

Any techies out there know the implications of this??

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.
Top
midget
Button Grecian
Posts: 3186
Joined: Tue Nov 01, 2005 3:49 pm
Real Name: Margaret O`Riordan
Location: Barnstaple Devon

Post by midget »

I didn't understand a single word of that !
Thou shalt not sit with statisticians nor commit a social science.
Top
User avatar
Mid A 15
Button Grecian
Posts: 3189
Joined: Thu May 19, 2005 1:38 pm
Real Name: Claude Rains
Location: The Patio Of England (Kent)

Post by Mid A 15 »

midget wrote:I didn't understand a single word of that !
Snap!!
Ma A, Mid A 65 -72
Top
User avatar
DavebytheSea
Forum Moderator
Posts: 2036
Joined: Tue Nov 23, 2004 10:33 am
Real Name: David Eastburn
Location: Nr Falmouth, Cornwall

Post by DavebytheSea »

jtaylor wrote:Well, I spotted an issue with the phpbb_sessions table this evening.

It had 55Meg of "overhead".
Tried an overhead, tried a repair - mysqladmin wouldn't let me do it, "The handler for the table doesn't support optimize" and same message for repair.

Copied the table, renamed old one, and overhead has gone.

Any techies out there know the implications of this??

J
Who he? He might be a supporter of Saddam Hussein - we don't want him directing the forum from the Baghdad equivalent of Death Row.

But apart from this geezer stopping JT doing his stuff, I didn't understand a word of it either.
David Eastburn (Prep B and Mid A 1947-55)
Top
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. »

Perhaps JT`s been talking to Amy? :D :D
The best way to forget your troubles is to wear tight shoes.
Top
User avatar
DavebytheSea
Forum Moderator
Posts: 2036
Joined: Tue Nov 23, 2004 10:33 am
Real Name: David Eastburn
Location: Nr Falmouth, Cornwall

Post by DavebytheSea »

Well I usually understand Amy's thrust, but this posting of JT was complete gobbledigook.
David Eastburn (Prep B and Mid A 1947-55)
Top
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. »

I think we should just answer his question - ...


Yes. probably! :mutley:
The best way to forget your troubles is to wear tight shoes.
Top
Post Reply

Return to “General Chat - Non CH”