Hello Folks,
Over the past few weeks myself and many members have been getting the following error:
Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1135 - Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
Query:
[READ] Unable to connect to MySQL server
Please contact the MyBB Group for support.
[/quote]
I've disabled a large number of plugins to see if that helps improve things, and after it didn't I contacted my host after reading about it through Google.
I was told this:
Quote:As it turns out memory may not be the main issue here. Your scripts were hitting the IO limit pretty regularly and seem to be staying below the limit since you removed plugins.
IO limits restrict the data throughput for the customer. When limit is reached, the processes are throttled (put to sleep). Yet don't stop working, nor getting killed -- they just work slower when the limit is reached.
This may or may not be causing the issues (such as timeouts) you are seeing but adding some caching to your scripts should help immensely. The IO limit is fixed and cannot be changed so caching and other such optimizations will be the only fix going forward.
I'm not entirely sure what I can do, so as a last resort I thought it'd be best to ask to pros at the MyBB Community Forums.
Any help, advice or pointers will be greatly appreciated.
MyBB Version: 1.6.11
Forum URL: http://techyforums.net
What plugins are you running, and also have you enabled anything in the "Task Manager"?
List of plugins:
Max Post Views Guest (1.0)
Subforums In Columns (1.0)
Show subforums in columns.
Show Additional Group Images (1.0)
Advanced reports and warnings (1.0.0)
Automatic Website Removal (1.0)
CloudFlare Manager (1.0-beta 3.1)
Default Profile (2.0)
Game Section (1.2.3-1)
MyBB GoMobile (1.1)
Google SEO (1.6.6)
Moderator notifications (1.6)
My Awards (2.3)
MyShoutbox (1.7)
MySubscriptions (1.00)
NewPoints (1.9.8)
OUGC Announcement Bars (1.1)
Page Manager (1.5.2)
PluginLibrary (12)
PM On Reputation (1.0)
ProStats /proʊˈstæts/ (1.9.5)
Registered Links (1.0)
Registration Security Question (1.2)
Reputation Bars (0.3)
RSS To Post (1.2.2)
Subforums in columns (1.0)
Tabbed Menu (2.0.2)
Username Style (1.0.6)
This plugin adds the username style to your portal, forum index and thread index page.
View Groups (1.5)
And running tasks are
Daily Cleanup
Delayed Moderation
Game Section Cleanup
Game Section Tournament Status
Half-hourly User Cleanup
Hourly Cleanup
Log Pruning
Mass Mail
Moderator notifications
MySubscriptions Updates
NewPoints Bank System
NewPoints Subscriptions
Promotion System
RSS To Post
User Pruning
Daily/Weekley Backup
Hopefully someone can help me solve this soon, these errors are driving me crazy.
MyShoutbox is the most resource-hungry plugin on your list. I don't think there is better chatting solution integrated with MyBB for free though. You can try to apply this fix:
http://community.mybb.com/thread-47686-p...#pid886904 and increase shoutbox refresh time in settings. It helped a lot on my forum.
Then another heavy plugin is Google SEO, but it has much less impact than MyShoutbox. The rest shouldn't cause trouble.
On a side note, I've never seen Username Style and I recommend to change it to this:
https://github.com/lukasamd/MyBB-Style_Usernames
(2013-11-17, 01:08 AM)Destroy666 Wrote: [ -> ]MyShoutbox is the most resource-hungry plugin on your list. I don't think there is better chatting solution integrated with MyBB for free though. You can try to apply this fix: http://community.mybb.com/thread-47686-p...#pid886904 and increase shoutbox refresh time in settings. It helped a lot on my forum.
Then another heavy plugin is Google SEO, but it has much less impact than MyShoutbox. The rest shouldn't cause trouble.
On a side note, I've never seen Username Style and I recommend to change it to this: https://github.com/lukasamd/MyBB-Style_Usernames
Thank you, I've done what you've said above. Used that shoutbox fix, changed the refresh time, changed the username style plugin but not removed the SEO plugin just yet, i need that one.
Will see how I get along, thank you
