I'm encountering an issue with phpMyAdmin:
Issue: Slow Query Timeout When using phpMyAdmin to execute a query on a large table, the query takes too long and eventually times out. I receive a "504 Gateway Timeout" error during the query execution, particularly when working with tables that contain over a million records.
I've verified that MySQL is running on the server and there are no connection issues. However, this timeout error persists when running large database queries through phpMyAdmin.
Is there a way to optimize phpMyAdmin or MySQL settings to handle these large queries more efficiently? Should I increase the timeout limits, or is there another configuration I should adjust?
Thank you