Thread Rating:
  • 0 Vote(s) - 0 Average
xbmc on Atv2 is extremely slow after configuring MySQL
#1
Hi,

I tried configure my ATV2 to use mysql DB, the problem it is so slow now it is not usable anymore.
Before it worked perfect, menu were fast enough, but now it takes ages to navigate...

i followed the wiki instructions.
here is my advancedsettings:

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.15</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>192.168.1.15</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>


<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails/</from>
<to>smb://192.168.1.15/share/videos/Thumbs/</to>
</substitute>
</pathsubstitution>

<gui>
<algorithmdirtyregions>3</algorithmdirtyregions>
<nofliptimeout>0</nofliptimeout>
</gui>


</advancedsettings>

I have a synology nas and followed these instructions also:
http://quixventure.com/2011/12/configure...-for-xbmc/

I exported, changed my advancedsettings and then reimported my library (which took ages), so my library is present but navigating is slow...

any idea why it does not work like it should?
Reply
#2
read our wiki it has performance tips for mysql...
AppleTV4/iPhone/iPod/iPad: HowTo find debug logs and everything else which the devs like so much: click here
HowTo setup NFS for Kodi: NFS (wiki)
HowTo configure avahi (zeroconf): Avahi_Zeroconf (wiki)
READ THE IOS FAQ!: iOS FAQ (wiki)
Reply
#3
...especially skip-name-resolve in my.ini is a live saver. Smile
Reply
#4
Don't forget, sharing thumbnails will make things slow as well. Try removing that part of your advancedsettings.xml file to see if that's the culprit of your slow-down.
Reply
#5
I'd love to try the skip-name-resolve tweak but I'm on Fedora 14. Anyone know if there is an equivalent to the my.ini file?

EDIT: Found it. On a linux server, it's most likely /etc/my.cnf
*If I helped, please "Thank" me below*

The XBMC team, plug-in devs, skinners, etc. do this for us for FREE in their spare time because they want to. Think about that for a second before you start bitching...
Reply
#6
(2012-04-11, 04:40)TechLife Wrote: I'd love to try the skip-name-resolve tweak but I'm on Fedora 14. Anyone know if there is an equivalent to the my.ini file?

Yep

Its called skip-name-resolve

Smile
Reply
#7
(2012-04-11, 04:44)noner Wrote:
(2012-04-11, 04:40)TechLife Wrote: I'd love to try the skip-name-resolve tweak but I'm on Fedora 14. Anyone know if there is an equivalent to the my.ini file?

Yep

Its called skip-name-resolve

Smile

Thanks. But it was the actual file I was looking for. Wink

Found it in /etc/my.cnf
*If I helped, please "Thank" me below*

The XBMC team, plug-in devs, skinners, etc. do this for us for FREE in their spare time because they want to. Think about that for a second before you start bitching...
Reply
#8
Ah.. sorry.. my mistake
Reply
#9
I'll try the skip-name-resolve trick, if i find how to add it in my synology DS410.

About the thumbs, if i don't share them, how will it work?
Will i have to rescan my library on all my devices to download the thumbs localy? orHuh

It just seems bizare to have a mysql library but not a centralized thumbs and fanart database...
Reply
#10
(2012-04-12, 09:35)jpcolin Wrote: I'll try the skip-name-resolve trick, if i find how to add it in my synology DS410.

About the thumbs, if i don't share them, how will it work?
Will i have to rescan my library on all my devices to download the thumbs localy? orHuh

It just seems bizare to have a mysql library but not a centralized thumbs and fanart database...

If you don't share them, you scan/update library on one of your machines and then manually copy the thumbnail directory to the others - not very elegant, but I believe there's something in the works to address this "shortcoming".

I do share my thumbnail directory, and the response isn't that bad - never more than a second to load the fanart in the background
Reply
#11
Were are the thumbs stored? Are they on a slow drive? are you on GB network?

My buddy is running his on a SSD on a GB network and his thumbs all load up nice and quick.
XBMC-ATV2 - Frodo
XBMC-LR - Zotac Zbox Plus - 36gb SSD - 3Gb Mem - Frodo
XBMC-BR - Foxcon 330i - 16gb SSD - 2Gb Mem - FrodoRc3
XBMC-Mini - MacMini - 128Gb OCZ Agility - 5Gb Mem - Frodo - Running SQL - Auto Library Update
Synology DiskStation Ds1512+(Dsm 4.3-3776) - 4gb Mem - 5*3tb Wd Reds [SHR] - 2GB Bonded Link - (SSD Cache WIP)

Reply
#12
Hi JPColin -

I wrote the Quixventure guide and I'm sorry to hear that your set-up is running slow. XBMC/MySQL runs very quickly for me and I am only using a cheap DS110j as my MySQL server...

I am reading the speed up tweaks now and will try them out at home, then update the guide if they show any improvement.

If you make any interesting progress, let me know and I will add it to my guide as well!

EDIT: Just added the my.conf entry and I think it may have added a little extra bump in performance. Let me know if you need any help setting it up on the Synology, I'll probably add a post to Quixventure shortly!
Guide for MySQL database using Synology NAS
http://youtu.be/3PmmDtK65ks

Silent AppleTV with Crystalbuntu
http://quixventure.com/2011/12/crystalbu...roduction/
Reply
#13
(2012-04-12, 14:14)DLeavy Wrote: [quote='jpcolin' pid='1073554' dateline='1334216122']

I do share my thumbnail directory, and the response isn't that bad - never more than a second to load the fanart in the background

There must be something wrong in my setup then!
Is more like 20-30s to load a menu!

I use a DS410 on a Dlink Gigabit router (of course ATV2 is 100Mbit)
I use SMB.
All is Cat5e Wired.

Until now the thumbs where on the ATV, and now on the Synology.

@Ozymandyaz
you have a setup with a synology as MySQL server and an ATV2 without the skip-name-resolve and it runs quickly? and you share the thumbs?
there must be something really wrong in my setup then

Reply
#14
Well, you can determine if it's the MySQL database or the thumbs, by only changing one of them and testing - i.e use the MySQL database, but keep the thumbs local. See if you're still getting a performance hit.

Might also consider turning on debugging and posting a log debug log (wiki) - this might tell you where it's spending all its time.
Reply
#15
(2012-04-12, 16:53)jpcolin Wrote:
(2012-04-12, 14:14)DLeavy Wrote: [quote='jpcolin' pid='1073554' dateline='1334216122']

I do share my thumbnail directory, and the response isn't that bad - never more than a second to load the fanart in the background

There must be something wrong in my setup then!
Is more like 20-30s to load a menu!

I use a DS410 on a Dlink Gigabit router (of course ATV2 is 100Mbit)
I use SMB.
All is Cat5e Wired.

Until now the thumbs where on the ATV, and now on the Synology.

@Ozymandyaz
you have a setup with a synology as MySQL server and an ATV2 without the skip-name-resolve and it runs quickly? and you share the thumbs?
there must be something really wrong in my setup then

Its gotta be the thumbs... I use MySQL on the NAS and I have my thumbs shared via path substitution using NFS. All other connections are SMB... Maybe try NFS just for the thumbs? I have used SMB for thumbs and did not see much difference, so YMMV.. But yeah, a debug log may be a good idea, see what's really going on! There is probably a permission problem somewhere.

Guide for MySQL database using Synology NAS
http://youtu.be/3PmmDtK65ks

Silent AppleTV with Crystalbuntu
http://quixventure.com/2011/12/crystalbu...roduction/
Reply



xbmc on Atv2 is extremely slow after configuring MySQL00