AdvacedSettings.xml for Kodi with MySQL and other tweaks.

advancedsettings.xml

<!-- General Settings -->
<advancedsettings>
<loglevel hide="true">-1</loglevel> <!-- Comment: Disables logging -->
<playcountminimumpercent>95</playcountminimumpercent>
<skiploopfilter>0</skiploopfilter> <!-- Comment: For RPi or similar use 16 or higher (low CPU usage) -->
<nodvdrom>true</nodvdrom>

<!-- MySQL Library -->
<videodatabase>
	<type>mysql</type>
	<host>192.168.1.100</host> <!-- Comment: IP Address of MySQL Server -->
	<port>3306</port>
	<user>xbmc</user> <!-- Comment: MySQL Username -->
	<pass>xbmc</pass> <!-- Comment: MySQL Password -->
</videodatabase>

<!-- Streaming Optimization -->
<network>
<buffermode>1</buffermode> <!-- Comment: Default is 1 -->
<cachemembuffersize>52428800</cachemembuffersize> <!-- Comment: Default is 20971520 bytes or 20 MB -->
<readbufferfactor>2.0</readbufferfactor> <!-- Comment: Default is 1.0 -->
</network>

<!-- Video Library Tweaks -->
<videolibrary>
	<cleanonupdate>true</cleanonupdate> <!-- Comment: Also clean library during library update -->
	<importwatchedstate>true</importwatchedstate>
	<hideallitems>true</hideallitems> <!-- removes the "*All" items from the video library -->
	<hideemptyseries>true</hideemptyseries>  <!-- hide empty series in the video library -->
</videolibrary>

<videoscanner>
	<ignoreerrors>true</ignoreerrors> <!-- Set to true to silently ignore errors while scanning videos. This prevents the error dialogue box, so you don't have to keep hitting "yes" to keep scanning.-->
</videoscanner>

<!-- Playback Tweaks -->
<video>
	<timeseekforward>15</timeseekforward> <!-- Comment: Skip back time 15 s -->
	<timeseekbackward>-15</timeseekbackward> <!-- Comment: Skip forward time 15 s -->
	<subsdelayrange>240</subsdelayrange> <!-- Comment: Subtitle offset adjustment range -->
</video>
</advancedsettings>