Re: To thread or not to thread this is the question ..........

2001-02-01 Thread Jeremy D. Zawodny

On Wed, Jan 31, 2001 at 09:14:23PM +0100, Marcello Giovagnoli wrote:
 Hi,
 
 I have a problem with mysql 3.23.30 (binary distribution) and
 Slackware 7.
 
 Runnining different programs that access to database, the numbers of
 mysqld grow up.
 
 But when a single program exit, the number of mysqld processes
 should decrease by one.
 
 This works on RedHat 7.0 with the same mySQL distribution, but on
 Slackware 7 the number of mysqld never goes down, and they keep the
 maximum memory used in the last big query.
 
 So I tried to compile the last source distribution 3.23.32 on
 Slackware 7, but I got the same thing.
 
 I know that the mysqld should be threads not processes, and the
 memory used should be shared with all running mysqld, but something
 does not work properly.
 
 Do you think that the version of libpthread-0.8.so on Slackware 7
 could be the cause ? (RedHat 7.0 has the libpthread-0.9.so).
 
 I cannot upgrade the OS now, and I think that is not a nice idea
 moving on the fly libpthread-0.9.so from RedHat to Slackware (the
 system is up and there are 102 users connected !!!).
 
 Could someone help me ?

I'd suggest using a statically linked binary from the MySQL web
site. The fact that it's statically linked means that you don't have
to worry about other libraries that may or may not be buggy on your
system.

It sounds like you've done that, but if that's the case you should see
the same behavior on both systems. Are the MySQL configuration files
the same on both machines?

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




To thread or not to thread this is the question ..........

2001-01-31 Thread Marcello Giovagnoli

Hi,

I have a problem with mysql 3.23.30 (binary distribution) and Slackware 7.

Runnining different programs that access to database,  the numbers of mysqld 
grow up.

But when a single program exit, the number of mysqld processes should 
decrease by one.

This works on RedHat 7.0 with the same mySQL distribution, but on Slackware 
7 the number of mysqld never goes down, and they keep the maximum memory
used in the last big query.

So I tried to compile the last source distribution 3.23.32 on Slackware 7, 
but I got the same thing.

I know that the mysqld should be threads not processes, and the memory used
should be shared with all running mysqld, but something does not work 
properly.

Do you think that the version of libpthread-0.8.so on Slackware 7 could be 
the cause ? (RedHat 7.0 has the libpthread-0.9.so).

I cannot upgrade the OS now, and I think that is not a nice idea moving 
on the fly libpthread-0.9.so from RedHat to Slackware (the system is up and 
there are 102 users connected !!!).

Could someone help me ?

Thanks in advance.

marcello
-
marcello giovagnoli
Logical System s.r.l.
Via Rocco Scotellaro 23
60035 JESI AN
ITALY
e-mail: [EMAIL PROTECTED]
-

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php