lsof comes in handy to match pid to socket and thus things like apache proc to running MySQL process.