Database interaction optimization

[ashokhs77]

HI All,

I am seeing that the query to DB and its response is becoming a bottleneck when sudden bursts of attach request is received from multiple UEs - causing either attach reject or delayed attaches or immediate releases post attach.

Any ideas to optimize this interface ?

I am using mysql with pyhss.

Have disabled TLS between the two. But still the issue persists.

Thanks & Regards,
Ashok

[alexeymx]

To be honest I used postgress engine and added some indexes to improve speed and use postgress pool for HA setup that would definitely help you

[ashokhs77]

Thanks for the quick response.

Any guidelines on how to use that ?

Thanks again & Regards,
Ashok

[alexeymx]

In config yaml change engine name and than find slow log of postgress and add indexes to improve speed

Related to HA setup is quite complex. I installed HA cluster in Kuberbetes deployment via Helm same as pyhss with load balancer front-ends

Thanks for the quick response.

Any guidelines on how to use that ?

Thanks again & Regards,
Ashok