library on mysql server faster than sd card?
#1
Hi,

My questions is if it will be faster streaming user library from a seperate mysql server (running on a nas) instead of keeping it on the raspberry sd card?
My purpose is not to share the library across multiple clients but to make browsing through the library faster and more stable.

thanks for your comments.
Reply
#2
Hi, that's the way i'm using my Raspberry Pi, Files are being shared by NFS and Media library through Mysql, and it works quite good :-)

To be honest i'm not really sure which method would be faster and more reliable on Raspi, Mysql vs Standalone, have tried both and i have not noticed a real difference.

But for sure, scanning on Raspi is very very low and boring, if you media library often changes, in my opinion using Mysql is an evidence.
I you set your Raspi to check for new media at boot, that's big lost of time and CPU usage compared to Mysql.

Anyway, i'm still experimenting this, so things may change;

See my blog Cool
http://youresuchageek.blogspot.fr/2012/0...ec-on.html
http://youresuchageek.blogspot.fr/2012/0...media.html
Please support my Blog, XBMC and Linux related :-)
http://youresuchageek.blogspot.com
Reply
#3
(2012-09-21, 15:48)guilmxm Wrote: Hi, that's the way i'm using my Raspberry Pi, Files are being shared by NFS and Media library through Mysql, and it works quite good :-)

To be honest i'm not really sure which method would be faster and more reliable on Raspi, Mysql vs Standalone, have tried both and i have not noticed a real difference.

But for sure, scanning on Raspi is very very low and boring, if you media library often changes, in my opinion using Mysql is an evidence.
I you set your Raspi to check for new media at boot, that's big lost of time and CPU usage compared to Mysql.

Anyway, i'm still experimenting this, so things may change;

See my blog Cool
http://youresuchageek.blogspot.fr/2012/0...ec-on.html
http://youresuchageek.blogspot.fr/2012/0...media.html

hey man. interesting posts in your blog. thanks for the feedback. If you perform any perfomance tests let us know of the result.

Reply
#4
definetly mysql server, 'cools down' the pi. I have noticed an increased speed while browsing through my music after keeping the DB on a separate mysql server.
Reply
#5
Which version does XBMC run on on pi? I have Windows Eden Stable on my other machine and I need the DB to be usable by both XBMC's, so the db code version needs to be the same.
Reply
#6
hmm..it runs raspbmc RC5, im not sure which version of XBMC is used...
Reply
#7
(2012-09-24, 15:24)boom123 Wrote: hmm..it runs raspbmc RC5, im not sure which version of XBMC is used...

there are at least 3 distributions

OpenELEC
Xbian
RaspBMC
being the main ones and they all are XBMC FRODO Alphas (12 I think)
Reply
#8
(2012-09-25, 02:32)fma965 Wrote:
(2012-09-24, 15:24)boom123 Wrote: hmm..it runs raspbmc RC5, im not sure which version of XBMC is used...

there are at least 3 distributions

OpenELEC
Xbian
RaspBMC
being the main ones and they all are XBMC FRODO Alphas (12 I think)



are u sure openelec uses 12 build?
Reply
#9
(2012-09-25, 09:02)boom123 Wrote:
(2012-09-25, 02:32)fma965 Wrote:
(2012-09-24, 15:24)boom123 Wrote: hmm..it runs raspbmc RC5, im not sure which version of XBMC is used...

there are at least 3 distributions

OpenELEC
Xbian
RaspBMC
being the main ones and they all are XBMC FRODO Alphas (12 I think)

are u sure openelec uses 12 build?

Yes. OpenELEC uses Frodo on the RPi.
Reply
#10
(2012-09-25, 10:20)gimli Wrote:
(2012-09-25, 09:02)boom123 Wrote:
(2012-09-25, 02:32)fma965 Wrote: there are at least 3 distributions

OpenELEC
Xbian
RaspBMC
being the main ones and they all are XBMC FRODO Alphas (12 I think)

are u sure openelec uses 12 build?

Yes. OpenELEC uses Frodo on the RPi.

yes there is no pi support for pre frodo afaik.
Reply

Logout Mark Read Team Forum Stats Members Help
library on mysql server faster than sd card?0