Hi,
We are using MySQL 5.7.22 On windows-2012R(16gb RAM,12 gb innodb buffer pool size)machine and we have observed many new threads have been created(1938) and threads_cached(4),threads connected(198) and threads running(4) therefore i am suspecting we need to tune thread cache size therefore kindly help how to determine required thread cache size and tune? However, i have seen many queries are sleep and is it feasible to reduce wait time out from default 28800 sec to lower number?
Thanks in advance.
Regards,
Upender