Can we use innodb to store latitutude and logitude and retrieve 20 closest points well? I've heard that innodb Why innodb doesn&#39;t store geospatial data? store geospatial data but cannot index it.

Not really sure what it means. Is it a good idea to ask 20 closest businesses if point is stored in innodb?
An efficient, but complex, solution:
http://mysql.rjweb.org/doc.php/latlng
(The design actually prefers InnoDB.)