Hi Team,
I am checking the total connections attempted to my local mysql.
Below are results of query "Show status like ‘%conn%’ "
Connections = 280
Max_used_connections = 21
threads_connected = 20
After show full processlist, I got all 20 records with ‘Sleep’. (Sleep means non-active?)
what is the status of 280 - 21 = 259 connections. Are these Ideal connection?
Will wait_timeout settings will close all ideal connections?
Please help.