We are running a TCP socket server in the node js application. Our server is receiving data from 500 devices every 5 seconds and inserting it into MySQL. So if we do the calculation then it means there are a total of 100 concurrent connections doing reading and inserting every one second. Due to that If we check MySQL cache, it increases a lot and after two to three days it freezes the socket server and no data get inserted into the database until I reboot. We need somebody to help us resolve this issue.