What is the difference between the number of MySQL processes and the number of connections

How to count the number of MySQL processes, and how to count the number of MySQL connections, the number of processes and the number of connections what difference

Reply content:

How to count the number of MySQL processes, and how to count the number of MySQL connections, the number of processes and the number of connections what difference

mysqladmin -uuser -ppasswd status;The Threads current number of MySQL connections is represented in the
ps -axef | grep mysqld -c; Value-2 (-1) is the number of processes.

Number of threads set by the variable max_connections number of processes is how many MySQL (well, a bit farfetched) started.

The most intuitive explanation is: The number of connections is the number of threads, the number of processes is: number of processes

