Hi!
> "Michael" == Michael Bacarella <[EMAIL PROTECTED]> writes:
Michael> Well, looks like I found the culprit.
Michael> Increasing thread_cache_size from 0 to 50 totally alleviated the stress
Michael> (both on the database and our clients). Recommended by the manual,
Michael> of course.
T
Well, looks like I found the culprit.
Increasing thread_cache_size from 0 to 50 totally alleviated the stress
(both on the database and our clients). Recommended by the manual,
of course.
For list-archival's sake:
FreeBSD 4.3-STABLE
/etc/my.cnf:
[mysqld]
user=mysql
set-variable = wait_timeou
We upgraded our convergent e-business enterprise database server from mysql
3.22 to 3.23 yesterday. The upgrade process itself was smooth and
sexy.
Unfortunately, the dbms is overall slower for us. What's worse,
some maintenance scripts are losing their connections in the
middle of their runs.