Find Jobs
Hire Freelancers

MySQL service consuming too much RAM in wordpress & Storage space at 100% due to php errors

$30-250 USD

In Progress
Posted over 6 years ago

$30-250 USD

Paid on delivery
This project is broken down into two main issues as listed below. 1. SQL Service The issue comes from the MySQL service. It is consuming too much RAM and CPU. The server gets heavily overloaded by mysqld and hhvm processes what exceed mt server RAM limits. And the usage comes from very slow MySQL database queries. Particularly these two queries. The first one is running for more than 99 seconds and the second one for 22 seconds. Target is for them to go back to 2-3 seconds. Thus queries and the main data base need to be optimized to be less heavy on the server. Generally the account consumes a lot of RAM (from 4GB not to 7GB in less than two weeks) and there are still slow MySQL queries: Code: Database Tables Views InnoDB MyISAM Slow Queries Slowest Query DB Size ------------------ ------ ----- ------ ------ ------------ ------------- -------- DATABASENAME 105 0 55 50 25 91.103 320.3 MB KPI: RAM Usage goes back to 4GB max as it was before after 3 days monitoring 2. Storage Space We believe the above issue is also causing this second one. It causes the php_errorlog to increase in size hence filling up consuming all disk space to 100%. It is possible that our application has some configuration incompatibility with our theme or plugins which are written in its log file and could explain its behavior. KPI: No more increase in diskspace usage after a 3 days monitoring. Attached is a full breakdown of the chat with host support on issue 1.
Project ID: 14715418

About the project

20 proposals
Remote project
Active 7 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
Awarded to:
User Avatar
quite straight forward task, can be done within 12 hours
$110 USD in 1 day
5.0 (12 reviews)
4.5
4.5
20 freelancers are bidding on average $152 USD for this job
User Avatar
Surely, We are ready to help you with fix the both issues. - SQL Service -Storage Space Yes, I have seen the attach details. We have understood the work. Relevant Skills and Experience Please review our profile and past work here: https://www.freelancer.com/u/OutsourceMan.html Proposed Milestones $147 USD - Pay when satisfied Can we discuss more. Looking forward for your reply. Thanks vaishali
$147 USD in 3 days
4.9 (657 reviews)
9.0
9.0
User Avatar
Hey Friend, Myself having has 10 + years experience of web site development. Expert in Custom programming in php / Mysql / Jquery / Wordpress/ Joomla / OSC / Magento /OpenCart / Android / Mobile development / Responsive. Ready to start the work immediately. I am confident to handle your projects with dedication and good quality. Regards Urmila Gupta
$180 USD in 5 days
4.9 (328 reviews)
7.8
7.8
User Avatar
Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customizations, I want to discuss this project with you further on personal chat. Let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, I use to be online 24x7 on Freelancer so probably you will get a quick response from my end. Following are my Expertise Area: 1) Ruby on Rails 2)PHP with CodeIgniter and Laravel Framework. 3)Node JS 4)Angular JS 5)Mobile App Development 6) Shopify 7)Ruby Thanks :-)
$277 USD in 10 days
4.8 (16 reviews)
5.9
5.9
User Avatar
I've reviewed your conversation and have several thoughts on the issue, but my recommendation is: Move to a different provider. Point 1: mysql is configured by the server admin (root) and it's THAT configuration controls its memory usage, not your database, which is only 320MB, according to the data in the screenshot. Point 2: If Siteground will not give you root access, then it's not your server. Point 3: Wordpress and its various plugins run fine even on shared accounts, without anyone mucking around to optimize queries. In fact, the people who CAN optimize the query structure, if it even needs it, are the Wordpress developers and the plugin developers, NOT end users. So, yeah, I can do the job for you, when you want to move your site to a new server. In fact, to prove my point, I'll offer you this: I'll copy your site over to my server and let you run it there for 30 days, for free, while keeping your siteground hosting up. If you're satisfied with the site's performance after the 30 days are up, then you pay me my usual $30 site transfer fee and $40/mo every month thereafter. This will be for whatever space you're using now + 5GB. If you surpass that, then the additional space will be priced at $9 per 5GB (pricing for business accounts on the server). If you're not happy with the performance, then you pay me nothing, switch DNS back to siteground and you're back where you started with no real loss. The server in question has 8GB of ram and runs ~40 small sites.
$150 USD in 1 day
5.0 (103 reviews)
5.6
5.6
User Avatar
Hello, I read your PDF I think I can help you optimize your query. How much users online you have? How much CPU / memory vps have? Relevant Skills and Experience linux mysql Proposed Milestones $155 USD - opt
$155 USD in 2 days
4.8 (72 reviews)
6.0
6.0
User Avatar
wordpress expert Relevant Skills and Experience Dear Sir, I have more than 10 years of experience in all the skills required for the project. Please check our profile for more details. Regards Mehla B. Proposed Milestones $222 USD - Project Milestone
$222 USD in 3 days
4.9 (56 reviews)
5.7
5.7
User Avatar
I have read your project. I'm sure i can help you to do it. I'm expert in MySQL. I have fixed many MySQL highload cases. I have 7 years of experience in Web Development, System & Network Administrator and Security Researcher. Choose me then you will work with a Professional Devops, you won't be disappointed. Thanks.
$100 USD in 1 day
5.0 (44 reviews)
5.4
5.4
User Avatar
Hi. I have dealed with this kind of issues in the past with my servers and my customers. That you need is hardening/optimize your server. I have experience with this.
$100 USD in 1 day
4.5 (16 reviews)
5.8
5.8
User Avatar
hi, i can help you with your project. send me more information about via freelancer.com chat. regards Habilidades y experiencia relevante linux php bash script shell mysql mariadb Htos propuestos $133 USD - milestone
$133 USD in 2 days
5.0 (21 reviews)
4.9
4.9
User Avatar
Hi, dear employer! How are you? I have read your description carefully and undestand your requirements fully. As an expert for WordPress and PHP development, i'm very interesting for your project. I'm 100% sure i can do this project perfectly. Sure, i will support free bug fixing and regular updating. I have rich experience in REST API, SOAP API, JSON/XML, PHP & MySQL Web Service API, GPS and Geolocation API, Facebook API, Twitter API, Foursquare API, MapKit, GPS, Payment Gateway APIs, eCommerce platforms. I am expert in Core Graphics, Uber, Payment Integraton, ICloud, Social app, Voice Recognition, and popular service like push notification ,local notification , geolocation , and beacon , coredata, qr code and etc. Also extremely understanding MapBox and Google Map API. No job is too big or too small for me. I want a long term relationship with you. Thank you and best regards!
$155 USD in 3 days
5.0 (5 reviews)
4.3
4.3
User Avatar
5 Reasons why you should hire me for your custom website and Application Development. 1. Available 24/7 upon your request 2. Delivery on-time with 100% satisfaction 3. Always think beyond boundaries and. provide user friendly solution 4. Provide excellence with commitment 5. Most important, Free technical support for lifetime. Thank you
$220 USD in 33 days
4.4 (25 reviews)
5.0
5.0
User Avatar
Hi my name is Victor from Melbourne Australia. I work as a Linux System Engineer with 8 years experience in supporting Enterprise Linux environment. Happy to discuss with you in more detail and will be able to work in your time zone to troubleshoot the MySQL and php issues. Cheers Victor
$132 USD in 3 days
5.0 (4 reviews)
3.8
3.8
User Avatar
My aim is to prevhigh quality Web design and coding in very short amount of time. I take pride in my ability to produce results which pass the validation for XHTML and CSS as per W3C standards. In last 6 years I have successfully executed 150+ amazing Websites and 10+ Mobile Apps. I am well equipped in Magento, Wordpress, Opencart, PHP, MYSQL, js, JQUERY, PHP Frameworks, PhoneGap, Andriod, IOS and AJAX and designing through Adobe Photoshop, including HTML5, CSS2/3, Bootstrap (responsive sites). Regards Punit
$90 USD in 2 days
5.0 (5 reviews)
1.5
1.5
User Avatar
Hi, I understand the issue of long running queries, we have to either create indexes on DB or another way is to change the query. Relevant Skills and Experience I have solved such type of queries in our office. Proposed Milestones $45 USD - Completion
$45 USD in 2 days
5.0 (1 review)
0.6
0.6
User Avatar
worked with mysql optimization in past for different technologies and stacks
$127 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Expertise in various RDBMS technologies like Oracle/MySQL etc. i may be new to freelancing but not new to DBA... :) Let me have a try at the issue. Stay tuned, I'm is still working on this proposal.
$133 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UGANDA
KAMPALA, Uganda
5.0
3
Payment method verified
Member since Aug 19, 2015

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)
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.