Hello everybody, nice to meet you, i really need your help , so my problem is:

i have one table, on this table passing data from api it may be 5,10,15 request per sec, so i have job watching on this table, when new records come it sends 20 request async by using plugin php zts thread and each has inside update on same table, so insert, update and select is on same table, when insert is coming from different users(host) and one of them has for example total 10k and 10 request per sec after few minute it crashed.

so can u help me advice or tell what can be problem or how to fix this ? any help pls.

thank you