The site that I am working on is experiencing MySQL freeze ups any time after the 'Queries per second average'; seen on the STATUS output; is at 48-50 in value. When the site owner asked the hosting service about this they told him that the MySQL cannot go above that limit. He still has lots of CPU and RAM resources so it makes me wonder why? Is there a limitation to MySQL in this regard or is the host just trying to save on badwidth? ;)
Thanks for any insights,
Dan
Dan,
Is your web application running on a virtual server? If so, the ISP is likely limiting you to 50 queries/second so that you or someone else sharing this MySQL server won't hog the MySQL resources. For example, your ISP may have 10 users sharing the same MySQL database and if each web application gets 50 queries per second, that amounts to 10x50=500 queries per second in total. But if you're paying for a dedicated database server, then your ISP may be illicitly "sharing" your MySQL server with others because you should be able to get a few hundred queries per second at minimum.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
