2011-09-26, 21:24
First off, thanks to EVERYBODY on here for all the help with my MySQL adventure and all my other xbmc questions. I am constantly amazed by how generous everybody on here is with their time and know-how.
Anyways, I have MySQL set up running on a Synology 1511+ and accessing it with a HTPC and a jailbroken ATV2 (as of midnight last night), both on gigabit ethernet. I used the typical database entries in adancedsettings.xml as well as a pathsubstitution to sync the thumbnails (as well as identical sources.xml files using the username:password@internalip naming convention). As I said everything is working but its pretty slow (as others have reported about 20-30 secs to update when I click on Movies). I was just looking for clarification on a few things before I try what I found and hoping someone has some answers (I'm sure they would help others as well):
1) Is there any known performance differences between using the pathsubstitution in advancedsettings.xml or creating symlinks? Seems like the same, just curious if this is something I should try.
2) Multiple people reported early in this thread that MySQL was very slow when they tried to import their old library after setting up MySQL and that when they redid it by just reBUILDING their library it worked must better. But then nobody else suggested this. Can anyone confirm if this is still a possible fix/help? I'd hate to redo everything if its not gonna help but there's another hurdle before I try the other things:
3) As I said, I have MySQL running on my NAS and cannot easily edit the .ini file. I'd like to do this (http://forum.xbmc.org/showpost.php?p=646799&postcount=5), but I'm a noob and though I figured out how to Putty into it, I (apparently) need to learn the vi command in order to make changes. Can anybody offer any advice on how to implement these changes? Can it be done with PHPAdmin (the web interface)?
and this last one is just for my edification because I don't think its related to the speed but I've read conflicting information, but do I need a sources.xml file with identical Movie and TV Shows links for all the installations? Seems redundant but also have heard its necessary.
Anyways any help would be greatly appreciated (as it already is!).
Anyways, I have MySQL set up running on a Synology 1511+ and accessing it with a HTPC and a jailbroken ATV2 (as of midnight last night), both on gigabit ethernet. I used the typical database entries in adancedsettings.xml as well as a pathsubstitution to sync the thumbnails (as well as identical sources.xml files using the username:password@internalip naming convention). As I said everything is working but its pretty slow (as others have reported about 20-30 secs to update when I click on Movies). I was just looking for clarification on a few things before I try what I found and hoping someone has some answers (I'm sure they would help others as well):
1) Is there any known performance differences between using the pathsubstitution in advancedsettings.xml or creating symlinks? Seems like the same, just curious if this is something I should try.
2) Multiple people reported early in this thread that MySQL was very slow when they tried to import their old library after setting up MySQL and that when they redid it by just reBUILDING their library it worked must better. But then nobody else suggested this. Can anyone confirm if this is still a possible fix/help? I'd hate to redo everything if its not gonna help but there's another hurdle before I try the other things:
3) As I said, I have MySQL running on my NAS and cannot easily edit the .ini file. I'd like to do this (http://forum.xbmc.org/showpost.php?p=646799&postcount=5), but I'm a noob and though I figured out how to Putty into it, I (apparently) need to learn the vi command in order to make changes. Can anybody offer any advice on how to implement these changes? Can it be done with PHPAdmin (the web interface)?
and this last one is just for my edification because I don't think its related to the speed but I've read conflicting information, but do I need a sources.xml file with identical Movie and TV Shows links for all the installations? Seems redundant but also have heard its necessary.
Anyways any help would be greatly appreciated (as it already is!).