MySql database optimization

$25-50 USD / hour

In Progress

Posted

over 5 years ago

$25-50 USD / hour

Need someone to help figure out why my there are so many slow MySql queries that are causing a lot of server strain and periods of down time. Got this message from support on Siteground: === TOP 10 of 30 (total) Slow Queries for the past 24 hours ========== 1. Executed 6h 16m 36s ago for 77.234428 sec on Database --> Unknown (NOT FOUND / DELETED) Date: 2019-01-06 07:45:17 Query_time: 77.234428 Rows_examined: 9: Rows_sent 4 Lock_time: 21.371102 # Schema: peopl116_wp53 Last_errno: 0 Killed: 0 SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, [login to view URL], t.element_type FROM wp_icl_translations t JOIN wp_posts p ON t.element_id = [login to view URL] AND t.element_type = CONCAT('post_', p.post_type) JOIN wp_icl_translations tridt ON tridt.element_type = t.element_type AND [login to view URL] = [login to view URL] WHERE [login to view URL] = (SELECT trid FROM wp_icl_translations t JOIN wp_posts p ON t.element_id = [login to view URL] AND t.element_type = CONCAT('post_', p.post_type) WHERE element_id = 2858 LIMIT 1); There are several of these Database --> UNKNOWN that takes a lot of seconds to go through, and is probably why my sites keep going down as I reach my server limits. Looking for experienced programmer that can help me sort this out quickly as this is happening to sites that are currently live.

Database Administration

Project ID: 18479371

About the project

16 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

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:

@TakeReal

Hello, My name is Sergey. I am Freelancer from Saint Petersburg, Russia. I can help you to optimize MySQL database. I suppose you have too slow SQL queries. Or incorrect MySQL settings. Or other issues. I can find these issues and fix them. This is list of similar projects, successfully completed by me: 1. "Improvise internal search speed" https://www.freelancer.com/projects/takereal_9800046.html 2. "MySQL Database Optimization" https://www.freelancer.com/projects/takereal_760804.html 3. "MySQL Database Tuning" https://www.freelancer.com/projects/takereal_860810.html 4. "Analysis of reasons for slow-running SQL queries" https://www.freelancer.com/projects/takereal_613446.html 5. "mysql optimization" https://www.freelancer.com/projects/takereal_541899.html I can communicate via Freelancer.com. -- Sergey aka Takereal

$30 USD in 10 days

5.0

(1791 reviews)

8.1

16 freelancers are bidding on average $30 USD/hour for this job

@augurstech

Dear Employer, Thanks for giving us chance to submit proposal on your project. Coming to your project scope you can hire our exp Mysql developer for fixing issues in your existing application. Ping us via freelancer chat box and provide us complete details of application and login credentials , database access so that we can go through with our developer and proceed forward with you regarding project discussion and award process. I will wait for your reply so that i can assist you in much better way. Warm Regards Sam

$25 USD in 40 days

4.9

(155 reviews)

8.2

@latatestTech

With Freelancer Preferred badge bound to give 100% Quality (Let's Chat) Hello, A great team is here for your service!! I read the project description properly, and I agreed to fulfill 100% of all your requirements. I can start your important project right away. I am 24x7 available on chat, so i can serve you whenever you want. Please check the PMB. Let's Lets start! To achieve goal with 100% quality we have team of 27 Professional Software Engg. Reply us so that we can move ahead to get this software successfully run. Regards Dsv Infosolutions Pvt. Ltd.

$29 USD in 40 days

4.8

(159 reviews)

7.9

@raoasghar

Hey! Here is Muhammad, i reviewed job description but i have some question's about job, please let me know further details about job and i will MySql database optimization then we will finalize about time and budget. thanks

$35 USD in 40 days

5.0

(285 reviews)

7.6

@VirasatSolutions

Hello, Greetings for the Day! Have find your post and As a team of Experts, Like to get on board and assist you across Database Optimization and optimize the code for better response and turn around time. We are working since last 8 years, served numerous of clients across Globe and confident to get this done . But before You must need to share me these- - Existing Database Queries We having best experiences with MY SQL, MYPHPADMIN and MongoDB. We are confident about this. Kindly share me your Availability & Award us for further proceedings. Waiting for your prompt reply. Kind Regards, JJ Virasat Solutions

$25 USD in 40 days

4.7

(101 reviews)

7.9

@hardikmemagara

Hello, I will complete your every requirement as per your need that you have mentioned in your job details. We are group of PHP experts. Will support after the work done as well. so please Come to the discussion about your project so I will analyze the requirement and provide you the proper cost and time estimation. Check my portfolio on - https://www.freelancer.com/u/hardikmemagara We have completed more than 500+ projects in PHP. Thanks.

$25 USD in 40 days

4.9

(374 reviews)

7.3

@ravinder246

Hi, Yes , I can MySql database optimization. I am expert in MySql database optimization I hope your good response Thanks Ravinder

$39 USD in 8 days

4.9

(352 reviews)

7.5

@abstractsoftweb

Hello there, Hope you are doing great..!! We are pleased to inform you that we have 7 years experience WORDPRESS,ASP.NET, MVC, MAGENTO, CAKE-PHP, OPENCART, C#, PHP, JOOMLA, PRESTASHOP, DESIGNING, ANDROID,IPHONE etc Team. We have deployed many quality solutions for our clients and we have great skills and capable enough to turn your vision into reality. We would like to discuss the project in more details so please revert us back so we can communicate in more details to understand your final scope of the project and based on that we will move forward to the next step. Please feel free to ask if you have any questions for us as we are looking forward to speaking with you regarding the project. Please review the same and let me know your response over the same. Thanks Saurabh Sharma

$25 USD in 40 days

4.8

(123 reviews)

7.2

@karunakartiwari

Hi, Greeting, hope you are doing well! I have 8+ Years of experience as Full stack PHP Developer Please allow me to review the MySQL DB to find root cause ,and optimise the Database accordingly Looking forward to hear from you . Thanks Karunakar

$29 USD in 40 days

4.9

(215 reviews)

7.2

@dilpreet2012

Hi Let me know when we can discuss I am certified with MY SQL Thank you Preet .................

$25 USD in 20 days

5.0

(48 reviews)

6.8

@MagentoQueen

Dear Client, I would like to talk once custom support of Siteground. I assured you I'll find the bug and fix website so it will not down again. Which platform website was built? I have 7+ years experience with Web Development. Give me a chace to work with you. Regards, Dipti

$25 USD in 10 days

5.0

(90 reviews)

6.5

@ARKSolution2015

Sir, I have gone through your project description and am looking to provide my service for database queries optimization . For more than 7 years I’ve worked in this field.

$29 USD in 40 days

4.9

(153 reviews)

6.6

@mersaad90

Hi sir, I will provide high quality work! I need to check database also coding...please contact me.

$35 USD in 20 days

5.0

(16 reviews)

4.2

@meetravig

Hi there, I read and understood your requirement that you want to do the MySQL database optimization. I am very good at optimizing the databases and I can deliver your project to your satisfaction. Let us connect and discuss the requirements in detail.

$50 USD in 20 days