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?