[Subject Prev][Subject Next][Thread Prev][Thread Next][Subject Index][Thread Index]

Re: Re: urgent .How do i get more threads in MySQL server

 If i run my MySQL server with "safe_mysqld --set-variables
max_connections = 1000 " it allows  up 1000 connections with out
recompiling glibc. But i think i have to recompile my MySQL and glibc
for better performance. 

>-------- ORIGINAL MESSAGE BELOW --------
>On Thu, Dec 07, 2000 at 12:13:41AM +0530, abhishek wrote:
>> hello everybody
>>       My problem is my MySQL server only allows 100 threads to
>> connect to it. After 100 threads i get error message "Lost connection
>> to MySQL server during query". I have read some doumentation for it
>> it says to Increase PTHREAD_THREADS_MAX in
>> 'sysdeps/unix/sysv/linux/bits/local_lim.h' to 4096 and decrease
>> STACK_SIZE in `internals.h' to 256 KB.
>>       But i found local_lim.h at "/usr/include/bits/local_lim.h" and
>> "/usr/i386-glibc21-linux/include/bits/local_lim.h" andBut i found the
>> value of PTHREAD_THREADS_MAX = 1024 . and i don't found internals.h
>> I am running MySQL-3.22.25-1 on redhat 7.0   
>You need to recompile glibc using those values. Get hold of the CD
>that contains SRPMs.
>	-Arun
>The mailing list archives are available at