How to get rid of the "Mysql server has gone away" error in Bitrix?

Question

PHP

Hello.
On a server under centOS with Bitrx-env, the exchange with 1C constantly drops with the error "Mysql server has gone away" and when using the site it happens that the same error appears. in after_connect.php and in my.cfg Didn't help.
$DB->Query("SET wait_timeout=57600");
max_allowed_packet=500M

Answer 1

Good afternoon,
Both of the settings done will not bring results.
I would advise you to make the following settings:
1) Update the exchange modules for 1C and Bitrix
2) Upload during the least load on the site
What are the characteristics of the server?
How many products/offers do you upload?
Are you uploading pictures?
DBMS version?
php version?

Answer 2

It is necessary to deal with such an error in more detail, as a temporary solution, I would suggest uploading files via csv, that is, collecting everything into a temporary file then load in file into mysql (a very fast method of 2 lyama lines in 10 seconds drives into the database on a weak machine
) if on the case, then analyze how long this miracle module 1c has been working here, it seems to me that the problem is in the connection that is falling or the request is too large.