Correct index to use

[skyline]

I’m experiencing high server load due to mysql.
I have lots of these queries:

SELECT * FROM tablea WHERE field1=‘XXX’ AND field2=‘YYY’ ORDER by timeset DESC LIMIT 1;

I’m retrieving around another 5 fields as a result.
Should i create a multi column index on tablea setting all 3 fields?

[r937]

@skyline

I’m retrieving around another 5 fields as a result.

how can that be???

you’re already retrieving all possible columns via your use of the dreaded, evil “select star”

@skyline

Should i create a multi column index on tablea setting all 3 fields?

that depends

[skyline]

Quiet right! So i need to list all the fields after the select. When you say it depends…?

[r937]

@skyline

Quiet right!

quiet riot!!! one of da best metal bands evar!!

@skyline

When you say it depends…?

yup, it depends on which queries you want to run