search

jglamine / phamdb

Quickly create and modify Phamerator databases.
GNU General Public License v3.0
5 stars 5 forks source link

Database SQL import times out after 60 seconds #1

Closed jglamine closed 8 years ago

jglamine commented 8 years ago

When importing a database as an SQL file, the api request returns 504 after 60 seconds. NGINX is probably timing out the request.

jglamine commented 8 years ago

This happens when trying to load large sql dumps like from here: http://phamerator.csm.jmu.edu/sea/

Loading sql dumps using python mysql connector is extremely inefficient (I killed it after ~20 minutes). Switching to the 'mysql' command line tool takes just over 1 minute.

I'll also bump the nginx timeout to 1 hour.