phpmyadmin / phpmyadmin/phpmyadmin

Too much time for a database import

Open
#14,397 3 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

help wanted
Dominant language
PHP
Stars
7.9k
Forks
3.6k
Avg merge
4d 18h
Merged PRs (30d)
36

Description

Hello,

we know that having a remote host, a local import with mysql is faster than phpmyadmin because there is no time to upload the database, but I noticed something strange and I made the following tests:

  1. Import a 90MB database locally (after send it via scp) via mysql:
    mysql -u root -pPASS DB_NAME < /tmp/DUMP.sql
    it takes 1m46s

  2. Import a 90MB database remotely via mysql:
    mysql -u root -pPASS -h REMOTE_HOST DB_NAME < /tmp/DUMP.sql
    it takes 1m50s

  3. Import a 90MB database remotely via phpmyadmin:
    it takes 12m

I guess there is something bad but I don't know where.

I'm using Gentoo as OS, I have nginx+php fpm, following some useful data from php.ini:
max_execution_time = 8000
upload_max_filesize = 2048M
memory_limit = 1024M
post_max_size = 4096M

From php-fpm.conf I have:
php_admin_value[memory_limit] = 1024M

Server configuration

Operating system:
Gentoo Linux

Web server:
Nginx

Database:
Mariadb-10.1.29

PHP version:
5.6.33

phpMyAdmin version:
4.8.1

Client configuration

Browser:
Chromium-67.0.3396.62

Operating system:
Gentoo Linux

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the three 90MB import timings using the reported Gentoo, Nginx, PHP-FPM, MariaDB, PHP, and phpMyAdmin versions and configuration. Compare the phpMyAdmin import path with the direct mysql commands to isolate the bottleneck. Done means identifying a reproducible cause and documenting or fixing the slower behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
mariadb, mysql, php
Domain
databases, performance
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.