Debugging sleeping connection with mySQL/optimize mySQL
$30-50 USD
Concluído
Publicado há quase 12 anos
$30-50 USD
Pago na entrega
Problem:
Tasks: 800 total, 10 running, 600 sleeping, 0 stopped, 0 zombie
I keep getting too many sleeping processes, but i have no idea how this happen.
I stopped apache/sql, a, and restart it, everythings fine.
Cycle repeats.
what i need is someone who can help me debug this problem and fix it. You might need to check my script for leaks.
max_concurrent_connection is 800.
website has around 11k unique visitors each day.
attached [login to view URL] and [login to view URL]
** freelancer must have expertise in mySQL and wordpress
** freelancer must keep the original files so that if his/her solution does not work i can revert the changes he/she made