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
Here new_sales is my view
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