Problem Create Categories And Product

[CoPeRniX]

Hi,

 

 

I have a problem that is driving me crazy .  When creating a category or product is extremely slow.

 

It appears that Prestashop is having to make changes to the database entry for each category when it adds a new category, as I am seeing the following messages being passed between Prestashop and MySQL:

09:26:30.216997 sendto(3, "Z\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 7, nright = 8\n\t\t\tWHERE id_category = 571 LIMIT 1\n\t\t", 94, MSG_DONTWAIT, NULL, 0) = 94 <0.000033>
09:26:30.217112 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.244333>
09:26:30.461513 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 3769, MSG_DONTWAIT, NULL, NULL) = 52 <0.000034>
09:26:30.461787 sendto(3, "[\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 9, nright = 10\n\t\t\tWHERE id_category = 677 LIMIT 1\n\t\t", 95, MSG_DONTWAIT, NULL, 0) = 95 <0.000033>
09:26:30.461879 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.149288>
09:26:30.611238 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 3717, MSG_DONTWAIT, NULL, NULL) = 52 <0.000033>
09:26:30.611399 sendto(3, "[\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 6, nright = 11\n\t\t\tWHERE id_category = 564 LIMIT 1\n\t\t", 95, MSG_DONTWAIT, NULL, 0) = 95 <0.000081>
09:26:30.611529 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.149704>
09:26:30.761296 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 3665, MSG_DONTWAIT, NULL, NULL) = 52 <0.000024>
09:26:30.761442 sendto(3, "\\\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 13, nright = 14\n\t\t\tWHERE id_category = 574 LIMIT 1\n\t\t", 96, MSG_DONTWAIT, NULL, 0) = 96 <0.000028>
09:26:30.761803 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.132906>
09:26:30.894812 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 3613, MSG_DONTWAIT, NULL, NULL) = 52 <0.000064>
09:26:30.894994 sendto(3, "\\\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 12, nright = 15\n\t\t\tWHERE id_category = 567 LIMIT 1\n\t\t", 96, MSG_DONTWAIT, NULL, 0) = 96 <0.000064>
09:26:30.895159 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.124808>
09:26:31.020036 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 3561, MSG_DONTWAIT, NULL, NULL) = 52 <0.000029>
09:26:31.020294 sendto(3, "\\\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 17, nright = 18\n\t\t\tWHERE id_category = 575 LIMIT 1\n\t\t", 96, MSG_DONTWAIT, NULL, 0) = 96 <0.000063>
09:26:31.020443 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.243550>
09:26:31.264111 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 3509, MSG_DONTWAIT, NULL, NULL) = 52 <0.000089>
09:26:31.264327 sendto(3, "\\\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 16, nright = 19\n\t\t\tWHERE id_category = 568 LIMIT 1\n\t\t", 96, MSG_DONTWAIT, NULL, 0) = 96 <0.000089>
09:26:31.264542 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.056070>
09:26:31.320668 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 3457, MSG_DONTWAIT, NULL, NULL) = 52 <0.000029>
09:26:31.320808 sendto(3, "\\\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 21, nright = 22\n\t\t\tWHERE id_category = 576 LIMIT 1\n\t\t", 96, MSG_DONTWAIT, NULL, 0) = 96 <0.000023>
09:26:31.320884 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.041722>
09:26:31.362677 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 3405, MSG_DONTWAIT, NULL, NULL) = 52 <0.000030>
09:26:31.362823 sendto(3, "\\\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 23, nright = 24\n\t\t\tWHERE id_category = 680 LIMIT 1\n\t\t", 96, MSG_DONTWAIT, NULL, 0) = 96 <0.000030>
09:26:31.362909 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.159660>
09:26:31.522665 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 3353, MSG_DONTWAIT, NULL, NULL) = 52 <0.000043>
09:26:31.522840 sendto(3, "\\\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 20, nright = 25\n\t\t\tWHERE id_category = 569 LIMIT 1\n\t\t", 96, MSG_DONTWAIT, NULL, 0) = 96 <0.000037>
09:26:31.522936 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.449024>
09:26:31.972049 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 3301, MSG_DONTWAIT, NULL, NULL) = 52 <0.000033>
09:26:31.972252 sendto(3, "\\\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 27, nright = 28\n\t\t\tWHERE id_category = 577 LIMIT 1\n\t\t", 96, MSG_DONTWAIT, NULL, 0) = 96 <0.000029>
09:26:31.972332 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.159507>
09:26:32.131919 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 3249, MSG_DONTWAIT, NULL, NULL) = 52 <0.000025>
09:26:32.132104 sendto(3, "\\\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 26, nright = 29\n\t\t\tWHERE id_category = 570 LIMIT 1\n\t\t", 96, MSG_DONTWAIT, NULL, 0) = 96 <0.000026>
09:26:32.132188 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.123600>
09:26:32.255873 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 3197, MSG_DONTWAIT, NULL, NULL) = 52 <0.000028>

This goes on for a few minutes:

09:28:21.272048 sendto(3, "a\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 3066, nright = 3067\n\t\t\tWHERE id_category = 1634 LIMIT 1\n\t\t", 101, MSG_DONTWAIT, NULL, 0) = 101 <0.000027>
09:28:21.272443 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.032739>
09:28:21.305277 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 2152, MSG_DONTWAIT, NULL, NULL) = 52 <0.000025>
09:28:21.305455 sendto(3, "a\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 3068, nright = 3069\n\t\t\tWHERE id_category = 1735 LIMIT 1\n\t\t", 101, MSG_DONTWAIT, NULL, 0) = 101 <0.000025>
09:28:21.305541 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.041474>
09:28:21.347102 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 2100, MSG_DONTWAIT, NULL, NULL) = 52 <0.000034>
09:28:21.347274 sendto(3, "a\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 3070, nright = 3071\n\t\t\tWHERE id_category = 1736 LIMIT 1\n\t\t", 101, MSG_DONTWAIT, NULL, 0) = 101 <0.000027>
09:28:21.347358 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.046332>
09:28:21.393777 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 2048, MSG_DONTWAIT, NULL, NULL) = 52 <0.000025>
09:28:21.393931 sendto(3, "a\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 3061, nright = 3072\n\t\t\tWHERE id_category = 1631 LIMIT 1\n\t\t", 101, MSG_DONTWAIT, NULL, 0) = 101 <0.000025>
09:28:21.394109 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.041327>
09:28:21.435528 recvfrom(3, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 1 Changed: 0 Warnings: 0", 1996, MSG_DONTWAIT, NULL, NULL) = 52 <0.000025>
09:28:21.435686 sendto(3, "a\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 3073, nright = 3074\n\t\t\tWHERE id_category = 1744 LIMIT 1\n\t\t", 101, MSG_DONTWAIT, NULL, 0) = 101 <0.000026>
09:28:21.435766 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.036533>
09:28:21.472392 recvfrom(3, "0\0\0\1\0\1\0\2\0\0\0(Rows matched: 1 Changed: 1 Warnings: 0", 1944, MSG_DONTWAIT, NULL, NULL) = 52 <0.000029>
09:28:21.472560 sendto(3, "[\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 2, nright = 3075\n\t\t\tWHERE id_category = 2 LIMIT 1\n\t\t", 95, MSG_DONTWAIT, NULL, 0) = 95 <0.000025>
09:28:21.472659 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.091374>
09:28:21.564139 recvfrom(3, "0\0\0\1\0\1\0\2\0\0\0(Rows matched: 1 Changed: 1 Warnings: 0", 1892, MSG_DONTWAIT, NULL, NULL) = 52 <0.000027>
09:28:21.564411 sendto(3, "[\0\0\0\3\n\t\t\tUPDATE ps_category\n\t\t\tSET nleft = 1, nright = 3076\n\t\t\tWHERE id_category = 1 LIMIT 1\n\t\t", 95, MSG_DONTWAIT, NULL, 0) = 95 <0.000026>
09:28:21.564787 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}]) <0.037664>
09:28:21.602542 recvfrom(3, "0\0\0\1\0\1\0\2\0\0\0(Rows matched: 1 Changed: 1 Warnings: 0", 1840, MSG_DONTWAIT, NULL, NULL) = 52 <0.000025>

 

I thought it might be due to url 's friendly . I've disabled but continued with the same problem.

 

I hope your help.

 

Thanks,

Regards.

Edited December 18, 2015 by CoPeRniX (see edit history)

[CoPeRniX]

Please Help ?

[CoPeRniX]

 

Can you help me?

 

It is normal that when upgrading a category prestashop UPDATE perform other categories ? This makes it very slow creating categories .