Find Jobs
Hire Freelancers

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

$10-30 USD

已取消
已发布超过 8 年前

$10-30 USD

货到付款
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.
项目 ID: 9365579

关于此项目

14提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
14威客以平均价$56 USD来参与此工作竞价
用户头像
A proposal has not yet been provided
$50 USD 在1天之内
5.0 (235条评论)
7.0
7.0
用户头像
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 在1天之内
5.0 (134条评论)
6.8
6.8
用户头像
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 在1天之内
5.0 (202条评论)
6.5
6.5
用户头像
A proposal has not yet been provided
$100 USD 在3天之内
5.0 (113条评论)
6.7
6.7
用户头像
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 在1天之内
4.6 (378条评论)
7.2
7.2
用户头像
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 在3天之内
4.8 (206条评论)
6.8
6.8
用户头像
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 在1天之内
5.0 (36条评论)
5.9
5.9
用户头像
A proposal has not yet been provided
$66 USD 在1天之内
4.8 (33条评论)
4.7
4.7
用户头像
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 在0天之内
5.0 (13条评论)
4.0
4.0
用户头像
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 在2天之内
0.0 (1条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$25 USD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

PALESTINIAN TERRITORY的国旗
Ramallah, Palestinian Territory
5.0
159
付款方式已验证
会员自8月 6, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。