Advertisement:

Author Topic: smf_log_topics table HUGE (can't upgrade!)  (Read 93702 times)

Offline matasanos

  • Jr. Member
  • **
  • Posts: 267
    • Lords-Beer.net
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #20 on: February 16, 2009, 04:44:17 PM »
For thirty thousand members that's too much?

I should add 'prune nullos' to one of the optimization tips. How many zero post members do you have?

The script marks every board as read for all users.
12825 * 28202

ok, thanks
so i understand, the best option is to prune nullos members, ok!!

Offline John Eric

  • Semi-Newbie
  • *
  • Posts: 40
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #21 on: February 25, 2009, 02:06:46 PM »
better solution rather to delete that wasteful useless featuring 'unread foolishness'

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #22 on: March 14, 2009, 09:24:10 PM »
Marking this as solved.  Topic was started in 2007.  Please start a new topic if you have this same issue.
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline digit

  • Sophist Member
  • *****
  • Posts: 1,364
  • Gender: Male
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #23 on: September 13, 2009, 10:11:56 AM »
Hey Digit, it might not be exactly what you are after, however I've attached here a script

I don't know how I missed this - but I did -THANKS!  'am running it now :)   8) :P

Happily using a heavily modified 1.1.16 version of SMF!

2748011 Posts in 320998 Topics by 50986 Members


SOLD my website - thanks it was a good run - they converted to vbadvanced. (and screwed it up good!)

Offline Owdy

  • SMF Fossil
  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,627
  • Gender: Male
  • W00t!
    • janoloferiksson on LinkedIn
    • @@jaoler on Twitter
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #24 on: September 26, 2009, 04:26:56 PM »
Hey Digit, it might not be exactly what you are after, however I've attached here a script I wrote for my forum to reduce the no. of rows in log_topics using ssi to mark ALL boards as READ for inactive users (thats every single board, even ones they can't currently see). 
But can also be easily to configured to mark ALL boards as read for everyone (as I did eventually on my own forum to get the most benefit).
You should make a mod about this. Setting in admin panel :)
Former Lead Support Specialist

Tarvitsetko apua SMF foorumisi kanssa? Otan työtehtäviä vastaan, lue:http://www.simplemachines.org/community/index.php?topic=375918.0

Offline MultiformeIngegno

  • Sophist Member
  • *****
  • Posts: 1,100
  • Gender: Male
  • Id quo maius cogitari nequit
    • RockCiclopedia
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #25 on: February 06, 2010, 06:24:25 PM »
Will the karlbenson's script work on 2.0 RC2?
I think it's really, really useful!! Thanks!!!!
RockCiclopedia (wiki - forum), Tutta la storia del rock, scritta da voi ...
Rimanere aggiornati sul mondo della musica grazie al nuovo feed "RockCiclopedia Music News"!

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #26 on: February 07, 2010, 12:47:59 PM »
There are 2 versions attached to this post.  As always make a backup before trying this on you forum.

http://www.simplemachines.org/community/index.php?topic=212330.msg1667071#msg1667071
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline Piwaille

  • Jr. Member
  • **
  • Posts: 133
    • le chant du vario (forum du parapente)
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #27 on: February 17, 2010, 04:49:07 AM »
Hello !
I've just read that topic (coming from Twenty-four things you can do to make SMF go faster because my forum is growing up quite a lot)
You should make a mod about this. Setting in admin panel :)
I do agree ! A nice mod would be a great thing ;D
Piwaille
le chant du vario est motorisé par SMF 1.1.15

Offline waruna

  • Jr. Member
  • **
  • Posts: 241
  • Gender: Female
  • I am what i am
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #28 on: February 26, 2010, 07:49:19 AM »
Hello guys. How can I run the 2.x_inactiveusers_markallboardsread.php?
Just simply put the file into my root directory and go to myforum.com/2.x_inactiveusers_markallboardsread.php?

Thanks in advance.
Trust of Lust

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #29 on: March 02, 2010, 06:58:57 PM »
Hello guys. How can I run the 2.x_inactiveusers_markallboardsread.php?
Just simply put the file into my root directory and go to myforum.com/2.x_inactiveusers_markallboardsread.php?

Thanks in advance.

You would upload this script to the same location as your forum and then point your browser to it.
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline Kimmie

  • SMF Hero
  • ******
  • Posts: 1,590
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #30 on: April 18, 2010, 10:19:43 PM »
I noticed this thread and was wondering if this script would be useful to run periodically as sort of my "regular maintenance" if you will, on my site, for the sheer fact that I have some members who have not visited in a while. I'm using SMF 2.0 RC1.2 so I assume that I would use the 2.x script

Offline humbleworld

  • Sr. Member
  • ****
  • Posts: 886
    • best article
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #31 on: May 30, 2010, 11:26:59 AM »
Can someone guide me where to upload this script of karl? how shall I use the script?

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #32 on: May 31, 2010, 12:19:47 AM »
Hello guys. How can I run the 2.x_inactiveusers_markallboardsread.php?
Just simply put the file into my root directory and go to myforum.com/2.x_inactiveusers_markallboardsread.php?

Thanks in advance.

You would upload this script to the same location as your forum and then point your browser to it.
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline humbleworld

  • Sr. Member
  • ****
  • Posts: 886
    • best article
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #33 on: May 31, 2010, 02:10:13 AM »
Jim, thank you for the guide. Appreciate it.

Offline ɔɔɔɔɔɔuɥoɾ

  • SMF Hero
  • ******
  • Posts: 2,742
  • Gender: Male
  • Community Support Helper SMF forums ftw!
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #34 on: June 24, 2010, 01:40:41 PM »
Using it now, very nice, taking a while, but its not me having to do it :P

Thanks

SMF 2.0 RC5

   
Webhost to New Webhost file transfer service, PM me - Fast transfers

Offline Kimmie

  • SMF Hero
  • ******
  • Posts: 1,590
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #35 on: June 29, 2010, 03:40:33 PM »
do we need to throw our site into maintenance mode before running this or can we leave it open?

Offline xenovanis

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,988
  • Gender: Female
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #36 on: June 29, 2010, 03:43:41 PM »
do we need to throw our site into maintenance mode before running this or can we leave it open?

You could throw it in maintenance mode, however I believe there's a point where the upgrader does so automatically. Not sure though, it has been a while since I upgraded.

For your users it's probably best to throw it in maintenance mode, so they know they can't access the forum for a while. This will also prevent their posts being blocked during the upgrade of the database.
"Insanity: doing the same thing over and over again and expecting different results."

Offline Kimmie

  • SMF Hero
  • ******
  • Posts: 1,590
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #37 on: June 29, 2010, 03:52:33 PM »
I think I might have posted incorrectly and it made it confusing hehe. I meant it in terms of running the script, not actually upgrading. Sorry :)

Offline xenovanis

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,988
  • Gender: Female
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #38 on: June 29, 2010, 03:57:06 PM »
Nah, not your fault. I'm really a bit slow today.  :D I should have read the previous posts to realise your question was about the script.

Sorry, can't help you there.
"Insanity: doing the same thing over and over again and expecting different results."

Offline Kimmie

  • SMF Hero
  • ******
  • Posts: 1,590
Re: smf_log_topics table HUGE (can't upgrade!)
« Reply #39 on: June 30, 2010, 10:23:37 PM »
Not a problem we all hav those days :)

I will probably put it in maintenance mode just to be on the safe side - atleast until I have run it that first time and know that nothing gets messed up.