Pilsener
Posts: 59
Joined: Thu Jan 03, 2013 3:25 pm

How well does R-Pi perform as a mySQL server?

Tue May 06, 2014 8:41 pm

Does anyone have any comparisons about how well the R-Pi performs as a mySQL-server?
If I run it as a database-server for a forum, how many users would it be able to handle at once before starting to slow down?

riklaunim
Posts: 265
Joined: Tue Apr 22, 2014 7:34 pm

Re: How well does R-Pi perform as a mySQL server?

Tue May 06, 2014 9:28 pm

Databases like to use RAM, and Raspberry Pi doesn't have it much plus it's very slow DDR1. Also a forum means dynamic language which will use CPU to execute. Raspberry Pi won't handle such combo as efficiently as typical shared hosting.

If you would want to use the database from another server then you also need to add the network latency, but you could gain some performance margin (although more data in database the more RAM would be handy for it, when it will start using I/O it will slow down even more).

It would have to be very low traffic forum in short.

You can look also on this: http://www.raspberrypi.org/forums/viewt ... 36&t=76539

Pilsener
Posts: 59
Joined: Thu Jan 03, 2013 3:25 pm

Re: How well does R-Pi perform as a mySQL server?

Wed May 07, 2014 12:22 pm

The post you linked to has a line saying "I managed to keep RAM usage of mysqld process under 7.5MB."
Is this the memory usage for each user-connection, to put it very simple?

User avatar
pluggy
Posts: 3635
Joined: Thu May 31, 2012 3:52 pm
Location: Barnoldswick, Lancashire,UK
Contact: Website

Re: How well does R-Pi perform as a mySQL server?

Thu May 08, 2014 4:06 pm

The severe lack of CPU horsepower is probably going to get in the way before the limited RAM. 512 MB isn't that bad for such a limited computer, it pretty pitiful by modern computer standards, but back when X86 processors had the same grunt as a Pi, the typical ram in a PC was around 32MB. (Circa 1998) In answer to the OP, its not going to handle very many users, especially if its doing the Web front end as well.
Don't judge Linux by the Pi.......
I must not tread on too many sacred cows......

Return to “Advanced users”