Sample Header Ad - 728x90

why processlist list shows limited threads

0 votes
1 answer
341 views
Actually I have set **max_connection** value set to **500** but processes shows only **266** i.e when I run **show full processlist** it shows only 266 processes not more than this however my connection value is 500. I analyzed every query and found that every query is using single table there is no query which is using 2 tables. Is any other settings which I am missing? Please suggest on this.Why it is showing only 266 processes?
Asked by Moolya (1 rep)
May 19, 2021, 08:38 AM
Last activity: Jul 24, 2025, 03:05 AM