100% of CPU load with an import SQL from sw-engine-fpm

[Henri]

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:

  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

 

[abdi]

Does the CPU increase to 100% when ONLY importing that SQL file?

 

[Henri]

Hello Albi,
No it happens even when I simply update the phpMyAdmin page with F5,
it looks something like this:

 PID USER PR NI VIRT RES SHR S% CPU% MEM TIME COMMAND +
30123 psaadm 20 0 447m 33m 16m S 20,6 0,6 0: 02.02 sw-Motor-fpm
1789 mysql 20 0 1186m 301m 7984 S 10.6 5.2 5: 31,19 mysqld
30126 psaadm 20 0 446m 33m 16m S 8,6 0,6 0: 01,79 sw-Motor-fpm
30125 psaadm 20 0 445m 32m 16m S 6,0 0,6 0: 02.01 sw-Motor-fpm
30127 psaadm 20 0 446m 33m 17m S 4,7 0,6 0: 01,48 sw-Motor-fpm
30121 psaadm 20 0 443m 30m 17m S 4,0 0,5 0: 01.97 sw-Motor-fpm
1428 sw-cp-se 20 0 46044 4168 1792 S 0,7 0,1 0: 04,77 sw-cp-serverd [/ code]
Grüße Henri[/COLOR][/FONT]
[QUOTE="abdi, post: 782748, member: 58278"]Does the CPU increase to 100% when ONLY importing that SQL file?[/QUOTE]

 

[abdi]

Normally if the table is extremely large with extremely many rows this sometimes can also slow the MySQL server responding...On some acassions I also noticed the no of open files limit causing PHP fpm slowing down

 

[finderX]

Simply use mysql via SSH. Import via phpMyAdmin very long and brutal.

mysql -uuser -ppassword databasename < /path/to/dump.sql

 

[Henri]

Hi Abdi,
thanks for your answer.
It is a Magento database in the database but is not yet in it, it's basically a very fresh Magento installation.

Do you have a limit set in the open files?

Greetings Henri

 

[abdi]

Do you have a limit set in the open files?

Yes, you can find the default limits in the file

cat /etc/security/limits.conf