MySQL/Advanced notes

From Official Kodi Wiki
< MySQL
Revision as of 13:55, 27 March 2012 by >Hasu0bs (→‎MySQL speed-up tweaks: copied tweaks from the website)
Jump to navigation Jump to search

HOW-TO:Sync multiple libraries/Contents

Symlink alternative to Path substitution

If your operating system supports symlinks, you can instead use a symlink which does not require editing the advancedsettings.xml. Here's how:

Assuming you have all of the share permissions correct, you can just REPLACE your thumbnails folder on all of the machines except the HOST machine with a symlink.

Here is an example for XBMC users on Windows 7:

Open an elevated command prompt (run as administrator) and then type in:

CD C:\Users\User_name\AppData\Roaming\XBMC\userdata\

mklink /D Thumbnails \\HTPC\Users\User_name\AppData\Roaming\XBMC\userdata\Thumbnails

Obviously, you need to adjust the paths for YOUR specific machine(s) or this won't work. Make sure you can reach the shared thumbnail directory through Explorer on each machine. If you can't, you have a permissions problem.

No further settings need to be adjusted, every machine that you do this on will essentially think it is using it's own thumbnails directory, but will in fact be using the HOST machines thumbnail directory. You do not HAVE to use the actual thumbnail directory of an existing XBMC installation as in the example code above. You could, for instance, use a neutral share and then create the symlink on the thumbnails directory for ALL of your machines.

If you were previously using the path substitution method, make sure you remove the path substitution from all machines that you use the symlink on.

MySQL speed-up tweaks[1]

In advancedsettings.xml:

Use the IP address and NOT the hostname of your MySQL server


In my.ini:

(add to mysqld section) skip-name-resolve

Name tag

Editor note: talk about the <name> tag here..

  1. MySQL speed-up tweaks for XBMC. For EDEN only the first two tweaks are necessary. See Comments for more information.