List:General Discussion« Previous MessageNext Message »
From:sasha Date:June 15 2000 4:12am
Subject:Re: Increasing Max connections
View as plain text  
gretchenl wrote:
> 
> How many people have had to increase there max number of connections for MySQL?  I
> have a pretty nice web server.  Dual Pentium III 600's, 512 megs of ram. etc etc.  What
> are some suggested performance tuning options that will help MySQL?  I am pretty concerned
> with here people about raising the connections.  Also, is there a way of increasing the
> amount of connections without using a my.cnf or my.ini?  Are the options in the
> example.cnf the same as the default variables of MySQL when used with out the cnf?
> 
> gl

put 

set-variable    = max_connections=2000

in /etc/my.cnf

The only reason for this limit is to keep mysqld from taking your system down my
running it out of resources. The more resources you have, the higher you should
set it.
-- 
Sasha Pachev

+------------------------------------------------------------------+
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sasha@stripped  |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+
Thread
misleading socket info in INSTALL-SOURCEterry jones12 Apr
  • Re: Increasing Max connectionsJF Prieur15 Jun
  • Re: Increasing Max connectionssasha15 Jun
  • Re: Increasing Max connectionssasha15 Jun
  • Re: Increasing Max connections (the right way)cfaber15 Jun
  • Re: Increasing Max connections (the right way)Jason Murphy15 Jun