PHP Version 8.3
AbanteCart Version 1.4.0
Template: Novator
Categories: 212 (17 parent categories, the rest childs)
The front end does ok and loads without resource spiking for the volume we get currently (4-5 concurrent users is generally the peak) but as soon as I start to edit a product in the admin section even with no current users hitting the site it causes the DB to spike in resources and often leads to 500 errors/timeouts for the front end.
can you run this sql-query in the same time with product editing?
SHOW PROCESSLIST;
It will show list of all queries and you can define what current sql-query overloads you DB.
But probably DB is not a cause.
Database connection can be expired because of some other thing's processing, for example, resizing of images. Resize works in the same http-request and connection to db is open at this point and waiting (php-lock).
You can try to enable debugging int the system->settings->system to see timings.
Or you can use xdebug profiling (for advanced users).
Probably you have some huge images of product that cannot be resized quickly or your host disk is slow etc..
Or some 3dparty extension slow down your admin..
Also you can look into cache speedup side.. redis or memcached.
Some different causes can be there.. it's require investigation.
