Debugging sleeping connection with mySQL/optimize mySQL

Completado Publicado Jul 12, 2012 Pagado a la entrega
Completado Pagado a la 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 [url removed, login to view] and [url removed, login to view]

** 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

Apache MySQL PHP WordPress

Nº del proyecto: #2324600

Sobre el proyecto

9 propuestas Proyecto remoto Activo Jul 14, 2012

Adjudicado a:

itamarjp

please check pm.

$50 USD en 0 días
(43 comentarios)
4.8

9 freelancers están ofertando un promedio de $53 por este trabajo

rajeshsonisl

Clear with requirement. Quality work assured. Ready to get started. Thanks.

$150 USD en 1 día
(398 comentarios)
7.0
ancientb

Hello,i can start immediately.

$50 USD en 2 días
(28 comentarios)
4.5
liuxinran

Hi, please check the PM.

$50 USD en 1 día
(15 comentarios)
4.1
jenzeerbasheer

Hello WordPress MySQL expert here.

$30 USD en 1 día
(12 comentarios)
4.0
garhwalsatyapal

ready to work with you

$30 USD en 0 días
(8 comentarios)
3.5
F8K9bMf4D

Custom software development - <b><i>Removed by Admin</i></b>

$50 USD en 1 día
(0 comentarios)
0.0
sankalplondon13

Please let me know when we need to start the work for u . I am also on Skype add me as sankalpsaxena7

$35 USD en 1 día
(0 comentarios)
0.0