smf_log_topics table HUGE (can't upgrade!)

Started by digit, December 21, 2007, 06:48:43 AM

Previous topic - Next topic

matasanos

Quote from: Vekseid on February 16, 2009, 04:33:22 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?

Quote from: regularexpression on February 16, 2009, 04:35:53 PM
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!!

John Eric

better solution rather to delete that wasteful useless featuring 'unread foolishness'

JimM

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

digit

Quote from: karlbenson on August 19, 2008, 11:29:49 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!)

Owdy

Quote from: karlbenson on August 19, 2008, 11:29:49 AM
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

MultiformeIngegno

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"!

JimM

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

Piwaille

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)
Quote from: Owdy on September 26, 2009, 04:26:56 PMYou 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

waruna

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

JimM

Quote from: waruna 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.

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

Kimmie

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

humbleworld

Can someone guide me where to upload this script of karl? how shall I use the script?

JimM

Quote from: JimM on March 02, 2010, 06:58:57 PM
Quote from: waruna 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.

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

humbleworld

Jim, thank you for the guide. Appreciate it.

ɔɔɔɔɔɔuɥoɾ

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

Kimmie

do we need to throw our site into maintenance mode before running this or can we leave it open?

xenovanis

Quote from: Kimmie 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?

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."

Kimmie

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 :)

xenovanis

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."

Kimmie

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.

Advertisement: