Find Jobs
Hire Freelancers

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

$30-250 USD

Probíhající
Zveřejněno skoro před 7 roky

$30-250 USD

Zaplaceno při doručení
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.
IČ projektu: 14715418

O projektu

20 nabídky
Vzdálený projekt
Aktivní před 7 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
quite straight forward task, can be done within 12 hours
$110 USD v 1 dni
5,0 (12 recenze)
4,5
4,5
20 freelanceři nabízejí v průměru $152 USD za tuto práci
Avatar uživatele
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 v 3 dnech
4,9 (657 recenze)
9,0
9,0
Avatar uživatele
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 v 5 dnech
4,9 (328 recenze)
7,8
7,8
Avatar uživatele
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 v 10 dnech
4,8 (16 recenze)
5,9
5,9
Avatar uživatele
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 v 1 dni
5,0 (103 recenze)
5,6
5,6
Avatar uživatele
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 v 2 dnech
4,8 (72 recenze)
6,0
6,0
Avatar uživatele
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 v 3 dnech
4,9 (56 recenze)
5,7
5,7
Avatar uživatele
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 v 1 dni
5,0 (44 recenze)
5,4
5,4
Avatar uživatele
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 v 1 dni
4,5 (16 recenze)
5,8
5,8
Avatar uživatele
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 v 2 dnech
5,0 (21 recenze)
4,9
4,9
Avatar uživatele
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 v 3 dnech
5,0 (5 recenze)
4,3
4,3
Avatar uživatele
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 v 33 dnech
4,4 (25 recenze)
5,0
5,0
Avatar uživatele
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 v 3 dnech
5,0 (4 recenze)
3,8
3,8
Avatar uživatele
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 v 2 dnech
5,0 (5 recenze)
1,5
1,5
Avatar uživatele
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 v 2 dnech
5,0 (1 recenze)
0,6
0,6
Avatar uživatele
worked with mysql optimization in past for different technologies and stacks
$127 USD v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 7 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z UGANDA
KAMPALA, Uganda
5,0
3
Ověřená platební metoda
Členem od srp 19, 2015

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.