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?
jpcolin
Member Posts: 53 Joined: Aug 2011 Reputation: 0 |
2012-04-10 20:38
Post: #1
(This post was last modified: 2012-04-10 20:39 by jpcolin.)
|
| find quote |
|
Memphiz
Team-XBMC Developer 
Posts: 7,677Joined: Feb 2011 Reputation: 91 Location: germany |
2012-04-10 22:38
Post: #2
read our wiki it has performance tips for mysql...
AppleTV2/iPhone/iPod: HowTo find debug logs and everything else which the devs like so much: click here HowTo setup NFS for XBMC: Wiki NFS HowTo configure avahi (zeroconf): Wiki Avahi READ THE IOS FAQ!: iOS FAQ |
| find quote |
|
grywnn
Member+ Posts: 379 Joined: Mar 2010 Reputation: 0 Location: Germany |
2012-04-10 22:46
Post: #3
...especially skip-name-resolve in my.ini is a live saver.
|
| find quote |
|
Ned Scott
Team-XBMC Wiki Guy Posts: 11,954 Joined: Jan 2011 Reputation: 131 Location: Arizona, USA |
2012-04-11 04:23
Post: #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.
You can make easy links to the XBMC wiki using double brackets around words: [[debug log]] = debug log, [[Add-on:YouTube]] = Add-on:YouTube, [[Adding videos to the library]] = Adding videos to the library, [[userdata]] = userdata, etc |
| find quote |
|
TechLife
Member+ 
Posts: 348Joined: Aug 2008 Reputation: 13 Location: Aurora, CO |
2012-04-11 04:40
Post: #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 +rep below* Main HTPC: Core i5, 8GB RAM, SSD, Win7x64SP1, Frodo 12.1 Extenders: 3-AppleTV (CrystalHD 2.0) 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...
(This post was last modified: 2012-04-11 04:45 by TechLife.)
|
| find quote |
|
noner
Senior Member Posts: 115 Joined: May 2011 Reputation: 0 |
2012-04-11 04:44
Post: #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
|
| find quote |
|
TechLife
Member+
Posts: 348Joined: Aug 2008 Reputation: 13 Location: Aurora, CO |
2012-04-11 05:18
Post: #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? Thanks. But it was the actual file I was looking for.  Found it in /etc/my.cnf *If I helped, please +rep below* Main HTPC: Core i5, 8GB RAM, SSD, Win7x64SP1, Frodo 12.1 Extenders: 3-AppleTV (CrystalHD 2.0) 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...
(This post was last modified: 2012-04-11 05:19 by TechLife.)
|
| find quote |
|
noner
Senior Member Posts: 115 Joined: May 2011 Reputation: 0 |
2012-04-11 05:57
Post: #8
Ah.. sorry.. my mistake
|
| find quote |
|
jpcolin
Member Posts: 53 Joined: Aug 2011 Reputation: 0 |
2012-04-12 09:35
Post: #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? or  It just seems bizare to have a mysql library but not a centralized thumbs and fanart database... |
| find quote |
|
DLeavy
Fan Posts: 371 Joined: Jun 2011 Reputation: 8 |
2012-04-12 14:14
Post: #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. 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 |
| find quote |
Search
Help