Y
Y
Yuriy2021-07-06 15:28:03
1C-Bitrix
Yuriy, 2021-07-06 15:28:03

Bitrix table b_sale_fuser growing a lot?

Tell me how to track where the requests to write to the b_sale_fuser table come from. We
began to notice that records are constantly being written to the table, we do not have such a large project, there are not so many users who constantly work with the basket. every 2-5 seconds about 10-20 entries are written to a table of approximately 500,000 entries, the agent for deleting old baskets works, cleans old baskets in 7 days. But apparently there is a completely different problem here.
60e44b26a7b68360939389.jpeg

SELECT u.ID, b.ID FROM b_sale_fuser u
LEFT JOIN b_sale_basket b ON b.FUSER_ID=u.ID
WHERE b.ID IS NULL
ORDER BY u.ID DESC

Found lines: 413 708
it turns out 413 708 zombie lines, it is not clear where they are written all the time.

60e44b30d374b397488730.jpeg

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question