Repository metrics
- Stars
- (6,886 stars)
- PR merge metrics
- (Avg merge 2d 17h) (11 merged PRs in 30d)
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