Why is mysql query with BINARY running indefinitely?

Question

MySQL

SELECT BINARY `name` as bname, COUNT(*) FROM `param` GROUP BY BINARY `name` ORDER BY COUNT(*) DESC

this request is spinning for a long time.
How to properly select all unique values ​​and sort them by count?

Answer 1

SELECT
  BINARY `name` `bname`,
  COUNT(*) `cnt`
FROM `param`
GROUP BY `bname`
ORDER BY `cnt` DESC