Find Jobs
Hire Freelancers

Reducing SQL Server Load on PHP Ste causing it to outime

$30-250 USD

Finalizat
Data postării: peste 7 ani în urmă

$30-250 USD

Plata la predare
I have a dedicated server hosting several sites. One site ([login to view URL]) has been unreacable for the past two days. Suddenly the sever load has risen a lot and it now no longer loads. All other sites load fine, though. Usually the server load is about 0.5 - 2.00 ... it is now up to over 10.00 .... in the later hours when little visitors try to access the site it will load. But once teh day gets more busy it just wn't load anymore. There have been no recent code changes. So I suspect some kind of overhead in the database or bad php / sql process. I have restarted the server several times but this did not fix the problem. So I look for someone who has the expirience / knowledge to fix this.
ID-ul proiectului: 11330727

Despre proiect

29 propuneri
Proiect la distanță
Activ: 8 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
Hello, My name is Sergey. I am Freelancer from [login to view URL], Russia. I can help you as SQL guru to research what happened, reduce server load, speed up slow SQL, speed up PHP code. This is list of similar projects, successfully completed by me: 1. "Improvise internal search speed" http://www.freelancer.com/projects/takereal_9800046.html 2. "MySQL Database Tuning" http://www.freelancer.com/projects/takereal_860810.html 3. "Analysis of reasons for slow-running SQL queries" http://www.freelancer.com/projects/takereal_613446.html 4. "mysql optimization" http://www.freelancer.com/projects/takereal_541899.html 5. "MySQL Database Optimization" http://www.freelancer.com/projects/takereal_760804.html 6. "mysql query Optimization" [login to view URL] 7. "Debugging slow Magento multi-webshop" [login to view URL] 8. "Joomla / Virtuemart Site having performance problems" http://www.freelancer.com/projects/takereal_876865.html I can communicate via Freelancer.com. -- Sergey aka Takereal
$190 USD în 3 zile
5,0 (1777 recenzii)
8,1
8,1
29 freelanceri plasează o ofertă medie de $131 USD pentru proiect
Avatarul utilizatorului
Hi i can do your work so please come ob chat for more discussion
$125 USD în 10 zile
4,9 (76 recenzii)
6,3
6,3
Avatarul utilizatorului
I can start right now and deliver quickly. Please let me know if you have any questions. Thanks, Josh O.
$100 USD în 1 zi
4,8 (133 recenzii)
6,5
6,5
Avatarul utilizatorului
Do you have root access to your server?. I'm looking forwards to your response. Thank you.
$100 USD în 1 zi
5,0 (109 recenzii)
6,2
6,2
Avatarul utilizatorului
Hi, I can help you, can you provide more details about your server? .
$133 USD în 2 zile
5,0 (71 recenzii)
6,1
6,1
Avatarul utilizatorului
Lets fix it. I have read your description and I will be able to fix it for you. The bad gateway problem is something i have come across.
$111 USD în 1 zi
5,0 (57 recenzii)
5,6
5,6
Avatarul utilizatorului
A proposal has not yet been provided
$50 USD în 2 zile
4,9 (53 recenzii)
5,1
5,1
Avatarul utilizatorului
A proposal has not yet been provided
$55 USD în 1 zi
4,6 (68 recenzii)
5,5
5,5
Avatarul utilizatorului
I can help you with your problem, probably your site is having a DDOS atack and must be blocked, please contact me for more details.
$77 USD în 3 zile
5,0 (45 recenzii)
4,8
4,8
Avatarul utilizatorului
Hi you will find my services highly reliable and professional. My Vision : High Quality, High Speed, High Satisfaction! i have 7 years business experience with certified and skilled . We are always looking to push forward best-practices for development and ensure a high level of attention to detail. thanks
$116 USD în 4 zile
4,6 (49 recenzii)
5,3
5,3
Avatarul utilizatorului
Hello! I have been into systems administration for more than 15 years, dealing with issues like yours on a daily basis. I'm willing to diagnose this problem for you in a professional manner. I might need several hours or a few days depending on complexity of this issue. I'm ready to start right now. Hoping to hear from you. Thank you.
$45 USD în 3 zile
5,0 (30 recenzii)
4,5
4,5
Avatarul utilizatorului
I would be glad to help you trying to figure out what is causing that problem with mysql I have an experience of over 2 years working on one of the biggest datacenter in my country as a system administrator. You can always contact me via chat asking me any questions that you have. Have a nice day!
$111 USD în 1 zi
5,0 (27 recenzii)
4,6
4,6
Avatarul utilizatorului
I am having more than 12 years experience of using php-mysql. I think I can resolve your issue quickly. generally, this kind of problem happens due limitation of db connectivity or Apache thread, may also require to tune SQL sometimes.
$111 USD în 3 zile
4,9 (16 recenzii)
4,1
4,1
Avatarul utilizatorului
Professional Experience - Highlights • 8+ years of experience in MS SQL Server development • 6+ years of experience in C# asp.net application development • 4+ years of experience in SSIS development • Health Care, Financial, Renewable Energy and E-Commerce domain Executive Summary • Worked on web applications and windows applications using C#, asp.net, MS SQL server and SSIS technologies. • Developed more than 10 web applications, more than 3 windows applications using c#, asp.net and MS SQL server in Financial, Renewable Energy and E-Commerce domain. • Expert in developing complex store procedures, SQL scripts, efficient triggers, required functions, creating indexes and indexed views for performance. Experience in writing complex SQL queries involving multiple tables inner and outer joins • Experience in monitoring SQL Server Performance tuning, identifying dead locks and resolving them in SQL Server 2008 using SQL Profiler • Expert in designing ETL data flows using SSIS; Worked extensively on ETL process using SSIS package from Excel, Flat Files to SQL Server databases • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging
$155 USD în 3 zile
4,9 (5 recenzii)
3,5
3,5
Avatarul utilizatorului
Hello, I have a good experience of 4-5 years on Linux Servers, AWS and web hosting. I'm Redhat Certified System Administrator. I would like to work on your project. Thanks
$150 USD în 3 zile
5,0 (8 recenzii)
2,9
2,9
Avatarul utilizatorului
I have ran into similar kind of problems while working on one of my projects (recommendation engine) so I have experience with these.
$66 USD în 3 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
#### Hello sir, Hope you are all right,the thing is that i have a vast experience in this type of work but i am new on this platform so i am able to do this work free of cost and deliver you a quality thing and in regards you just give me a good reviews that's it and if you happy with my work then reward me the money as you want with your happines. Thank you *****
$155 USD în 3 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
A proposal has not yet been provided
$250 USD în 3 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Did you tweak the MySQL configuration at all? My guess is that you haven't and there's no caching configured.
$133 USD în 3 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul GERMANY
Friedberg, Germany
5,0
32
Metoda de plată a fost confirmată
Membru din ian. 29, 2015

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.