MySQL 4.1.19 (no threads !?)

[cyrus]

Ever since we upgraded our servers to MySQL 4.1.19 (from 4.1.18), I've seen that there is only one thread serving all requests. Previously there used to be multiple threads running and I believe that there is some configuration missing with the new version. Could someone please guide me here.

For reference sake, I am using a normalized my.cnf

/etc/my.cnf

[mysqld]
set-variable = max_connections=500
safe-show-database
old_passwords
wait_timeout = 10
connect_timeout = 10

[Mysteerie]

I am assumming you mean process. Yes I am alos seeing that, though it seems fine to me. Not sure if all the extra processes or not will create less load faster mysql execution or not. Though if it does, then let me know as well.

[chirpy]

Ever since we upgraded our servers to MySQL 4.1.19 (from 4.1.18), I've seen that there is only one thread serving all requests. Previously there used to be multiple threads running and I believe that there is some configuration missing with the new version. Could someone please guide me here.

Probably more to do with your OS. Try:

ps axfm