[ale] Mysql 4

James Sumners james at sumners.ath.cx
Wed Apr 14 21:23:56 EDT 2004


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
> > > http://www.ale.org/mailman/listinfo/ale
> > 
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale


-- 

I used to be interested in Windows NT, but the more I see of it the more it
looks like traditional Windows with a stabler kernel. I don't find anything
technically interesting there. In my opinion MS is a lot better at making money
than it is at making good operating systems.  -- Linus Torvalds



More information about the Ale mailing list