Completed

MySQL EXPERT: resolve very slow query issue & DB optimisation

Project timeframe: 1 hour

Project budget: 20 euro

Details: i have a MySQL query that on an old laptop runs (on the same DB) in 0.046 sec and in the production environment (SQL VM, 8CPU, 20RAM, 250SSD, last version of MariaDB, optimised for performance environment ) crushes!!!! And with limit 10 runs in 79.319s or limit 25 in 131.450s.

I need this fixed.

Attached you can find screenshots of the query and the explain.

Skills: MySQL, Linux, Database Administration, PHP, Apache

See more: mysql slow query count, slow query mysql php, mysql slow query scripts, mysql optimize slow query, mysql count slow slow query slow queries, resolve slow query, mysql slow query magento, mysql slow query update, how to check slow query in mysql, slow query table mysql, mysql slow query log, mysql 5.6 slow query log, mysql slow query log example, mysql slow query log analyzer, mysql 5.7 slow query log, mysql slow query log query_time, mysql 5.5 slow query log

About the Employer:
( 12 reviews ) Viziru, Romania

Project ID: #23921220

Awarded to:

jaedonfarrugia

SQL expert here, verified in the top 3% of all freelancers globally via freelancer certifications. Please share additional details with me for a full diagnosis: 1) What is the code behind the `get_text` function? 2) More

€30 EUR in 1 day
(2 Reviews)
3.3

9 freelancers are bidding on average €31 for this job

talhamq

I have experience in deploying and maintaining of: Cloud Computing Platforms: AWS Amazon Web Services,Microsoft AZURE, Google Cloud (GCP). Server Operating Systems: Windows Server 2003-to-2012R2, Windows Server 20 More

€72 EUR in 1 day
(251 Reviews)
6.4
alexand1025

⭐Hi, ⭐ I am a Mysql expert and I can solve this issue successfully and quickly. I have rich experience 10+ years in web development and I can say that's exactly what I specialize in. I am ready to start work immediatel More

€20 EUR in 7 days
(28 Reviews)
4.6
phiona06

Hi! As I see in your table articles need to add index. I need to see full structure of this table, because from screenshot it's not enough

€19 EUR in 1 day
(22 Reviews)
4.5
sankargan88

I can you to improve the performance of your SQL statements. Initiate the chat and award me the contract to complete your project.

€29 EUR in 1 day
(1 Review)
2.4
crduran

Hi, Sir I have just read about your project. That's my WANTED task! I am Python expert with Latest Technologies & Web developer with rich experience. If you give me the opportunity to have your task EXCEPT other bids,, More

€25 EUR in 1 day
(1 Review)
0.6
sanjai

Hi We have a team of experienced database development Experience: 10yrs Duration : will complete in 3 to 4 hours Happy to work with you Relevant Skills and Experience 10yrs of database experience

€34 EUR in 1 day
(0 Reviews)
0.0
FreelancerKuba

Hi! Please take a look at my pluralsight profile to confirm my SQL skills: [login to view URL] I am mostly experienced with SQL Server but I believe I am able to handle your issue. Actually I More

€20 EUR in 2 days
(0 Reviews)
0.0
luccasman

I work with MySQL and I can help you with querying performance and analysis. I must have remote access to server due to make some validations. Feel free to contact me as desired and with confident. I also can assist yo More

€29 EUR in 2 days
(0 Reviews)
0.0