Instant message clean up

Jeff · July 06, 2006, 12:28:53 PM

Folks, it looks like we need to do some instant message box clean up. I'm going to give everyone a day or two to save any info they need from thier instant messages, and delete on thier own, then I am going to purge the database of ALL instant messages on Friday evening. The count on instant messages in Mysql database including outbox is currently at over 215,000 stored messages.

I didnt set a limit on messages before, but I may have to in the future. I'll let you know if we do that.

Don P · July 06, 2006, 01:09:49 PM

Cool, I found directions to Noble's and my password :-[ ;D

This one musta been from the sale section;

QuoteI got on the forum and the first thing I saw on the index was:

Economy Stud
Don P

Sorry, I don't know where my mind was :D.

CHARLIE · July 06, 2006, 05:07:00 PM

Done.

Ianab · July 06, 2006, 05:18:19 PM

Hey Jeff

Is it possible to do a purge by date?
Delete all messages more than 6 months old?
That would take out 2/3 of the clutter and could just be a regular monthly thing to keep it under control.

Cheers

Ian

Jeff · July 06, 2006, 05:24:58 PM

I think I can if I can come up with the right query.

SwampDonkey · July 06, 2006, 06:32:09 PM

Don't hit that button... DOH!

pc_smiley

beenthere · July 06, 2006, 06:49:24 PM

Just cleaned the 'inbox', and was surprised at the number of 'outbox' messages that I had sittin' there. Cleaned those out too, after re-reading them.
Had some good chats going on the side. Hope to have more.

highpockets · July 06, 2006, 07:05:17 PM

got her done.

Furby · July 06, 2006, 07:35:51 PM

woodbowl · July 06, 2006, 07:43:57 PM

Quote from: highpockets on July 06, 2006, 07:05:17 PM
got her done.

Ain't got er done! pc_smiley

I got phone #'s, addresses, specs and detailed technical explainations to scribble down. Not sure how I'm going to save it all. :-\

Furby · July 06, 2006, 07:47:46 PM

Highlight, copy and paste into your notepad on your puter.
Save it to your hard drive.

Can copy everything like avatars and such (like I did this time) or edit it down as you do it.

bitternut · July 06, 2006, 08:25:26 PM

I'm good to go Jeff ;D

tnlogger · July 06, 2006, 08:34:10 PM

yup got-er-done
woodbowl just copy and then open word and paste every thing into word name it and save it pc_smiley

Jeff · July 06, 2006, 09:46:23 PM

THats why I didnt just go ahead and clean house. I know there is information we as individuals dont want to lose, but when stored instant messages start taking up as much room as some of our more popular boards, its time to do something.

getoverit · July 06, 2006, 09:55:03 PM

I deleted all of mine... hopefully there wasnt any info in there that I couldnt replace

Part_Timer · July 06, 2006, 10:03:53 PM

Done

Thanks for the warning. I got everything saved

Tom

Jeff · July 06, 2006, 10:20:03 PM

Well, I got rid of the 6000 messages combined in my in and outbox that has accumalated the last 6 weeks or so since I did it last.

DanG · July 06, 2006, 10:25:52 PM

Quote from: Jeff B on July 06, 2006, 12:28:53 PM
then I am going to purge the database of ALL instant messages on Friday evening.

Which Friday?

???

Kirk_Allen · July 06, 2006, 10:27:16 PM

On behalf of Buzzsawyer can you please hold off dumping his until he has a chance to go through it. He is living at the Hospital with his son 24-7

gmmills · July 06, 2006, 10:40:06 PM

All done. Thanks for letting us know.

Jeff · July 06, 2006, 10:44:38 PM

I had already made provisionals hours ago for the exclusion of Buzz Saywer's records on any data dump.

isawlogs · July 06, 2006, 11:05:07 PM

When you do , do this , will unread messages be gone also ... ???

I just cleaned up shop in the in and outs , Just something I was wundering about .

chet · July 06, 2006, 11:10:46 PM

I only had a Few thousand, so I probably wasn't part of da problem. :D But I did my part and deleted a couple anyway. ;D

Corley5 · July 06, 2006, 11:17:23 PM

My message count has been in the negative digits before ;D Really 8)

pigman · July 06, 2006, 11:18:41 PM

I am sorry everybody. :-[ I was the guilty party that filled up the server with my messages, all four of them. I deleted them; now chet will not have to delete any of his. :D
Bob

fstedy · July 06, 2006, 11:32:52 PM

smiley_old_guy Done the Deed

UNCLEBUCK · July 06, 2006, 11:36:41 PM

OK dump away , I got rid of all my love letters to asy

Dan_Shade · July 06, 2006, 11:45:47 PM

no love letters here, not sure that I want any that can flip an 900 lb cant! but then again... these days, it may be welcome!

i got three important ones that need saved! thanks for the notice, Jeff!

Bill · July 07, 2006, 01:41:02 AM

Just purged myself ;D - DanG 'puter keeping all that trash

SwampDonkey · July 07, 2006, 03:54:54 AM

I thought I'de better make a follow-up note to by first thread. I cleaned out my messages and posted the message and thought I'de try some new smilies. ;D ;)

asy · July 07, 2006, 07:25:53 AM

Ok, I'm done.

I cleaned out, and now I've got 6 messages there. They's important ones.

I deleted all the messages from da boss tellin' me what's what around da forum.

I deleted all the messages from Roxie, keepin' me up to date with all the info around da forum. :D

I deleted all the messages from Tom, nicely explainin' what's what around da USA. ???

I deleted all the love letters from Buck, but not before I saved them all.

I deleted all the messages from everyone else. :'(

I'm ready to go. Except the 6 I kept.

asy :D

Bibbyman · July 07, 2006, 07:40:22 AM

I once heard a story about Henry Ford. Apparently he kept every scrap of correspondence – no matter how trivial. After 20-30 years it filled a warehouse. One day his sectary sent him a memo asking if they could purge some of it. He sent the memo back that it'd be OK .... but make a copy of everything first. :

I had about a dozen that contained "open business" and I cut, pasted them into a Word document and saved that.

pappy · July 07, 2006, 10:05:42 AM

I was under the impression we could keep a minimum of twenty messages in there :P

Jeff · July 07, 2006, 10:13:46 AM

If you mean maximum, thats the way the old system was. 20

On this system I can set the amount or leave it unlimited. I now find that unlimited "Might" have an adverse effect on how the system works since most of us just let the bottomless boxes become big storage bins, myself included. I clean mine every few weeks but I get an unreal amount of messages and they add up fast.

IL Bull · July 07, 2006, 11:17:14 AM

Done

pappy · July 07, 2006, 11:28:30 AM

oops I did mean "maximum" sorry :

and I've been so good at keeping just the im po tant ones... ;) oh well things do need a changin' some times...

Server disk space does cost and I would imagine cleaning out the closets will be a saveings...

Guts mine taken care of...

Jeff · July 07, 2006, 11:36:16 AM

Its not so much the cost, in fact its not that at all. We are having some "issues" with the system apparently and I am trying to tweak it out and find whats going on. Sounds like so far that cleaning out messages is helping performance of the messaging system.

oakiemac · July 07, 2006, 07:11:38 PM

I tought we were limited to just 20??

wiam · July 07, 2006, 11:01:14 PM

I have one. Do I need to dump it?

Will

iain · July 08, 2006, 05:08:15 AM

There you go i dumped my 6 after writing down the info ;D
then read the "you can keep 20" bit :

so i did all that writing for nowt >:(
(two phone numbers) :D

iain

iain · July 08, 2006, 05:09:00 AM

There you go i dumped my 6 after writing down the info ;D
then read the "you can keep 20" bit :

so i did all that writing for nowt >:(
(two phone numbers) :D

iain

SwampDonkey · July 08, 2006, 06:31:48 AM

I see the double posting still works.

Jeff · July 08, 2006, 09:35:24 AM

I never said you could keep 20. :D In the old forum software there was a 20 message limit. you can get as many as you want but the storage was only 20. Thats what others have mentioned. Right now we have quite a decrease in the total amount of data stored in the instant message tables, and if that continues, I wont need to set any phisical limits.

VA-Sawyer · July 08, 2006, 03:32:20 PM

I was feeling guilty till I read about the Boss having 6000 IM's ! I only had about 75/75 in my inbox/outbox. Cleaned it down to 24/2. Hope it helps.
VA-Sawyer

Jeff · July 08, 2006, 04:39:34 PM

I get upwards somedays of over 100 a day. If I answer each one, which I TRY to do, that is another 100 in the outbox. So, if I get 100, reply to a hundred, and the people that sent me messages each are keeping a copy in thier out boxes, that can amount to 400 copies a day just becasue of correspondance with me.

brdmkr · July 08, 2006, 09:37:50 PM

All done. Thanks for the heads-up.

Sponsors:

Instant message clean up

Kirk_Allen

Thank You Sponsors!