I’m experiencing a significant performance issue with MySQL while executing queries on top of referencing my views and while executing that view which contains query of tables it is executing fine
enter image description here
It is generating the following error —–>
LIMIT 0, 1000 Error Code: 2013. Lost connection to MySQL server during query 30.016 sec
Here’s the output of only executing the view for context 🙂 enter image description here
I tried to changed DBMS connection keep-alive interval (in seconds) —–> 6000
DBMS connection read timeout interval (in seconds)----> 6000
DBMS connection timeout interval (in seconds) --------> 6000
even after changing these connection time still cant get output
Rustin_cohle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.