Odroid N2 with MariaDB performance

[glenswada]

If anyone is interested in performance of MariaDB/MySQL on Odroid N2 they might be interested in a comparison of Odroid N2/SSD with Rock Pi 4B/NVME.

https://forum.radxa.com/t/review-impres ... -pi-4b/336

I ran his test on my Odroid N2 with a database existing on a samsung SSD connected through USB3. The Odroid N2 was slightly faster inserting 200,000 records and 300% faster than the Rock Pi 4B (with NVME) with select statement that calculated the triangulation of some 200,000 records....

Rock Pi 4B
Time to insert 200001 records = 368.8964 seconds
Average insert time per record = 0.0018444727776361
Select Statement 1.688 seconds

Odroid N2
Time to insert 200001 records = 322.0876 seconds
Average insert time per record = 0.0016104299478503
Select Statement 0.555 seconds

[powerful owl]

My tests on real websites with a lot of database access (copies of) show the N2 to only slightly outperform the RK3399.

[glenswada]

My tests on real websites with a lot of database access (copies of) show the N2 to only slightly outperform the RK3399.

The insert results do confirm that requests are dominated by disk access , the RK3399 isn't too far behind odroid N2. But many systems use geospatial queries that are more cpu intensive. Which might be as simple as displaying a list of addresses that are certain distance from a given location, when the user enters an address. The system I am writing will be running geospatial queries so the results were relevant to my needs.

[mad_ady]

Are you using some mysql/mariadb geographic extension? If yes, can you give more details about data type, queries?
I built a GIS web interface that showed alarms a decade ago and had to use coordinates as double, with no gis-specific functions. Good thing most queries only used a bounding box to get alarms from a rectangular region...