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
New contributor