Using SMF 2.0.2
Hi, last time I posted this problem here: [click here] (http://www.simplemachines.org/community/index.php?topic=423482.msg3442761#msg3442761) <- look at this topic first!
Mods:
Quote1. 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 ]
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.
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.
QuoteI 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. ;)
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.
Finally my host moved my forum to another server and this problem was solved already :)