Posts: 23
Joined: Mar 2012
Reputation:
0
Hello there,
I am having speed issues with my multiple XBMC machines setup (two Win7 and one XBMCBuntu PC) when using a centralised mysql database. The mysql database is on a quad-core 3.2 ghz win7 pc with gigabit lan. A single installation with a local sqlite database is 10 times faster. With mysql it sometimes takes 5-10 seconds, depending on the connection to show the movie list, even on the local quad-core!
So I was wondering if it wasn't possible to use the thin sqlite database as a multi room setup. Maybe with symlinks from the other machines to the database on the server pc?
Has anyone tried this? Does it even work and is it really faster?
Posts: 311
Joined: Sep 2009
Reputation:
0
It could be due to the hard drive in your server spinning down when not in use. Maybe try an SSD, or else set it to spin 24/7 (that's not good for the hdd though).
Posts: 23
Joined: Mar 2012
Reputation:
0
my nas is running 24/7 and the quad-core win 7 hosting the mysql server also. i also tried all those mysql tweaking hints with just a slight performance improvement. any thoughts on sqlite?
Posts: 31,445
Joined: Jan 2011
2012-04-26, 00:19
(This post was last modified: 2012-04-26, 00:19 by Ned Scott.)
sqlite doesn't like multiple users. If you only used one XBMC install at a time (full stop) then it would be okay, but at that point you could just share the DB files directly.
Also, if you are sharing thumbnails using the
MySQL (wiki) wiki guide then that can cause slow-downs as well.
Posts: 23
Joined: Mar 2012
Reputation:
0
I have now tried sqlite as multi room setup with the userdata/database folder shared via symlink on a network share and it fails to work with more than one client. so no recommendation for this.
on the other hand when using a mysql database it is very fast when using a local thumbnails cache and not sharing the thumbnails cache on a network drive as I did before. does anyone have a good way to synchronize the thumbnails folder between xbmcbuntu and windows 7 maybe by using some kind of synching tool?
Posts: 23
Joined: Mar 2012
Reputation:
0
2012-04-27, 11:07
(This post was last modified: 2012-04-27, 11:24 by iceman1000.)
Thank you guys for your quick replies!
@krease: I already tried all those mysql speed hints (ip, caching etc) - gave me only a slightly faster installation.
the problem is the thumbs being on the server/nas. Just the mysql database with local thumbs speeds up xbmc movie-menu 10 times !
@phsyraxion: I am trying with rsync and unison but I'm not done with it yet - quite difficult for me to use it with linux and windows. I would really love to see your batch script, maybe it would work for me too. Would you post it?
Posts: 41
Joined: Sep 2010
Reputation:
0
I wouldn't mind seeing the script you wrote, either. No sense reinventing the wheel.