Help with mysql (indexes?)

V teku Objavljeno pred 5 letoma/leti Plačilo ob prevzemu

$10-30 USD

Plačilo ob prevzemu

V teku Plačilo ob prevzemu

I have a very simple Mysql setup, and very simple Select X from Y where Z =asd; query is taking 2 seconds (2.5 mil rows)

And the server (running on windows) has very high CPU.

Using the "explain" functionality I have discovered that index is not being used, and not sure how to set it up

Administracija podatkovnih baz Linux MySQL PHP SQL

ID projekta: #17967847

Več o projektu

2 predlogov Oddaljen projekt Aktiven pred 5 letoma/leti

Želiš zaslužiti nekaj denarja?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Bodi plačan/a za svoje delo
Oriši svojo ponudbo
Vpis in prijave na dela so brezplačni

2 freelancerjev ponuja v povprečju za $30 na tem delu

Profilna slika Gates777
Gates777

Hi! how are you? I am interested in your project. I have been worked with Mysql for 10 years. I can do your project well. Please contact me. Best Regards.

$35 USD v 1 dnevu
(109 ocen)
7.1
Profilna slika satyaguts
satyaguts

i understand what to do in this phase i have also faced this earlier in my projects can help you easily..

$25 USD v 1 dnevu
(16 ocen)
3.7
Objavi podoben projekt