I am getting the below error from AWS RDS because of so many connections.
"Too Many Connections"
when I try to debug this issue I run the below command in my MySQL server
"SHOW FULL PROCESSLIST;"
This command shows me 120 MySQL connections and 80 of them are on sleep mode.
After research, I found this is because of the command which runs every 30 minutes on my worker server to schedule email.
How can I reduce this MySQL sleep connection?