phpmyadmin/phpmyadmin

Import from uploaded file is very slow and gets time-out on LEMP (tested with with version 4.7.6, 4.7.9)

Open

#14,123 opened on Mar 25, 2018

View on GitHub
 (16 comments) (1 reaction) (0 assignees)PHP (6,886 stars) (3,454 forks)batch import
help wanted

Description

Test file: TEST generated data

~4MB compressed (~107MB uncompressed) SQL database fails to import in 5 minutes (gets web server timeout).

File uploads in seconds and starts to import. But the data is inserted very slow.

The same file on the same server, using pma 4.0.10.20, import finishes in ~30 seconds. (Importing through mysql cli tool finishes in ~20s).

Steps to reproduce

Try to import database dump

Table Ascending Action Rows Type Collation Size Overhead
gd_cities                5,347 InnoDB latin1_swedish_ci 320 KiB
gd_configurations        0     InnoDB latin1_swedish_ci 16 KiB
gd_configuration_history 0     InnoDB latin1_swedish_ci 16 KiB
gd_countries             21    InnoDB latin1_swedish_ci 16 KiB
gd_first_names           1,172 InnoDB latin1_swedish_ci 64 KiB
gd_last_names            1,000 InnoDB latin1_swedish_ci 64 KiB
gd_regions               385   InnoDB latin1_swedish_ci 64 KiB
gd_sessions              1     InnoDB latin1_swedish_ci 16 KiB
gd_settings             17     InnoDB latin1_swedish_ci 32 KiB
gd_user_accounts         1     InnoDB latin1_swedish_ci 16 KiB
myTable                 64,000 InnoDB latin1_swedish_ci 124.6 MiB
-----------
 11 tables Sum 71,944 InnoDB latin1_swedish_ci 125.3 MiB 0 B

Expected behaviour

Import finishes in about 30seconds (the same, as 4.0 versiona and cli)

Actual behaviour

Gets gateway timeout, or "Script timeout passed, if you want to finish import, please resubmit the same file and import will resume."

Server configuration

Operating system: Ubuntu 16.04.3 LTS Web server: nginx/1.10.3 Database: 5.7.21-0ubuntu0.16.04.1 PHP version: 7.2.2-3+ubuntu16.04.1+deb.sury.org+1 phpMyAdmin version: problem tested on 4.7.6 and 4.7.9

Client configuration

Browser: Chrome Operating system: Windows 10

Contributor guide