Hi,
We run a PHP/MySQL site on a Linux Red Hat Server. Dual 500MHz, 512 MB Ram.
Once we start getting 200+ concurrent MySQL connections, the load shoots up (sometimes over 10) and pages take 10 seconds + to generate, when they normally take < 1 second. (Sometimes, it takes minutes to generate the pages).
When I do a ps, each MySQL connection is using 3% or more of memory.
Would we be better of using non-persistent connections in this instance, or is this behavior unusual and fixable?
join_buffer | 131072
key_buffer | 33550336
max_connections | 225
max_join_size | 4294967295
max_sort_length | 1024
net_buffer_length | 16384
record_buffer | 520192
sort_buffer | 524280
version | 3.22.25
We run a PHP/MySQL site on a Linux Red Hat Server. Dual 500MHz, 512 MB Ram.
Once we start getting 200+ concurrent MySQL connections, the load shoots up (sometimes over 10) and pages take 10 seconds + to generate, when they normally take < 1 second. (Sometimes, it takes minutes to generate the pages).
When I do a ps, each MySQL connection is using 3% or more of memory.
Would we be better of using non-persistent connections in this instance, or is this behavior unusual and fixable?
join_buffer | 131072
key_buffer | 33550336
max_connections | 225
max_join_size | 4294967295
max_sort_length | 1024
net_buffer_length | 16384
record_buffer | 520192
sort_buffer | 524280
version | 3.22.25