Hello, together,
I have a problem in Plesk 12 on Centos 6. 6.
Follower: I have imports in via phpMyAdmin a file SQL, this process lasted rather long (the file SQL is approx. 10 mb) I tried whole over again the import, however, though ran through it lasted felt 5 minutes, then I have looked via SSH sometimes with top how high the load is to examine whether there is a problem with the MySQL version.
Indeed, MySQL is not the problem sw separate engine fpm, sw engine fpm does the CPU on just 100%, no miracle the import so long lasts.
Enclosed the extract from top like he to the import of the file SQL looked:
In the LOG under:/var/log/sw_cp_server/sw-engine. log is to be seen nothing remarkable.
Does somebody have an idea or similar problems?
The file SQL is from Magento (sample Data for Magento)
Greetings Henri
I have a problem in Plesk 12 on Centos 6. 6.
Follower: I have imports in via phpMyAdmin a file SQL, this process lasted rather long (the file SQL is approx. 10 mb) I tried whole over again the import, however, though ran through it lasted felt 5 minutes, then I have looked via SSH sometimes with top how high the load is to examine whether there is a problem with the MySQL version.
Indeed, MySQL is not the problem sw separate engine fpm, sw engine fpm does the CPU on just 100%, no miracle the import so long lasts.
Enclosed the extract from top like he to the import of the file SQL looked:
Code:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25026 psaadm 20 0 500m 85m 16m R 97.4 1.5 2:21.69 sw-engine-fpm
1789 mysql 20 0 1186m 315m 7980 S 1.3 5.4 4:12.25 mysqld
2127 root 20 0 1346m 15m 2424 S 0.3 0.3 7:55.30 fail2ban-server
In the LOG under:/var/log/sw_cp_server/sw-engine. log is to be seen nothing remarkable.
Does somebody have an idea or similar problems?
The file SQL is from Magento (sample Data for Magento)
Greetings Henri