Mysql Query Performance

[zheyiyi]

I am curious If multiple server run query for the same queue_name in mysql, one query will lock data whose has the same queue_name, other queries need to wait for the first query finished and unlock. There are any optimization we can do?

final String PEEK_MESSAGES =
"SELECT message_id, priority, payload FROM queue_message use index(combo_queue_message) WHERE queue_name = ? AND popped = false AND deliver_on <= TIMESTAMPADD(MICROSECOND, 1000, CURRENT_TIMESTAMP) ORDER BY priority DESC, deliver_on, created_on LIMIT ?";