At 01:25 AM 3/12/2005, sapna murari todwal wrote:
Hi,
I have a live site using mysql. It is heavily used with over thousand users per minute, with 3 select / update queries per user per minute accounting to over 3000 queries per minute.
The problem is that many times connection to this mysql server fails with the error "Too many connection" also sometimes the server becomes down bcoz of overload. The server has around 4GB of RAM with mysql version of 4.0.23
So my question is , is the problem related with just tuning of configuration parameters or can the problem be solved by any means too. Any kind of help is deeply appreciated.
Is it a single or dual processor? Processor Speed? Operating system? Type of database.....INNODB, MyISAM? I don't have that many connections on any of my machines. Since you are saying that your server is being overloaded and bogged down you might think about having a fast backend mysql cluster ( http://www.mysql.com/cluster ) instead of it on the same machine as your web server. Possibly even a cluster for the web servers too, but you might not need that. I am more curious about your processor(s).
We are creating a program that because of the high hits that we are expecting (actually more about processing then the number of hits through the web server itself), will have to have 3 clusters of servers to run it. One cluster will be for the backend MySQL servers using MySQL's new (or relatively new) clustering. I have never used it yet, but I think it would need at least 3 or 4 servers just to run it at its minimum for what we are going to be doing. The second cluster will be for the web frontend. We actually might be able to get away with just one frontend web server instead of the cluster though. The third cluster will be for the special program that takes a minimum of 30 minutes (on a small test) to run for each client. Some tests on live data have taken more than 5 hours to do all of the computations on a dual XEON with 2 gigs of mem. You are getting more hits than we expect in any minute to your web server, but we will probably have more hits to the DB than you......maybe. :) Or at least hits that take longer to get all of the data they need.
Steve
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
