Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - How To Kill "SLEEP" in MySQL?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How To Kill "SLEEP" in MySQL?

 Post Reply Post Reply
Author
hassanx View Drop Down
Newbie
Newbie


Joined: 29 January 2006
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote hassanx Quote  Post ReplyReply Direct Link To This Post Topic: How To Kill "SLEEP" in MySQL?
    Posted: 29 January 2008 at 8:25pm
Hi there,

I have both WordPress and WebWiz Forums working on my server (Brinkster). But for the last month i get 9 SLEEP functions valuing more than 1000 (i haven't found why) in just 1 hour after i restart. And then max_user_connections error.

Here's the picture:



Is there any ASP codes to kill these threads routinely?


I both have a fresh install of WebWiz and Wordpress. They haven't had any problems for months. And ironically, these days the visitor level is at the bottom; even though this problem occurs.

Will moving to an MSSQL server just dedicated to WebWiz helps?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 30 January 2008 at 4:33am
It looks like Brinkster have a connection limit of 10 of your database!

This is very low, you should ask them to increase this, if they don't tell them that you are changing hosts as this is a very low amount.

Moving to SQL Server will help but only as in you are splitting the load across 2 database.

Web Wiz Forums will run much better under SQL Server, but you should look for a host offering SQL Server 2005 to take advantage of the speed increases.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.