Geo localized database RTREE I'm using MYSQL V5.6.24 GPL

I have a database with 200K rows and growing and I'm trying to get the nearest, based on points. I have all the database in InooDB, and to use Spatial data, I create one table with the Points with Mysiam.

everything works great, the problem is that when I sort based on ST_Distance, I'm not using any index, I create a SPATIAL index with the coordinates, and still using file_sort to sort. And Mysql doesn't allow me to use RTREE INDEX

Any idea?
In order to get advantage of the SPATIAL index you have to filter results using a bounding box (or any other geometry type) with the functions st_within() or st_contains(). You have some examples here:


Query Optimization with MySQL 5.7 and MariaDB 10 - GIS Improvements
Using the new spatial functions in MySQL 5.6 for geo-enabled applications
MySQL 5.7 and GIS, an Example