XBMC Community Forum
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)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77

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:
Code:
skip-name-resolve

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

Hi,
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

albaranov Wrote:Hi,
take a look at my post #478. It looks like the similar story of an index missing in the database. Cheers, Alex

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

jodeman,

check out this see if it helps:

http://humphrey.za.net/2010/09/25/xbmc-mysql-multi-room-sync/

- jodeman - 2010-09-25 14:20

nitr8 Wrote:jodeman,

check out this see if it helps:

http://humphrey.za.net/2010/09/25/xbmc-mysql-multi-room-sync/

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:
Code:
mysql> select * from tvshow;
I get this:
Code:
69 rows in set (0.01 sec)

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

nitr8 Wrote:jodeman,

check out this see if it helps:

http://humphrey.za.net/2010/09/25/xbmc-mysql-multi-room-sync/

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

Shocked

- 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

as for me 3000 movies + i think it could speed up my searches on that database too

Shocked

Posted on there. Will let you know if I learn anything.