multiple mysqld processes
I am running Fedora2 with mysql 4.0.21-standard and im noticing strange things with mysql.
I origianlly had mysql 3.23 then tried to get 4.0.21 installed and finally did but mysql 4 isnt acting like it should.
If I type 'service mysqld start' to start it and then i type 'mysql' and im in!
But, i also typed 'ps -A |grep mysqld*' to see how many processes there are and i see about 10!
28515 tty1 00:00:00 mysqld_safe
28547 tty1 00:00:00 mysqld
28548 tty1 00:00:00 mysqld
28549 tty1 00:00:00 mysqld
28550 tty1 00:00:00 mysqld
28551 tty1 00:00:00 mysqld
28552 tty1 00:00:00 mysqld
28553 tty1 00:00:00 mysqld
28554 tty1 00:00:00 mysqld
28555 tty1 00:00:00 mysqld
28556 tty1 00:00:00 mysqld
i run killall mysqld a few times and it finally kils them all but i try to start the service again and the 10 processes appear.
another thing is. I dont see mysqld running when i type 'top' to view the processes?
Is there something different with 4.0.21-standard?
i looked at some threads that are related and I checked perms on most of the mysql files and they are owned my mysql...the only file that is owned by root is mysqld_safe.