After starting MySQL, I see only 1 process running (I expect 3 to start with) Don't know if it realy is a bug, but no-one replied to my question on the forum. If it's not a bug, can anyone explain me this? My old RH-system has 3 ps after starting mysql, and the mysql-site also mentions 3 processes Reproducible: Always Steps to Reproduce: /etc/init.d/mysql start Actual Results: mysql works, but I see only 1 pocess ... It doesn't spawn additional processes Expected Results: 3 processes when doing "ps" Dell 1650: Dual PIII 1,3 GHz - 1G ECC RAM CHOST="i686-pc-linux-gnu" CFLAGS="-march=pentium3 -O3 -pipe -fomit-frame-pointer" CXXFLAGS="${CFLAGS}"
there are 4 ps in debian when starting mysql
Yes, I also see it.. But if the mysql is processing some requests, the main proces is spawnig more (I have 25 ps some time). If there is no request, only one ps is in list... I also don't know if it is "feature" or "bug".
same poster did #15514. are you sure this "bug or feature" isnt related to that? i've not tested a USE=static build for mysql-2.23.55, maybe thats where problem is. as for my machine: root@lydian /root # ps ax | grep [m]ysqld | awk -F ' ' '{print $5" "$6}' /bin/sh /usr/bin/safe_mysqld /usr/sbin/mysqld --basedir=/usr /usr/sbin/mysqld --basedir=/usr /usr/sbin/mysqld --basedir=/usr /usr/sbin/mysqld --basedir=/usr root@gateway /root # ls -d /var/db/pkg/dev-db/mysql* /var/db/pkg/dev-db/mysql-3.23.55 -- i cant reproduce this.
This is not related to #15514 ... If I build it static, I can't use the MySQL server, so I built mysql again (without any special USE-flags): after that, mysql starts, I can connect, etc ... I'll try to stress-test the server, to see if more processes appear! (any hints on how to test a mysql-server in a decent way?) ---- host02 root # ps ax | grep [m]ysqld | awk -F ' ' '{print $5" "$6}' /bin/sh /usr/bin/safe_mysqld /usr/sbin/mysqld --basedir=/usr host02 root # ls -d /var/db/pkg/dev-db/mysql* /var/db/pkg/dev-db/mysql-3.23.54a
Can someone explain this? host02 bin # ps ax | grep [m]ysqld | awk -F ' ' '{print $5" "$6}' /bin/sh /usr/bin/safe_mysqld /usr/sbin/mysqld --basedir=/usr host02 bin # pstree -p | grep mysql |-safe_mysqld(16984)---mysqld(8733)---mysqld(9768)-+-mysqld(30823) | |-mysqld(16631) | |-mysqld(12812) | |-mysqld(5858) | |-mysqld(8497) | |-mysqld(24627) | |-mysqld(7327) | |-mysqld(22525) | |-mysqld(20187) | |-mysqld(30717) | `-mysqld(11426)
According to procps ebuild pkg_postins message the new procps utils no more shows threads in ps or top command... for showing all of it use -m in ps or H in top... So the only one process in ps ax for mysqld is not bug but feature... ps -axm show all three processes as expected :-))
ok, that explains ... Thanks a lot!