Slow Save & "MySQL gone away" Error - Problem

[Shantonu Acharjee]

I'm providing an update on my product saving issue on PrestaShop 8.2.0, hosted on a Hostinger Business plan. Thank you for the help so far.

The Original Problem (Still Happening):

Saving a product is always slow. When I assign many categories (10-15+), the save process takes over a minute and fails with a General error: 2006 MySQL server has gone away error.

Troubleshooting Update:

• I recently enabled a visitor tracking module and thought it might be causing the slowdown.
• I have now completely disabled that module and cleared the cache.

Unfortunately, the problem is not solved. The exact same issue persists: saves are slow, and it fails when many categories are involved.

The Full Error Message (Still the Same):

An unexpected error occurred. [Doctrine\DBAL\Exception\ConnectionLost code 0]: An exception occurred while executing 'SELECT ...': SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

Revised Question:

Since disabling the module had no effect, my focus is back on a server configuration or database performance issue. The operation to link a product to many categories seems too slow for my server's timeout limit.

What are the specific values for MySQL settings like wait_timeout and max_allowed_packet that I should ask Hostinger support to set?

Could this be a deeper problem, like poor database indexing on the ps_category_product table, that makes the query itself too slow?

Any further ideas would be greatly appreciated. Thank you.