Suoritettu

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.

Taidot: MySQL, Linux, Tietokannan hallinto, PHP, Apache

Näytä lisää: 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

Tietoa työnantajasta:
( 12 arvostelua ) Viziru, Romania

Projektin tunnus: #23921220

Myönnetty käyttäjälle:

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) Lisää

€30 EUR 1 päivässä
(2 Arvostelua)
3.3

9 freelanceria on tarjonnut keskimäärin 31€ tähän työhön

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 Lisää

€72 EUR 1 päivässä
(251 arvostelua)
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 Lisää

€20 EUR 7 päivässä
(28 arvostelua)
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 1 päivässä
(22 arvostelua)
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 1 päivässä
(1 arvostelu)
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,, Lisää

€25 EUR 1 päivässä
(1 arvostelu)
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 1 päivässä
(0 arvostelua)
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 Lisää

€20 EUR 2 päivässä
(0 arvostelua)
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 Lisää

€29 EUR 2 päivässä
(0 arvostelua)
0.0