[kpon]

Hello,

With SQL database, it takes abuot 20-30 seconds for me to access any movie or tv show. Even waiting for the context menu, it'll take about the same time.

I'm running Frodo on all my machines (openelec, RPi on openelec, xbmc on OSX). The SQL database is hosted on a Synology DS213.

This is the log file from xbmc on OSX: http://pastebin.com/TFDaufu3

This is my advancedsettings.xml file

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.28</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
</advancedsettings>

I have also changed my database engine to innodb as suggested here: http://forum.xbmc.org/showthread.php?tid...pid1472519


The only thing I do notice is that it still says MyISAM on the very last line. I'm not sure if that is right or not?

http://postimg.org/image/n5aif7pa3/


Anybody have any ideas that I can try?

[kpon]

So an update to what i've tried so far.

I deleted my database and have xbmc re-populate it.

I've ran a query on my database for all items (about 0.034s), just to check that its not slow there.

Checked the speed on my nas. For me to download a file is about 58MB/s, to upload is about 24MB/s

menu navigation is still slow.

[kpon]

looks like i fixed my issue with SQL. copied over the my-small.cnf and followed this to make some tweaks. http://www.debianhelp.co.uk/mysqlperformance.htm

[PH-SYM]

Great that you fixed the issue and thanks for the link to those tweaks.
Without that cnf file the sql server probably starts with inefficient settings, at least for XBMC.

[surfinbox]

TYPICALLY for XBMC installs, the single most important MySQL "optimization" is to turn off name resolution, which by default must timeout before query responses are returned unless your internal DNS is structured (which we rarely bother with). Thus, you made many many many changes to optimize MySQL that really only mattered when you made this change from the end of the link above.

Code:

[mysqld]
…..
……
skip-name-resolve

Glad it's working for you