I'm looking for an expert MySQL DBA (or equivalent) to reduce the execution time of my MySQL query to 1ms or less. I have attached the database schema of the relevant tables, the PHP code which generates the query, current table sizes and row counts, and a sample query. I can supply full table data to freelancers I speak with who are interested in the project and think they can achieve my target.
Please note these very important parameters when considering bidding:
1) Current execution of the sample query in my environment with no load is 60-200ms, so I am looking for over a hundred-fold improvement. I won't accept a query that runs "faster" - it needs to run for 1ms or less
2) I am on a shared host (GoDaddy reseller) running MySQL 5.6. Please don't suggest moving hosting providers, VPS, MySQL upgrades or anything that involves the Linux shell or super-user/root access. None of these are possible. Your job is to optimise my query in my current environment
3) Further to the above, no MyQSL configuration changes are possible. I'm happy to supply you with whatever configuration parameters you need prior to you bidding, but they can't be changed
4) Changing my query, adding indices, changing column data formats and similar are all acceptable
5) What is not acceptable is anything that would fundamentally change my app logic (splitting tables etc.)
Please let me know if you have any questions, otherwise happy bidding!
24 freelance font une offre moyenne de $157 pour ce travail
Hello. I would like to help you with mysql query optimization. I have experience. Please read my feedbacks. Thanks.
Hi George, I have checked your attachement.(I have found one error in your "sample [login to view URL]".) I can complete your project using index, unique, foreign key, additional fields and trigger. But there is one condition; T Plus
Hello Hope you are doing well. I have 7 years of experience in Linux and MySQL. I can reduce the MySQL query execution time. Regards VishnuLal*
hi!???????????????????? Dear , my Client! i am very pleasure the opportunity to discuss this job with you. i am a full time freelancer with skills and experience on mysql, mongodb, php and angular.js, vue.js, react.js Plus
*Hello. Let's start! I can do your project perfectly in a short time. Maybe you need database specialist. I am a database manager having 5+ years of experience. Ready to start. Thanks.
Hello, I am Software Engineer since 2013, I have completed more than 50+ successful mobile apps of iOS and Android. I am an ambitious, hardworking and challenging with high technical skills. I have a technical team wh Plus
Hello! I read your description carefully. I've always done my project as the fastest and highest quality. I think your project is best for me. The reason is that I am a Web development expert. If you want to check my s Plus
Hi sir. I am a senior DBA and i have 5+ years experience with Database Optimize. Once you check me you can hire me. I hope to work with you. Please contact me and let's discuss more details. Thanks.
Hello i have experience in mysql optimization and imho can help you, i'm open to discuss and ready to job.
Hi Sir please add the indexes on columns. Adds prepare keywords with remove joins. these all things i have use in Ali Express scraping data. Which brings results faster. Regards Ahmed Awan
Hii. I am expertise in aql queries i will fuldill ur need ping me if u are interested and also let me know total rows of the table
i can work for jquery High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I have gone through your Job post and I can understand your job requirement thoroughly. I have a total of Plus
Hello I'm senior full-stack web+mobile developer - 10+ years of experience reflected in my Upwork reviews. Located in Eastern Europe(Minsk, Belarus), available for full-time(no day job) and ready to start immediately. Plus
Hello, there! I have thoroughly read your job post and I would like to apply for it. I have been working with MYSQL more than 5 years already and have extensive experience in Query optimizing. I'm also experienced in Plus
~~~ Very interested to me! ~~~ Hi, dear! Feel contact me for these kinds of projects. I will provide you the best result on [login to view URL] give me 10 minutes of yours. I am waiting for your message to have a detail discus Plus
Hello! Over the last 10 years, I have developed data-driven applications mostly for the web using advanced backend(Laravel, Zend, Cordigniter, Wordpress, Joomla) with PHP/MySQL/NodeJS and rich frontend HTML/CSS/JavaScr Plus
Hi, Mysql Optimization is my main skill. I saw your database diagram and sql files and could find some problems. Please feel free to contact me. Kind regards.
i am mysql expert have 10 year experience. i will solve you issue by changing query and add index. ready to start now