504 Gateway Timeout error while selecting 300,000 rows from MySQL database

Question

I have a table orders with 30000rows. I am using Linode Server with 2GB RAM

but when i executed my query using phpmyadmin it give me 504 Gatetimeout Error

SELECT * FROM `orders`

I don't understand what's is the problem? i am getting that error you can see the image below

Answer 1

Add the following line to the file /etc/nginx/nginx.conf in the http{} block:
fastcgi_read_timeout 360;

Restart nginx :
sudo service nginx restart