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
Odroid N2 with MariaDB performance
-
- Posts: 180
- Joined: Thu Mar 28, 2019 8:57 pm
- languages_spoken: english
- ODROIDs: 2 x HC1, 3 x H2, 1 x H2+
- Has thanked: 47 times
- Been thanked: 18 times
- Contact:
Re: Odroid N2 with MariaDB performance
My tests on real websites with a lot of database access (copies of) show the N2 to only slightly outperform the RK3399.
-
- Posts: 10
- Joined: Sun Sep 01, 2019 3:19 pm
- languages_spoken: english
- ODROIDs: Odroid N2
- Has thanked: 2 times
- Been thanked: 1 time
- Contact:
Re: Odroid N2 with MariaDB performance
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.powerful owl wrote: ↑Sat Dec 07, 2019 1:59 pmMy tests on real websites with a lot of database access (copies of) show the N2 to only slightly outperform the RK3399.
-
- Posts: 9095
- Joined: Wed Jul 15, 2015 5:00 pm
- languages_spoken: english
- ODROIDs: XU4, C1+, C2, C4, N1, N2, H2, Go, Go Advance
- Location: Bucharest, Romania
- Has thanked: 597 times
- Been thanked: 584 times
- Contact:
Re: Odroid N2 with MariaDB performance
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...
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...
Who is online
Users browsing this forum: No registered users and 0 guests