Help Optimize Mysql Queries
$30-250 USD
Paid on delivery
I have slow queries that run against my production database that I would like to optimize. I have [url removed, login to view] enabled and it seems there are roughly 3-4 queries that take like 5 - 20 seconds to run.
I.m running Your MySQL Server version: 5.1.61-log MySQL Community Server (GPL). The application server and database server are on the same host.
The mysql tables are InnoDB type. There are roughly 70-80k to 1 million records in the tables that are being querying.
What I'm looking to do is to communicate to you to tune the queries. I think for the person who is well versed in mysql and SQL this could be a quick 1-2 hours of your time.
Project ID: #1505340
About the project
18 freelancers are bidding on average $103 for this job
Experts are here, having tremendous experience of 16 + years in database queries, please check the PMB .
Hello kimosrolling, We are ready to work with you please give me detail of your website to start work right now. We have good experience of photoshop,logo design,banner design,mysql,php,html,html5,css,joomla,,Gr More
Hello. I can help you with this . I'm working every day on PL/SQL , SQl Manager for MySQL . If you need me ,I will be happy to help you . Best regards
Hi kimosrolling, I have extensive experience in the development of engineering databases and associated interfaces. I have specifically dealt with web interfaces that pass SQL connection strings to client databas More
GETTING PROJECTS DONE UNDER BUDGET! New World Solutions brings together some of the brightest minds in the information technology field. From our pool of multi talented, savvy, goal oriented professionals, we s More
Hi, i have more than 7 years experience with mysql.I worked on similar task last month. I guarantee min 50% optimization on queries. Best regards, Goran
Hello, I have some working experience with MySQL query optimization. I think I can help you tune your queries.
Hello, With help of available tuning techniques your queries can be well tuned. Given a chance I can help you in resolving this tuning issue. Thanks, Kishore.