Odroid N2 with MariaDB performance

Post Reply
glenswada
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:

Odroid N2 with MariaDB performance

Unread post by glenswada » Sat Dec 07, 2019 12:10 pm

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
These users thanked the author glenswada for the post:
tobetter (Sat Dec 07, 2019 12:29 pm)

powerful owl
Posts: 116
Joined: Thu Mar 28, 2019 8:57 pm
languages_spoken: english
ODROIDs: 6 x HC1, 3 x H2
Has thanked: 21 times
Been thanked: 9 times
Contact:

Re: Odroid N2 with MariaDB performance

Unread post by powerful owl » Sat Dec 07, 2019 1:59 pm

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

glenswada
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

Unread post by glenswada » Sat Dec 07, 2019 4:21 pm

powerful owl wrote:
Sat Dec 07, 2019 1:59 pm
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.

User avatar
mad_ady
Posts: 7090
Joined: Wed Jul 15, 2015 5:00 pm
languages_spoken: english
ODROIDs: XU4, C1+, C2, N1, H2, N2
Location: Bucharest, Romania
Has thanked: 305 times
Been thanked: 209 times
Contact:

Re: Odroid N2 with MariaDB performance

Unread post by mad_ady » Sat Dec 07, 2019 8:03 pm

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...

Post Reply

Return to “General Topics”

Who is online

Users browsing this forum: No registered users and 0 guests