phpmyadmin / phpmyadmin/phpmyadmin
Too much time for a database import
Nobody has claimed this yet.
- 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:
-
Import a 90MB database locally (after send it via scp) via mysql:
mysql -u root -pPASS DB_NAME < /tmp/DUMP.sql
it takes 1m46s -
Import a 90MB database remotely via mysql:
mysql -u root -pPASS -h REMOTE_HOST DB_NAME < /tmp/DUMP.sql
it takes 1m50s -
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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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