Posts: 456
Joined: Dec 2010
Reputation:
0
I have also read in various placed in the forum to add these indices as well:
alter table song add index ix_idalbum(idalbum)
create index idartist_idx on song (idartist)
create index idartist_idx on album (idartist)
create index idartist_idx on exartistsong (idartist)
create index idartist_idx on exartistalbum (idartist)
I not yet tried these out myself but intend to tonight.
Can adding too many indices hurt the performance of the database?
Posts: 1,275
Joined: Oct 2006
Reputation:
5
I am planning on using the lifehacker guide to sync xbmc, but I have one question? When I add additional media will I need to modify the database to include the media? or will a update from ember to both machines do the trick?
Posts: 1,275
Joined: Oct 2006
Reputation:
5
[quote=clambert]If it's added, every machine sees the change. When it scans the for new media anything new is added to the database. I'm not sure if I 100% understand the question. The only real issue is with thumbnails. By default they are locally stored on each machine. You can make modifications to have them feed off a share, something I haven't done yet. Some people have reported a minor performance hit though. I'm going to give it a whirl myself when I get some time to play.[/QUOTE/]
Alright thanks
Posts: 18
Joined: Sep 2010
Reputation:
0
svenh
Junior Member
Posts: 18
I got this working today with the instructions from the original post at lifehacker, however at first it would not work. I had installed the 32 bit MSI version of MySQL (mysql-5.5.9). Created the tables etc.
Upon launching, the UI would lag really bad and nothing would get scanned in if I tried to add content Looking at the xbmc.log I got errors such as this:
"Can't get hostname for your address"
I found you have to go into your mysql directory and add "skip-name-resolve
" to your my.ini file. Afterward I restarted the MySQL service and it worked.
I am pretty sure I saw this somewhere else because the fix sounded really familiar, but if anyone else tries this and runs into the problem maybe this post will help them!
Posts: 1,275
Joined: Oct 2006
Reputation:
5
2011-02-12, 20:13
(This post was last modified: 2011-02-13, 01:15 by Hudson_Hawk04.)
I was able to get the database working properly using the sql server, but it may have been at the expense of my mediaportal DVR setup, we will see, might be my next project to re-do
Posts: 1,275
Joined: Oct 2006
Reputation:
5
do you allready have a program using mysql? I have media portal on one machine on my network and tried putting the database on that machine and it would spit out an error similar to yours. I was able to get it working by putting mysql server on the machine with all my media. Not sure at the moment how to kill the xbmc database but I will do some looking around, I will also post on the integrity of my Media Portal install.
Posts: 1,275
Joined: Oct 2006
Reputation:
5
when I attempted this again and got it working I entered the commands from the lifehacker article I entered them line by line as opposed to how they were grouped. Just playing a hunch I may be wrong though.
Posts: 1,275
Joined: Oct 2006
Reputation:
5
Got a quick question, I had the database working just not the way I wanted it. It was running on the pc where my media is which has a wireless connection to my remaining machines? The question is how do I create the xbmc databases so they are on a machine that is hardwired (I would like to put them on my MediaPortal machine which runs MySQL.) I have tried once before and it corrupted MediaPortal, do I need to create a separate access point for the XBMC databases to maintain the integrity of the other databases? Just looking for some feedback before I try again. Thanks Guys.