Re: Problem: Too many connections
Hello. Have you been at: http://dev.mysql.com/doc/mysql/en/too-many-connections.html [snip] 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. [snip] sapna murari todwal [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem: Too many connections
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]
RE: Problem: Too many connections
Back to the original problem ;) Please post your my.cnf. -Original Message- From: Steve Buehler [mailto:[EMAIL PROTECTED] Sent: Samstag, 12. März 2005 16:02 To: mysql@lists.mysql.com Subject: Re: Problem: Too many connections 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
