Posts: 7
Joined: Jun 2013
Reputation:
0
Hi guys,
I've been using XBMC on my RPi for a long time now only for watching movie/tv shows.
The otherday i decided to set it up using a Shared MySQL DATABASE.
However this make using XBMC a very slow task... Everything works however it is down in pace...
Navigation through the menu is very slow..
When plying a file, the TV is is on but all i can see if a blank screen however the sound from the files can be heard. and after 20-30 seconds the video would appear.
Is there any tweaks that can be done to improve the functionality of this? Or the fact i'm using the RPi will mean i can't improve the settings.
Posts: 8,966
Joined: Feb 2011
Reputation:
426
Using MySQL made my xbmc more responsive.
Where are you running MySQL? On the same Pi as xbmc wouldn't be advised. Running it on a PC/linux machine would be better.
Posts: 7
Joined: Jun 2013
Reputation:
0
I'm using a QNAP TS410..
And the RPi have the latest version of Open Elec on... i think its 3.05.
Posts: 7
Joined: Jun 2013
Reputation:
0
O ok...
My Qnap is quite slow, as its only got 256 ram, so it might be the db, slowing down everything.
In your advance settings are you guys setting anything beside the basic set up? As I'm using xbmc for a video lib only i've put the following in the advance settings.
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.0.84</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
</videolibrary>
<loglevel>2</loglevel>
</advancedsettings>
Posts: 327
Joined: Feb 2011
Reputation:
3
Hi shamz84,
Yes that is whats in my advancedsettings.xml - I also have the music db set up as well
Do you have much else running on the QNAP, or what is your network connection like between the Pi and the QNAP?
I have the following running constantly on my QNAP TS410
- NFS Services
- Web Services
- MySQL
- Sickbeard
- SabNZB
QNAP TS670 NAS - 4x4TB Raided with NFS Support & Central MySQL DB
Pi 3 [Xbian] - Samsung 46" ES7000 Smart TV & HT-E5550 3D BD Sound System
Pi 3 [Xbian] + Hyperion Ambilight- Samsung 48" Curved UE48JS9000 4k
PowerEthernet T1502 Powerline adapters
Posts: 442
Joined: Jul 2008
Reputation:
5
I had mine set up on MYSQL with 2 Pi's talking to it.. It died one day and i couldn't get it going and when i set them both back up as normal seperate SQLLITE DB's i couldn't believe how much faster they were than the MYSQL...
IMO, 2 seperate DB's Scheduled to scrape over night and the "watched" status synced via TRAKT.tv is the ideal solution for me.
Posts: 7
Joined: Jun 2013
Reputation:
0
I found out it was my nas, couldn't handle being a sql server on top of everything else.
I had a spare Pi and thought i'd try and install Raspbian on it with a mysql database.
This seem to have done the tick... Quite impressed how fast is...now i just need to sync the fan art in one location etc.