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