Synology DS118 - database performance

[notb]

I'm looking for database benchmarks of Synology DS118 - or something with similar specs (it has a 4-core Cortex A53: Realtek RTD1296).
I mean Synology-provided MariaDB instance (there's no support for virtualization in that model).

I checked a few reviews, but none covered the database (I'm not surprised though).
Maybe I missed a review that did? Or maybe someone here has a similar NAS?

 

[Bill_Bright]

Since so much depends on the actual drive within and since this is a diskless NAS, and the fact MariaDB is a fork of MySQL and just one of countless programs (or files) one may put on their NAS, I am not surprised you cannot find any benchmarks with that very specific and unique setup that would apply to very few users.

You might look at this, but again - so much would depend on the drive(s) you put in it to include whether hard drive or SSD, and the specs of the drives. Even the network connection is a factor.

 

[notb]

Since so much depends on the actual drive within and since this is a diskless NAS, and the fact MariaDB is a fork of MySQL and just one of countless programs (or files) one may put on their NAS, I am not surprised you cannot find any benchmarks with that very specific and unique setup that would apply to very few users.

I'm not entirely sure what you mean in this post.
Yes, NAS performance depends on drives used and other running applications. At the end of the day it's still just a server. And servers are being tested.

But with these basic NAS solutions the CPU is a limiting factor more than it is in models costing twice as much.

So yes, I was hoping for a review of this NAS with some (specified) drives - fast enough to let the CPU be the bottleneck.
And of course such a test would run without anything needless in the background - like every other computer benchmark, right?

You might look at this, but again - so much would depend on the drive(s) you put in it to include whether hard drive or SSD, and the specs of the drives. Even the network connection is a factor.

They aren't testing performance - just guessing it. Synology gives figures for basic file tasks which are more precise.

But more importantly: I'm specifically looking for database results, not file benchmarks. These are not given by Synology. And it's kind of crucial for my use case.

Anyway, thanks for the reply. Maybe someone else has what I need.

 

[Bill_Bright]

At the end of the day it's still just a server. And servers are being tested.

This is true - but tested using standard and common methods (to include standard and common software) so the results can be compared with other "similar" servers using those same standard and common methods. You asked about this NAS running a specific program - a program that would NOT be considered standard or commonly used for testing or comparative analysis.

And servers generally are NOT used to crunch or process data. They are meant to "serve" data to attached workstations that then do the crunching and modifying of those data files that are then saved back on the server. Servers are meant to facilitate sharing of those files. NAS, after all, stands for "network attached storage".

But with these basic NAS solutions the CPU is a limiting factor more than it is in models costing twice as much.

Yes, the CPU is "a" limiting limiting fact - but "a", in this case means it is just "1" of many limiting factors. It really takes very little CPU horsepower to fetch and save data to a drive. For sure, in many server scenarios, having more server memory is more important than having a faster CPU.

They aren't testing performance - just guessing it.

They are not guessing, they measured. But it was not meant to be a benchmark or a comparative analysis. As I said above, I am not surprised you can't fine what you are looking for. You are asking for something too specific that probably does not exist.

You said so yourself in your opening post, you could not find any benchmark using that database program. Don't be surprised if no one else can either.

If I could help you, I would.

The best I can do is suggest you narrow your search with Google. You probably should set a budget too, and decide now if looking to use hard drives or SSDs, how many drives you want, if RAID or not, and the total storage capacity you need.