- Plesk 12.5 for Linux
- Plesk 12.0 for Linux
It takes about 5 minutes to upload a 10Mb SQL dump via phpMyadmin. Process
sw-engine-fpm consumes nearly 100% of CPU:
# top ... Cpu(s): 99.6%us, 5.9%sy, 0.0%ni, 70.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.5%st
30123 psaadm 20 0 447m 33m 16m S 95.6 0.6 0:02.02 sw-engine-fpm
phpMyadmin performance issues with importing SQL dump.
In general, phpMyAdmin has performance issues with importing SQL dumps. In this case high CPU consumption by the
process is expected behavior.
In some cases, depending on dump structure, it is possible to speed up imports by delaying index generation via MySQL configuration:
2. Edit the MySQL configuration:
# vi /etc/my.cnf
3. Restart MySQL service:
For Debian-based distributions:
# service mysql restart
For RHEL-based distributions:
# service mariadb restart
Note: the setting "delay_key_write=ALL" should be disabled after database importing.
phpMyadmin4.4 is much slower than phpMyadmin3.5 for most operations.
The work on improvements already started on phpMyadmin. Contact phpMyadmin for more details.