Re:How not to test that mysqld is alive
by KC8ZKF on Monday October 05, 2009 @12:39PM
(#862100)
'ps ax | grep [m]ysqld'
(The regex '[f]oo' will match 'foo' but not itself.)
[ Parent
| on HN ]
That's one of my favorite shell techniques.
Still, I think they're doing it wrong. For keeping daemons alive I rely on http://cr.yp.to/daemontools.html .
This is the correct answer -- when you fork the process yourself, you don't have to guess about it dying, you get SIGCHLD and can handle it accordingly.
If you use daemontools, this code is already written for you.
Can you use daemontools to monitor/kill/restart processes that run out of memory but don't exit?
Don't... You will still see someone else's 'grep mysql' as well as yours 'man mysql' and any command that just happens to include that string :/
Well, but why does that work? Doesn't it rely on the opposite outcome of the race condition mentioned in the article?
regex background: [abc] matches any of 'a', 'b', or 'c'. [m] matches only 'm'.
It works because the text to match is no longer included in the command line invoked to do the matching. Whether or not 'grep [m]ysqld' appears in the list produced by ps is irrelevant, as [m]ysqld does not match "m]ysqld". i.e. the 'm' matches, but then the match fails when it hits ']'.
tl;dr It's just a short way of matching "mysqld" without the matching pattern itself being "mysqld".
nope. doesn't.