Why might phpmyadmin not start/work?

Question

PHP

Hello. I work with a client site. The site is on a dedicated server. I go into phpmyadmin, run a simple sql query in the sql tab - everything works fine, I get the results. I launch a query to fill data into a table from a selection with a subquery - phpmyadmin freezes. When updating the page, phpmyadmin does not load, gives a 504 error. In this case, the customer's site is loaded normally. Tried uploading an hour later, two hours later - phpmyadmin doesn't work. He earned it the next day. I launch again simple request - works. I launch a query with a subquery without inserting data and it's simpler - it freezes again. This time they did not let him go the next day. Closing / changing the browser did not give any results.
Can you please tell me how to configure phpmyadmin so that it does not hang for so long? I understand. that a complex query with 70,000 records may not work in a minute, but hanging for hours is too much. I'm not an expert in servers, but I'll have to figure it out.

Answer 1

I understand. that a complex query with 70,000 records may not work in a minute, but hanging for hours is too much.

it is better to do such a thing through ssh (putty).
In general, increase max_execution_time, max_input_time, memory_limit in php.ini, increase
client_max_body_size, client_body_timeout, client_header_timeout, send_timeout in nginx.conf, and if puff like fcgi, then also increase these fastcgi_send_timeout and fastcgi_read_timeout timeouts
should help.