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. :o 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. :)
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.
Done. :)
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
I think I can if I can come up with the right query.
Don't hit that button... DOH!
pc_smiley whiteflag_smiley no_no
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.
got her done.
smiley_thumbsup
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. :-\
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.
I'm good to go Jeff ;D
yup got-er-done
woodbowl just copy and then open word and paste every thing into word name it and save it pc_smiley
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.
I deleted all of mine... hopefully there wasnt any info in there that I couldnt replace :)
Done
Thanks for the warning. I got everything saved
Tom
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.
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? :o :o :-X ???
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
All done. Thanks for letting us know.
I had already made provisionals hours ago for the exclusion of Buzz Saywer's records on any data dump.
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 .
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
My message count has been in the negative digits before ;D Really 8)
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
smiley_old_guy Done the Deed
OK dump away , I got rid of all my love letters to asy laugh_at
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!
Just purged myself ;D - DanG 'puter keeping all that trash
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 ;)
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
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.
I was under the impression we could keep a minimum of twenty messages in there :P
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.
Done
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...
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.
I tought we were limited to just 20??
I have one. Do I need to dump it?
Will
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
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
I see the double posting still works. yikes_smiley
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.
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
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.
All done. Thanks for the heads-up.