Find Jobs
Hire Freelancers

Server optimization and bottleneck troubleshooting.

$30-250 USD

Cerrado
Publicado hace casi 10 años

$30-250 USD

Pagado a la entrega
We are not looking for someone to optimize the server on our behalf, instead we are looking for suggestions to what may be causing the unstability described below and possible fixes. Background information: We have two Dual-CPU 32GB RAM SSD servers. One is used as a web server and one is mysql database server, the servers are also privately connected through LAN. The server serves mostly PHP pages with only around 5% of requests requiring mysql lookups. Currently, the web server hits a bottleneck at around around 150/requests per second. Once it hits the bottleneck the server becomes very slow and unresponsive (check the attachment graph). We have checked the following: * MySQL process list shows little or no current running query, meaning that SQL isnt the bottleneck * When server becomes unstable, you can see lots of requests getting stuck in apache queue. Apache status would show thousands of current requests waiting in queue but are not even processing any of them, it looks as if one process is blocking all the other processes. When these requests are stuck the analytics would show a downfall in realtime traffic, after around 5~班seconds Apache starts processing the requests again, the thousands of processes gets completed by Apache causing a huge spike in analytics. * We believe the hardware are not being fully utilized since when it hits the bottleneck, the CPU load on both server are very low. We already tried the following: * The server is running with fcgi+xcache with logging disabled to reduce disk IO. * We have increased apache server numbers and limits, but didnt help at all. * We have moved some caching into tmpfs but didnt help Now we need suggestions on what else we could do to increase the system bottleneck.
ID del proyecto: 5999440

Información sobre el proyecto

18 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
18 freelancers están ofertando un promedio de $115 USD por este trabajo
Avatar del usuario
Hi, I had the exact same problem. Your solution is to install nginx. Let me know if you want me to help you more. I will guaranty performance. Regards, Hussain
$206 USD en 3 días
4,9 (56 comentarios)
8,1
8,1
Avatar del usuario
Hello, I am simply an Linux expert with more than 12 years of experiences. Kindly take your 2 minutes to go over my previously completed projects (especially performance optimization projects) to qualify my experiences. Regarding to your request and its fulfillment conditions: Even if i understand and respect that you dont want someone else to touch your system, on the other side it is hard for a lancer to suggest technical things just for "try-it-learn-it" approach. Also even this is not something related with you, there is no clear way of identifying if you would fairly award the winning coder if his suggestions would work and/or not clear if his suggestions would be performed exactly how he suggests. In short, back to your requirements. I think more debugging tools for HW and for apache processes would help much but as mentioned with this level i cant provide a very detailed suggestion list to follow. Please ping me when you are around to talk in more details. Thank you! Pardus.
$150 USD en 3 días
5,0 (319 comentarios)
7,6
7,6
Avatar del usuario
Hello, I am an experience system admin and i can help you in this project. You can view my profile for similar projects i have completed. I am ready to start on it and if you have any query please feel free to ask. Thanks.
$79 USD en 1 día
5,0 (187 comentarios)
6,7
6,7
Avatar del usuario
I'm get ready to found bottleneck on your server My price is $30/h SSH root access is requied No TeamViewer or other. ************************************************************************************
$35 USD en 30 días
4,8 (272 comentarios)
7,1
7,1
Avatar del usuario
Hi Boss, I have ample experience in linux server administration, website migration, installation and configuration of custom software with security. I can do this project for you. You may please have a look on my profile for further information regarding me. Looking forward for a positive reply from your end. Regards, Minu Thomas https://www.freelancer.com/u/minuthomas.html
$140 USD en 2 días
4,9 (144 comentarios)
6,4
6,4
Avatar del usuario
Greetings, I might say that this is a very interesting situation. Given the graph vs the hw requests I would start to look on the webserver side and see why the handles are being kept opened. I can show you an example on how can a simple mobile phone can kill a web server monster if the webserver is not configured correctly. Please let me know if we can have a call. Regards, -iulian
$155 USD en 2 días
4,9 (224 comentarios)
6,3
6,3
Avatar del usuario
This is sure, problem would be resolved. We need to look into the server to know the reasons. we have server monitoring system, will monitor server for 24 hours to know the actual reason, timings, duration & check which resources and processes are responsible for this. based on reports, we will troubleshoot and guide you further. We have resolved such kind of issues by this way & it helps in knowing the reasons and fix it. Regards, Manoj
$150 USD en 3 días
5,0 (36 comentarios)
6,4
6,4
Avatar del usuario
Hi, I am very interested with your project. If you are using CentOS as Linux operating system, please install an utility called "atop" and try to view the hardware stats, network stats, process stats in your server when the problem occur. We may consider about Dos attack is happen on your server. Please take a look carefully about disk i/o wait and network usage via Atop windows. Regards,
$155 USD en 3 días
5,0 (57 comentarios)
5,1
5,1
Avatar del usuario
To be honest with you, I did not want to leave this message until I saw current status from jpg that you attached. First thing is that: You will need a memcache server (which can be created inside your existing server as a virtual container) -- no additional fee You will need to fine-tuned the db confiurations, this is based on total size of memory, cpu, cores etc. Then, you will need to do a Read/Write script to balance the requests: Example: Memcahced Servier1 : Will be responsible to cache all the request that is not being in cache then subsequent requests will be server from the Memcached server. This reduced heavy loads from Server . Database server: Create two or more slave database, dBSalve1, dBSlave2 ..... then Sync Master Databse to the slaves... (master and slaves has same information) Now the scripting: Add a script to do the follwoing: if visitors browing the website ; server request goes to Memcached, and mysql is readonly, thus reading from salves if no information inside of memechaced (we do not even worry the master database) Master database will only store and sync asynchronously new as information from visitors such registrations, ordering, anything that has to do with WRITE permissions. This is same tech BIG companies use to speedup their system. Let us chat about it
$105 USD en 4 días
5,0 (36 comentarios)
5,3
5,3
Avatar del usuario
Hi, I have an MS in Computer Science. What are the values for KeepAliveTimeout and MaxClients on your server? Also, are the requests stuck with a R status or a W or one of the other status keys? We can proceed further once we get the answers to my questions :) Regards, V
$50 USD en 1 día
4,8 (37 comentarios)
5,2
5,2
Avatar del usuario
Hi I`m experienced linux/unix admin. Managing hundreds of linux systems on the daily basis. Have done many performance analyzes and troubleshooting`s in my life. I have RHCE Cert passed. Ready to take a look on Your server as well and find out where is the bottleneck. Best Regards Marek
$222 USD en 3 días
5,0 (17 comentarios)
4,8
4,8
Avatar del usuario
Hello, just a guess: Is your filesystem Ext4 or from the Ext-family? KR, Oliver =================
$55 USD en 3 días
5,0 (22 comentarios)
4,6
4,6
Avatar del usuario
I have a long time experience in this field. I'm setting up, managing, and optimizing web sites on Linux servers (mostly CentOS/Red Hat), on a daily basis professionally. Most of issues are discovered through strace of php execution processes, so I'm certain that u r going to be very satisfied if u choose me for your project.
$49 USD en 2 días
5,0 (4 comentarios)
2,7
2,7
Avatar del usuario
A proposal has not yet been provided
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
If we rule out Disk I/O & MySQL query its pretty much left to Apache & PHP, or maybe problem with private connection between the 2 server. Troubleshooting Apache & PHP manually is really hard. So what I would recommend is to install Application Performance Monitoring(APM) such as New Relic to identify the bottleneck. I understand if you don't want me in the server, but still, I can guide you to install and make sense of the data gathered by New Relic. Free New Relic version is good enough. However I can only help if this is Linux server. I'm not familiar with Windows. Feel free to contact me. Consulatation is always free.
$100 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Brisbane, Australia
4,9
168
Forma de pago verificada
Miembro desde ago 29, 2009

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.