Re: increase mysql max connections over 1024

2002-06-17 Thread Osamu Aoki
[changed back to right ML]

This is better aproach :)

On Sun, Jun 16, 2002 at 04:54:42PM -0400, Jeff S Wheeler wrote:
 On Sun, 2002-06-16 at 04:24, Osamu Aoki wrote:
   *snip*
  If what you say is true, I can tell you that ANY program which is
  involved with mysql and which used local_lim.h needs to be recompiled.
  What I do not know is whether this involves glibc (libc6) or not.
 
 Why would this be the case?  

Question, I thoght, was My question is, what should I do after modify
this file. Should I rebuild mysql-server .deb package again? Or I just
set mysql max connections and restart mysql server?

So my answer was recompile because changing local_lim.h is not enough
to change behavior of libc6.

 I might be missing something, but I believe the poster is just
 discussing making a change to the mysql-server, NOT the libmysqlclient
 library.
 
 Any library dependencies of the mysqld server (ldd bin/mysqld ?) would
 need to be rebuilt, probably including libc, but you could always keep
 private copies of them and use LD_LIBRARY_PATH to avoid changing the
 system-wide libc, and thus necessitating a rebuild of other sources
 which depend on that limit being consistent between themselves and their
 dependencies.

Sounds very good too me. 

 Am I off my rocker?  I know it's not a real clean solution, keeping a
 seperate copy of libc, but it seems workable.
-- 
+++
+  Osamu Aoki [EMAIL PROTECTED] @ Cupertino, CA USA +


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]



Re: increase mysql max connections over 1024

2002-06-16 Thread Osamu Aoki
On Fri, Jun 14, 2002 at 12:58:31PM +0800, Patrick Hsieh wrote:
 I'd like to increase the number of max connections above 1024 in Linux.
 I think I have to increase PTHREAD_THREADS_MAX  in 
 
 /usr/include/bits/local_lim.h
 
 /* The number of threads per process.  */
 #define _POSIX_THREAD_THREADS_MAX   64
 /* This is the value this implementation supports.  */
 #define PTHREAD_THREADS_MAX 1024
 
 
 My question is, what should I do after modify this file. Should I
 rebuild mysql-server .deb package again? Or I just set mysql max
 connections and restart mysql server?

I am not expert ...

If what you say is true, I can tell you that ANY program which is
involved with mysql and which used local_lim.h needs to be recompiled.
What I do not know is whether this involves glibc (libc6) or not.

Anyway, at root

# apt-get source mysql-server
# cd mysql-server*

Check source for what happens debian/rules binary.

-- 
~\^o^/~~~ ~\^.^/~~~ ~\^*^/~~~ ~\^_^/~~~ ~\^+^/~~~ ~\^:^/~~~ ~\^v^/~~~ +
 Osamu Aoki @ Cupertino CA USA
 See User's Guide: http://www.debian.org/doc/manuals/users-guide/
 See Debian reference: http://www.debian.org/doc/manuals/reference/
 Debian reference Project at: http://qref.sf.net

 I welcome your constructive criticisms and corrections.


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]