I have a shop (Magento 1.9) with ~40.000 products. Every night they will be imported/updated via cronjob. There are other cronjobs that do various database operations as well.
In my import script there are also custom database connections (
Occasionally when the shop is crowded with visitors the database seems to be blocked with sleeping connections:
General error: 1205 Lock wait timeout exceeded.
I was relying upon magento to take care of the connections but it seems I was mistaken.
Now I am not sure if and at what point (after each use? after the script finished?) I should close those connections manually and what the implications are. Is it ok to simply kill all connections from time to time?