Find Jobs
Hire Freelancers

Fixing Php/SQL issue that causes slowness and hight CPU php% on server

$10-30 USD

Cancelled
Posted over 8 years ago

$10-30 USD

Paid on delivery
Hi Freelancer, Read the info carefully, and please noted that we'll only contact those who provide detailed description explaining the ability to fix this issue not a general desc. We have new users for our mobile app, that streams videos from server and call some URL functions from php server side, We noticed some delay after sometimes on calling some URL(response time:5 sec instead of 0.5) like: [login to view URL] and after investigation, we noticed: 1) when restarting the SQL server from the server, the response speed comes back to 0.5 sec, but after couple of hours, get back to slow 5 sec. 2) As you see in the attachment, when I run the URL, I noticed that php task on the (top) server reaches 90% *) attached solution diagram *) Top CPU percentage when running slow.
Project ID: 9365579

About the project

14 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $56 USD for this job
User Avatar
A proposal has not yet been provided
$50 USD in 1 day
5.0 (235 reviews)
7.0
7.0
User Avatar
Hello, I have gone through your outsourced requirements "Fixing Php/SQL issue that causes slowness and hight CPU php% on server" and have analyzed that I have right credentials (Skills required MySQL, PHP, SQL, System Admin) to execute your esteemed project. I will complete your project asap, LIFETIME error free guarantee and provide ONE YEAR support... ===== Why choose me? ===== 5.0 / 5.0 rating, 100% completion rate, 100% on-time completion, 100% on-budget :) Kindly, check my profile: http://www.freelancer.com/u/BitLabs.html I work smart, hard, and strictly bid only what we can do! No sub-contracting... ever! You will never go wrong choosing me :)
$39 USD in 1 day
5.0 (134 reviews)
6.8
6.8
User Avatar
Its pretty normal that when a process is executed, that process will try to use as much cpu as possible in order to finish/complete the process as soon as possible. I think the issue is mainly related to mysql server configuration and/or web server configuration. What type of webserver do you use? NGINX? APACHE? which versions? What type of MySQL server do you use (MySQL, MariaDB)? which versions? What is the configuration of your server? CPU/RAM? hard disc type/rotaion/RAID? Kind regards,
$30 USD in 1 day
5.0 (202 reviews)
6.5
6.5
User Avatar
A proposal has not yet been provided
$100 USD in 3 days
5.0 (113 reviews)
6.7
6.7
User Avatar
Hi, We help customers do business better by leveraging our industry-wide experience, deep technology expertise these technology includes setup and management of different Linux web hosting servers like CentOS, RedHat, Ubuntu, Debian etc. We provide so prompt project delivery, thus we perform our responsibilities precisely with our scrupulous attention and full dedication. We have expert level knowledge in web hosting panels like cpanel, plesk, webmin , ispconfig, zpanel, Direct admin etc. Initial server setup steps:- Install LAMP Bind to name server Install Postfix for send the mails Install Dovecot to receive the mails Install vsftp etc. Install panel All linux flavours supported Services Support:- Apache,IIS, Tomcat, DNS, Windows ASP.NET, PHP, Java, AWS, MSSQL, MySQL Exim, Postfix, sendmail, Mail Enable, smarter mail, powermta etc. Server Log Monitoring:- Techs will be monitoring the Server Logs Restart Services if necessary and required Fix issues if any of the services have problems Basic Server Security:- Server Securing and Hardening CSF Firewall Installation & Configurations LFD Alerts on Brute Force Attacks SMTP Tweaking PHP Hardening (SUPHP, SUHOSIN ) Mod_security Setup and Configurations Root Login Email Alerts Server Optimization features: Unused services packages removal Apache server optimization perform module for apache mysql optimization Apache,mysql,kernel version to stable version Thank you
$50 USD in 1 day
4.6 (378 reviews)
7.2
7.2
User Avatar
Hello! I have right skills and great experience for begin working on your project just right now! You may show good reviews at my profile.
$150 USD in 3 days
4.8 (206 reviews)
6.8
6.8
User Avatar
Hello, I am a Senior PHP developer from Vietnam. I have read your requirement and I think I can help you fix it. With the issue you said in the requirement and your attached images I think we have to optimize the database indexing, then optimize the sql query in php code, and then the http server (apache/nginx) and we should implement data caching for this API. I will more than happy to do this job for you. Thanks, Jimmy
$30 USD in 1 day
5.0 (36 reviews)
5.9
5.9
User Avatar
A proposal has not yet been provided
$66 USD in 1 day
4.8 (33 reviews)
4.7
4.7
User Avatar
I am sure I can help you with this. Please let me know if you'r interested so we can discuss the details and the help you need.
$100 USD in 0 day
5.0 (13 reviews)
4.0
4.0
User Avatar
Hi , I have Immense experience in working on Web Designing(logo,banner, flyer, T-shirt, brochure etc) & Development and applications that run on all iOS devices and versions . Also I have worked on Android apps as well. And I have quite experience to build Business Apps where Apps directly communicate with server via API(web service) functions. With strong communication and designing capability. I will show you my previous work too. Looking forward to hear you.
$24 USD in 2 days
0.0 (1 review)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PALESTINIAN TERRITORY
Ramallah, Palestinian Territory
5.0
159
Payment method verified
Member since Aug 6, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.