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 freelanceria on tarjonnut keskimäärin 157$ tähän työhön
*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.
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.
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
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.