[no subject]

On Wed, 2004-04-14 at 21:23, James Sumners wrote:
> Okay, I was just trying to figure out if you were using PHP to connect. If you
> the mysql_pconnect() function to connect and you use the new worker (I think)
> model for apache2 the number of connections will get outrageous.
> 
> On Wed, 14 Apr 2004 21:12:11 -0400
> Christopher Fowler <cfowler at outpostsentinel.com> wrote:
> 
> > I've got a pool of 20 connections that are opened.
> > 
> > With the 3.2X version I have the following:
> > 
> > [tomcat at sam-devel bin]$ ps -ef | grep mysql
> > root     22868     1  0 21:08 pts/1    00:00:00 /bin/sh
> > /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
> > mysql    22892 22868  0 21:08 pts/1    00:00:00 /usr/libexec/mysqld
> > --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql
> > --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
> > tomcat   23098  4862  0 21:09 pts/1    00:00:00 grep mysql
> > [tomcat at sam-devel bin]$ netstat -n | grep 3306 | wc -l 
> >      46
> > 
> > Notice only one server process and 46/2 connections.  All connections
> > are via 127.0.0.1
> > 
> > On the new 4.0.18 I have this right after startup.
> > 
> > root     23134     1  2 21:11 pts/1    00:00:00 /bin/sh
> > /usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file
> > mysql    23165 23134  8 21:11 pts/1    00:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
> > --datadir=/var/li
> > mysql    23166 23165  0 21:11 pts/1    00:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
> > --datadir=/var/li
> > mysql    23167 23166  0 21:11 pts/1    00:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
> > --datadir=/var/li
> > mysql    23168 23166  0 21:11 pts/1    00:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
> > --datadir=/var/li
> > mysql    23169 23166  0 21:11 pts/1    00:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
> > --datadir=/var/li
> > mysql    23170 23166  0 21:11 pts/1    00:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
> > --datadir=/var/li
> > mysql    23171 23166  0 21:11 pts/1    00:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
> > --datadir=/var/li
> > mysql    23172 23166  0 21:11 pts/1    00:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
> > --datadir=/var/li
> > mysql    23173 23166  0 21:11 pts/1    00:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
> > --datadir=/var/li
> > mysql    23174 23166  0 21:11 pts/1    00:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
> > --datadir=/var/li
> > 
> > This is without any connections.
> > 
> > 
> > 
> > 
> > On Wed, 2004-04-14 at 21:00, James Sumners wrote:
> > > What are you using to connect to the database server?
> > > 
> > > On Wed, 14 Apr 2004 20:56:15 -0400
> > > Christopher Fowler <cfowler at outpostsentinel.com> wrote:
> > > 
> > > > I've just installed and compiled MySQL 4.  It seems I get a process now
> > > > for every database connection.  On the old version I saw only one
> > > > process.  Did I configure it wrong?
> > > > 
> > > > _______________________________________________
> > > > Ale mailing list
> > > > Ale at ale.org
&gt; &gt; &gt; &gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt; &gt; &gt; 
&gt; &gt; 
&gt; &gt; _______________________________________________
&gt; &gt; Ale mailing list
&gt; &gt; Ale at ale.org
&gt; &gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt; 


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00517" href="msg00517.html">[ale] Mysql 4</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Christopher Fowler)</li></ul></li>
<li><strong><a name="00518" href="msg00518.html">[ale] Mysql 4</a></strong>
<ul><li><em>From:</em> james at sumners.ath.cx (James Sumners)</li></ul></li>
<li><strong><a name="00519" href="msg00519.html">[ale] Mysql 4</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Christopher Fowler)</li></ul></li>
<li><strong><a name="00520" href="msg00520.html">[ale] Mysql 4</a></strong>
<ul><li><em>From:</em> james at sumners.ath.cx (James Sumners)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00520.html">[ale] Mysql 4</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00522.html">[ale] Fact Finding - ALE South?</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00520.html">[ale] Mysql 4</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00533.html">[ale] Encrypted document</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00521"><strong>Date</strong></a></li>
<li><a href="threads.html#00521"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>