Hey all,

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.

any ideas?

Thanks,

lenny

Hey me again,

I actually see the process when i do a top:

28515 root 25 0 5648 1172 3948 S 0.0 0.3 0:00.01 mysqld_safe
28547 mysql 16 0 47684 11m 4516 S 0.0 2.7 0:00.05 mysqld
28548 mysql 16 0 47684 11m 4516 S 0.0 2.7 0:00.00 mysqld
28549 mysql 20 0 47684 11m 4516 S 0.0 2.7 0:00.00 mysqld
28550 mysql 22 0 47684 11m 4516 S 0.0 2.7 0:00.00 mysqld
28551 mysql 23 0 47684 11m 4516 S 0.0 2.7 0:00.00 mysqld
28552 mysql 20 0 47684 11m 4516 S 0.0 2.7 0:00.00 mysqld
28554 mysql 16 0 47684 11m 4516 S 0.0 2.7 0:00.03 mysqld

I would really like to know why there are so maany..are they child processes?

Lenny

By default in later versions it starts more processes to improve performance. If your familiar with Apache, it does the same thing.