MySQL performance issue while executing Views : Not showing output while writing query referencing the view

  Kiến thức lập trình

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

Rustin_cohle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Theme wordpress giá rẻ Theme wordpress giá rẻ Thiết kế website