recently i've done mass attribute update and noticed that i got new processes in DB, like that:
INSERT INTO `search_tmp_5b069a25b016d1_83026725` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0) + (0) + (0) + (0)) * 1) AS `score`
problem is that the never-ending, they slowing down the server and what is most important - they creating new same processes until server reaches pm.max_children parameter value and PHP-fpm die.
please advise what is nature of this processes and how to kill it completely? (if I kill existing ones - new are borns after some time)
p.s. indexer processes are not running.