Help with mysql (indexes?)

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

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

Database Administration Linux MySQL PHP SQL

Project ID: #17967847

About the project

2 proposals Remote project Active 5 years ago

2 freelancers are bidding on average $30 for this job

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 in 1 day
(109 Reviews)
7.1
satyaguts

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

$25 USD in 1 day
(16 Reviews)
3.7