Notices > Forum Notices
Help Wanted: IT Guru
jcf:
Hi guys,
here is the link to the manual:
http://wiki.simplemachines.org/
... and the relevant text from the GoDaddy support response to Greg's query:
Please be aware that we allow up to 200 simultaneous MySQL Database connections per MySQL user. The error message you supplied can come from exceeding this limit. You will want to optimize the web applications database accesses and make sure database connections are being closed.
Thoughts?
Thanks,
Jon
:icon_fsm:
Rickshaw:
OK, you may have already done this but have you followed the instructions on this page - http://wiki.simplemachines.org/smf/Forum_Maintenance to:
--- Quote --- * Find and repair any errors - Going to this page will search for any possible errors in your database. Usually, these errors are caused by improper conversions, modifications gone wrong, or data corruption. It's a good idea to check this once and a while, just in case.
[...]
Database
* Optimize all tables to improve performance. - Using this functionality causes SMF to instruct the database to attempt to reanalyze and reoptimize the tables in your database. It's not a good idea to do this too often, because it can take a long time.
--- End quote ---
It appears that this is intended to be a "user friendly" system - which invariably means that you have extremely limited ability to make major changes to it. In theory, using the commands they do give you access to, should enable you to administer it for most tasks. As the message you quoted, talks about you needing to "optimize the web applications database accesses" that should be covered by the page mentioned above which covers, "Optimize all tables to improve performance". While the first page, the one entitled, "Find and repair any errors" should do just that. I'd perform the "Find and repair any errors" one first and then the "Optimize all tables to improve performance" second.
overscan:
I may be able to help ;)
Any shared hosting will have database issues like these. Whatifmodelers used to get them a lot at peak times. Quite simply, there will be lots of database access from bots, spiders, as well as ordinary users. You don't have a great deal of control over how many queries can get generated by the forum. You should have "Use a persistent connection" turned off in "Server Settings" - "Database" to reduce the load on the shared server.
Turning on "Display time taken to create every page" in Features and Options - Layout will put the number of queries used at the bottom of the page. Bear in mind that simply loading the Secret Projects homepage takes 7 queries. Viewing a page in a topic - 19 queries.
You may be able to get better hosting. The only real answer - something like Linode - a Virtual Private Server. Costs $19.99/month though, and you need a tame UNIX admin to look after the server.
jcf:
Thanks for the tips, Paul. I'll check into the settings.
Cheers, Jon
GTX_Admin:
Thanks Paul, much appreciated.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version