How to see what services MySQL has run under Linux

Ps-ef|grep MySQL//current investigation of PID

And then

Lsof-p +pid can see the MySQL run service

Baidu out of other people's way

When encountering MySQL card, and then want to know why, I often use the following methods to find the problem

Show Processlist\g;    or show full processlist\g; Put this command in to indicate that there is no such command.

5. Row ***************************

id:197343

User:root

host:127.0.0.1:41354

Db:xxx

Command:query

time:0

State:sleep

Info:show Process List

After getting to the port, you can check the lower port access status

# Netstat-anp|grep 41354

TCP 0 0 127.0.0.1:41354 127.0.0.1:3307 established 1167/php test.php

So we know that PHP test.php is connected to the database, and the PID is 1167.

Position can be found lsof-p pid

This method is used to analyze what similar programs are connected to the database, resulting in a database card

Http://www.cpokooo.com
http://www.minzkw.com/
Http://www.kcfsyz.com
Http://www.jdsjsj.com
Http://www.fivezj.com
http://www.hhyeyp.com/
Ttp://www.lfgzjt.com
Http://www.wlgchem.com

How to see what services MySQL has run under Linux