Optimize MySQL Queries
$240-2000 HKD
Paid on delivery
We have a list of 9 MySQL slow queries that we would like a DB specialist to help us lower the query_time and improve the overall performance for. These queries are pretty straight forward and should be easy to optimize for anyone who has extensive experience in writing MySQL queries.
We will provide to you:
1) a list of 9 MySQL slow queries along with query_time, lock_time, rows_sent, rows_examined
2) The current EXPLAIN result for each of the 9 queries
3) The DB structure for the tables involved in the queries, along with any existing indexes
You will provide to us:
1) Suggestions on how to rewrite the query and/or use new/additional indexes to speed up each of the 9 queries
You can see the attachment for a couple of sample slow queries. Please only bid if you are confident that you can complete our requirements.
Payment Method:
(Milestone Optional) A milestone can be created upon your request at the start of the project. The Milestone will only be released when you've provided the suggestions to us, and we have tested that the suggestions have made an improvement to the performance of the 9 queries.
Project ID: #4632859
About the project
8 freelancers are bidding on average $1340 for this job
Hi, I have a lot of experience with MySQL optimisation. I would love to help you with this. Thanks, Emilian.
I am working as a data scientist and am proficient in MySQL, MS-Excel and MS-office tools.
I am having 7+ years in handling large Database specially MS SQL server Starting from 2000 to 2008 R2. I also worked on query optimization. PM me if you want to start it now.
I am expert in database optimization including MYSQL and SQL server. I am sure I can help you with these queries.