Re: increase mysql max connections over 1024
[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
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]
increase mysql max connections over 1024
Hello list, 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? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]