2 XBMC PCs and 1 Database on the shared NAS - Printable Version
+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+---- Forum: Windows support (/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)
Very sloooooooow - jodeman - 2010-09-24 18:30
I've got the central database working, and it's great. But, it's incredibly slow on one of my systems. I select 'TV Shows' from the home screen, and it takes a good 30 seconds to display all the shows. Select a show, takes about 15 seconds to list the episodes. Select an episode, and it takes another 15 seconds before it starts playing. The same is true for movies.
I tried adding this to the my.conf on the system the mysql server is installed (per instructions on post #358 http://forum.xbmc.org/showpost.php?p=568188&postcount=358), but that didn't help any:
Here's my setup:
Acer Revo 3610 - this machine has all the shares on it, and the mysql database. this machine works perfectly.
Apple TV - this is the machine being slow (when just using smb shares, it's very snappy. just slow with the db)
I've got ubuntu 9 on the revo, and ubuntu 8 on the apple tv. But, I've got the same version of mysql on both (didn't work otherwise) I'm also running beta 2 of dharma on both.
If it helps, here's a copy of my xbmc.log file. http://pastebin.com/hj0JJUFj
Any ideas what the problem may be, or what else I can look at?
- albaranov - 2010-09-24 19:46
take a look at my post #478. It looks like the similar story of an index missing in the database. Cheers, Alex
- jodeman - 2010-09-24 21:29
Should I create an index on every table?
- albaranov - 2010-09-24 22:34
I'm not very good in that. You'd better talk to mySQL experts. Sorry, Alex
- jodeman - 2010-09-24 22:52
Sadly, me neither. This is the best I've found: http://articles.sitepoint.com/article/optimizing-mysql-application/4
But, I'm still fairly confused on exactly what to do.
- nitr8 - 2010-09-25 11:33
check out this see if it helps:
- jodeman - 2010-09-25 14:20
That's an excellent tutorial. The catch is, I'm having speed issues with videos. And, I'm not sure which table to add the index to. I may just do a backup, and try the movie table to see if movies speed up and go from there.
- jodeman - 2010-09-25 15:00
The weird thing is, if I do a query in mysql on the one having issues:
So, mysql itself seems to be snappy. Not sure why xbmc is being so slow with it. Unless there's something else causing the slowdown.
- sladinki007 - 2010-09-25 15:13
send a comment on that site to ask which tables should be indexed on the movies database
as for me 3000 movies + i think it could speed up my searches on that database too
- jodeman - 2010-09-25 15:20
sladinki007 Wrote:send a comment on that site to ask which tables should be indexed on the movies database
Posted on there. Will let you know if I learn anything.