Fuse Box

Anguz · January 02, 2005, 05:04:33 PM

Fizzy, sorry for not seeing your posts earlier. What Ben told you is right, the load is for the whole server. That's a pretty busy one you're in. Maybe one of the users in it is abusing it a bit, the host will know what to do.

Fizzy · January 02, 2005, 07:41:16 PM

Hey there Anguz old buddy

I took the issue up with the server host. They did report back later to say that a single user was abusing and that the problem had been "sorted".
Since then the cpu load had dropped low again and the forum is no longer tripping out any fuses.

Maybe you should speak to server hosts about your script as it turned out to be a great alert both for me and them

Either way, I think this is a great Mod. Very useful.

Thanks for writing it

Anguz · January 02, 2005, 08:19:09 PM

Glad you liked it.

neugi · January 14, 2005, 05:59:16 AM

Hi,

will there be a fuse mod for the 1.0.1?

best

Anguz · January 14, 2005, 07:04:35 AM

Quote from: neugi on January 14, 2005, 05:59:16 AM
Hi,

will there be a fuse mod for the 1.0.1?

best

Of course.

neugi · January 14, 2005, 08:24:57 AM

Hi,

i've tried it right now on the new 1.0.1 but the fuse box is not visibel. when do you think there will be a version for the 1.0.1?

thx

Fizzy · January 15, 2005, 06:19:07 AM

Hi Anguz,

This is a great Mod, thank you for writing it

From a user perspective though, I know you have default settings for the different fuses but do you have any guidelines at all?
What I mean is that I have had to increase the "Stats" fuse rating slightly and was wondering if there was any way of guaging what setting should be considered or rated as good/average/bad ?

For example, if I have had to increase my Stats fuse from 2 to 5 should I be worried?

Anguz · February 03, 2005, 10:38:31 AM

Version 1.23

Updated to SMF 1.0.1

Anguz · February 03, 2005, 10:43:46 AM

Quote from: Fizzy on January 15, 2005, 06:19:07 AM
Hi Anguz,

This is a great Mod, thank you for writing it

From a user perspective though, I know you have default settings for the different fuses but do you have any guidelines at all?
What I mean is that I have had to increase the "Stats" fuse rating slightly and was wondering if there was any way of guaging what setting should be considered or rated as good/average/bad ?

For example, if I have had to increase my Stats fuse from 2 to 5 should I be worried?

Sorry for not noticing your post earlier Fizzy!

I really don't know much about that to recommend values. These will vary from server to server. You should monitor your load and decide what values work best for you. I believe that someone with more experience on servers would give better advice on this, though.

I'm sorry I can't be of more help than that.

neugi · February 03, 2005, 10:54:44 AM

Hi

works perfekt.

thx

[Unknown] · February 03, 2005, 03:05:38 PM

Your load averages should, theoretically, be under the number of CPUs you have. Maybe twice that - higher and I'd be worried indeed.

-[Unknown]

Fizzy · February 04, 2005, 08:12:30 AM

No problem

Honestly. I know that you and the rest of the team have been really busy and that you would reply when time/workload allowed

I've continued to tweak the settings to try and strike a balance between overload and normal usage by basically making small incremental changes and getting direct feedback from my members to let me know when any of the fuses blow.

I was having a few problems but that was due to being on a shared server with a couple of other sites that were drawing heavy resources from the hardware but after I spotted that I got transferred to another server and my own settings have come down dramatically.

As I said, a great mod, thanks for producing it.

neugi · February 04, 2005, 08:19:53 AM

@fizzy

which settings are you using right now. are there any stettings that you would say that are the best to use by default?

best

Fizzy · February 04, 2005, 08:32:52 AM

Hi Neugi,

I'm currently using the following:

Forum 30
Search 4
Unread All 2
Statistics Center 4
Auto Optimize Database 2

The 'Forum' one is gradually being reduced by 2 every few days until I get a good balance and the forum doesn't drop in to Maintenance Mode.
I found that "Search" depends more on the number of posts on your forum so with 150,000 on mine I have set this to 4 and it seems fine at that.
Unread All has never tripped out yet
Stats Center has tripped out a couple of times but that seems to be very stable at 4 now.
Auto Optimize hasn't tripped out yet.

I think a lot depends on who you are sharing a server with. My host was kind enough to move me to a quieter server without any quibbles and that has allowed me to be able to gradually reduce the settings. I'm fairly sure that they can go lower than they are now. I'll post on here what the final optimum settings are for my own forum once I finish the exercise

Anguz · February 04, 2005, 02:05:10 PM

Thank you for sharing that info. It's great that your host was so helpful. I'm glad you like the mod.

It's actually pretty not obvious, there's not message mentioning overload, it'll just work as Unread. About the UnreadAll fuse, how do you know it hasn't blown yet?

[Unknown] · February 04, 2005, 04:00:09 PM

Fizzy, can you try setting your log_topics, log_mark_read, attachments, topics, log_search, and log_boards tables to InnoDB in the Operations tab under phpMyAdmin?

-[Unknown]

Fizzy · February 05, 2005, 05:24:14 AM

Quote from: Anguz on February 04, 2005, 02:05:10 PM
About the UnreadAll fuse, how do you know it hasn't blown yet?

Forthunately I have a great bunch of members who provide me with a lot of feedback. Since we converted over to SMF they have been really helpful in giving me all information regarding anything that didn't seem to be working properly or even seemed "different"
I can't be 100% sure, but I haven't had any reports of it blowing yet

Quote from: [Unknown] on February 04, 2005, 04:00:09 PM
Fizzy, can you try setting your log_topics, log_mark_read, attachments, topics, log_search, and log_boards tables to InnoDB in the Operations tab under phpMyAdmin?

-[Unknown]

I'll gladly give it a try and feed back

Is there anything in particular you would like me to look for when I make the change? (after I've done a back-up to be safe

)

[Unknown] · February 05, 2005, 05:32:42 AM

It should make searching, among other things, faster... hopefully. Your forum is a bit small for it.

-[Unknown]

Fizzy · February 05, 2005, 05:35:53 AM

Ok , no problem

I'll record a comparison on page creation times on some standard searches ~ before and after

Fizzy · February 05, 2005, 05:59:47 AM

Pre DB changes

Search parameters = Search all boards, all categories, 9999 days

Results
Search word - number of pages in result - creation times
"various" 18 pages - Page created in 19.422 seconds with 25 queries.
"timing" 4 pages - Page created in 14.755 seconds with 23 queries.
"frog" 2 pages - Page created in 13.075 seconds with 27 queries.
"festival" 2 pages - Page created in 18.793 seconds with 23 queries.
"disorder" 18 pages - Page created in 21.74 seconds with 23 queries.

After conversion to InnoDB

various - Page created in 17.776 seconds with 25 queries.
timing - Page created in 16.256 seconds with 25 queries.
frog - " Sorry, the search functionality has been temporarily disabled due to high stress on the server. Please try again later."
festival - Page created in 18.899 seconds with 26 queries.
disorder - Page created in 19.826 seconds with 24 queries.

News:

Fuse Box