High MySQL Activity

[PokémonS]

Using SMF 2.0.2

Hi, last time I posted this problem here: [click here] <- look at this topic first!

Mods:

1.    Optimus Brave    1.8.2    [ Uninstall ] [ List Files ] [ Delete ]
2.    Admin Toolbox    1.0    [ Uninstall ] [ List Files ] [ Delete ]
3.    Add Social Media Icons To Profiles    1.0.5    [ Uninstall ] [ List Files ] [ Delete ]
4.    Users Online Today    2.0.1    [ Uninstall ] [ List Files ] [ Delete ]
5.    Add Facebook Like, Tweet, and Google +1    1.0    [ Uninstall ] [ List Files ] [ Delete ]
6.    Minimun Characters or Words Mod    1.1.2    [ Uninstall ] [ List Files ] [ Delete ]
7.    AvatarSelect    1.2.1    [ Uninstall ] [ List Files ] [ Delete ]
8.    Change Report Text To Image    1.0    [ Uninstall ] [ List Files ] [ Delete ]
9.    SimplePortal    2.3.5    [ Uninstall ] [ List Files ] [ Delete ]
10.    Tidy Child Boards    1.4    [ Uninstall ] [ List Files ] [ Delete ]
11.    Signature Area BBCode Buttons    2.0.3    [ Uninstall ] [ List Files ] [ Delete ]
12.    Spoiler Tag    0.7.2a    [ Uninstall ] [ List Files ] [ Delete ]
13.    PM to New Members    1.2    [ Uninstall ] [ List Files ] [ Delete ]
14.    Drafts    1.1.4    [ Uninstall ] [ List Files ] [ Delete ]
15.    Ultimate Profile    0.9.1    [ Uninstall ] [ List Files ] [ Delete ]
16.    Default Avatar    2.2    [ Uninstall ] [ List Files ] [ Delete ]
17.    YouTube BBCode    2.6    [ Uninstall ] [ List Files ] [ Delete ]

[Storman™]

We could speculate forever on what the cause is but no one will probably know.

Suggest you disable mods one by (or add mods one by one) till the activity rises. I see you have Simpleportal installed. Sometimes the recent posts/topics block is known to raise MySQL load. You could try disabled it if its being used.

Maybe you just need a bigger hosting package ?? What's your allocation and how big/active is your forum.

[PokémonS]

It's a medium community with average 70 posts, 3 topics, 24 peoples online and 4 users registration per day.
The forum link is in my signature.

Also, it's not only high MySQL activity, but high CPU + Memory usages too. It makes my forum suspended. This suspended means the public_html is set to 0000 (not sure, autoset or hosting changes it to 0000?).

I believe there is no relation with bigger hosting package 'cuz it's not listed about the how big is RAM, the processor, and something like that.

Hm, Simpleportal? Before this problem, I set auto-refresh chatbox (from Simpleportal) to 5 seconds and guest allowed to see. Maybe it will be hurt the server. so I set it to 15 seconds and guest is not allowed to see. Hope this problem solved.

[Storman™]

I set auto-refresh chatbox (from Simpleportal) to 5 seconds and guest allowed to see. Maybe it will be hurt the server. so I set it to 15 seconds and guest is not allowed to see. Hope this problem solved.

Quite possibly the issue, see how it goes. 

[Kindred]

Chat boxes and chat rooms will, invariably, kill your server on a shared server host.

They are pointless. Dump te chat box completely and your server will probably never spike again.

[PokémonS]

Finally my host moved my forum to another server and this problem was solved already