Is the max number of connections and active sessions mysql can have at one time? I'm running into the problem of too many persistent connections using phplib. Has anyone else had this type of problem before?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2001-10-14
how is your mysql configuration?? maybe if you post some more info about your config ...
for instance, a mysql config can look like this::
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = max_connections=100
set-variable = key_buffer=32M
set-variable = join_buffer=6M
set-variable = max_allowed_packet=2M
set-variable = table_cache=512
set-variable = sort_buffer=4M
set-variable = record_buffer=6M
set-variable = myisam_sort_buffer_size=8M
set-variable = thread_cache_size=16
set-variable = thread_stack=128K
.
.
.
how is yours? especially regarding the max connections... the exact amount mysql can handle will depend on your machine too i guess...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is the max number of connections and active sessions mysql can have at one time? I'm running into the problem of too many persistent connections using phplib. Has anyone else had this type of problem before?
how is your mysql configuration?? maybe if you post some more info about your config ...
for instance, a mysql config can look like this::
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = max_connections=100
set-variable = key_buffer=32M
set-variable = join_buffer=6M
set-variable = max_allowed_packet=2M
set-variable = table_cache=512
set-variable = sort_buffer=4M
set-variable = record_buffer=6M
set-variable = myisam_sort_buffer_size=8M
set-variable = thread_cache_size=16
set-variable = thread_stack=128K
.
.
.
how is yours? especially regarding the max connections... the exact amount mysql can handle will depend on your machine too i guess...