xbmc on Atv2 is extremely slow after configuring MySQL

ok it seems to work for mysql, now i'm going to try the path substitution.
but how can use path substitution with NFS and the rest (database and movies) in SMB?
@Ozymandyaz ?

having problems finding/editing this file. anyone have detailed instructions on a synology dms 4

(2012-04-13 18:35)jpcolin Wrote:  ok it seems to work for mysql, now i'm going to try the path substitution.
but how can use path substitution with NFS and the rest (database and movies) in SMB?
@Ozymandyaz ?

Hi jpcolin -

Its really easy actually, the path substitution is only used for the thumbs so it in no way interferes with anything else. You set it up like this in the advanced settings:


The <to> section is the only line that ever changes since you will need to choose the protocol and path to your thumbs. If you want SMB, use "smb://<PATH>" for NFS it's "nfs://<PATH>" etc... In your sources you choose what protocol you want for the actual media files, but they do not need to be the same as the protocol used for the path substitution =)

Now... You just need to make sure you can make your NFS server work =)

(2012-04-14 19:48)Ozymandyaz Wrote:  

(2012-04-13 18:35)jpcolin Wrote:  ok it seems to work for mysql, now i'm going to try the path substitution.
but how can use path substitution with NFS and the rest (database and movies) in SMB?
@Ozymandyaz ?

Hi jpcolin -

Its really easy actually, the path substitution is only used for the thumbs so it in no way interferes with anything else. You set it up like this in the advanced settings:

Code:

<pathsubstitution>
    <substitute>
      <from>special://masterprofile/Thumbnails/</from>
      <to>nfs://192.168.1.90/volume1/XBMC/Thumbnails_XBMC1/</to>
    </substitute>
</pathsubstitution>

The <to> section is the only line that ever changes since you will need to choose the protocol and path to your thumbs. If you want SMB, use "smb://<PATH>" for NFS it's "nfs://<PATH>" etc... In your sources you choose what protocol you want for the actual media files, but they do not need to be the same as the protocol used for the path substitution =)

Now... You just need to make sure you can make your NFS server work =)

Actually that is what I meant, it is not just replacing smb by nfs in the pathsubstitution line, what else do I have to do? Some config in my Synology? Any guide?

(2012-04-14 15:05)mcfreiz Wrote:  having problems finding/editing this file. anyone have detailed instructions on a synology dms 4

Hi mcfreiz -

It's no surprise that you cant find the file... Since it doesn't exist =)

Turns out that the my.cnf file is totally optional and you will need to create your own on the Synology. Fortunately, its super easy to do, here is how:

First, enable terminal in the Synology control panel 'Control Panel -> Terminal' by checking the 'Enable SSH Service' tick box.

Now, get an application like putty so that you can SSH to the Synology.

Start Putty and connect to the NAS. Login as root and use the same password that you set-up for your admin account (its actually the root account.)

Once in, type the following commands:


This will copy a sample cnf file to the proper location and then open it in the vi text editor.

Use the arrow keys to move down about a page and a half until you see the [mysqld] section. Get the cursor on the line that says "thread_stack = 128" and type the "i" key to enter the edit mode in VI.

Hit enter to make a new line and use an arrow key to get to that line. In the blank line add the text:
skip-name-resolve

Hit escape to exit edit mode, then type:
(that is colon, w, q, and then hit enter. The colon will start the command mode and wq will write and quit VI. Hitting enter will run the command and quit VI.

If you make a mistake and VI gets weird on you, hit escape, then :q! (colon, q, exclamation point, and Enter) This will exit VI without saving. VI can be quirky for the uninitiated...

Then you need to restart MySQL, type the following:


If you messed up, you will probably see an error while re-starting and MySQL will just ignore the cnf file =)

(2012-04-14 19:56)jpcolin Wrote:  Actually that is what I meant, it is not just replacing smb by nfs in the pathsubstitution line, what else do I have to do? Some config in my Synology? Any guide?

HA NP! Here is the official XBMC Wiki entry for NFS, scroll to the bottom for Synology specific instructions. I actually have no idea if this is all necessary just for Thumbs, but I did it and it worked for me =)

http://wiki.xbmc.org/index.php?title=NFS

(2012-04-13 14:39)Ozymandyaz Wrote:  Ok, I see the issue, there are empty databases named xbmc_video and xbmc_music. In the past you needed to create those, but now it screws up XBMC... Go into phpmyadmin and delete those databases. You only want the ones that end with numbers to remain, I.e. xbmc_video60 and xbmc_music19.

ive had this running for a few years now with the mySQL db on a ubuntu-server and 2 xbmc's using nfs for the media + rSync for the cache. upgrading to eden was not clean... because the mySQL user didn't have access to create new databases, but once i got that sorted it migrated everything. ( dharma > rc2 > eden )

i have skip-name-resolve in my.cnf
i have entries in my /etc/hosts file on the server and clients
both installs browse the library just fine.
but updating is PAINFUL

rc2 made video58 and eden made video60
... i just dropped the 2 old ones,
but these didn't seem to be getting in my way.

xbmc still HANGS when i update the library (from either machine)
for 30 sec ... then it starts crawling through my directories

... clearly something is wrong with trying to update, but i don't get it
does anyone have a clue what's going on here

box1; is ubuntu lucid minimal + xbmc eden
box2; is mint lisa (ubuntu onoric / kde) + xbmc eden

( this has been happening for a while, - dharma & eden-
... but i've been ignoring it, but its starting to gett on my nerves )

log file? (first link in my signature)