Summary: | Only 1 MySQL process running | ||
---|---|---|---|
Product: | Gentoo Linux | Reporter: | D-Bugger <d-bugger> |
Component: | [OLD] Server | Assignee: | Donny Davies (RETIRED) <woodchip> |
Status: | RESOLVED INVALID | ||
Severity: | normal | CC: | mholzer, roman.majer |
Priority: | High | ||
Version: | unspecified | ||
Hardware: | x86 | ||
OS: | Linux | ||
Whiteboard: | |||
Package list: | Runtime testing required: | --- |
Description
D-Bugger
2003-02-11 16:12:49 UTC
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! |