Kodi Community Forum

Full Version: MySQL library is very slow, help to debug
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,

I have mysql and all my video files running on my NAS (QNAP TS-410U).

Everything works, and the library and files are accessed fine from both my Windows comptuers, running 12.2

But everything that concerns library actions are very slow, except just browsing.

Marking episodes/videos as watched, updating the library, etc.

The worst thing is actually after updating the library, I have to wait a few minutes before it starts, and then again a few minutes it's done.
If I play a video file right away after doing an update, I only get sound, but the picture doesn't show up for a few minutes.

What are the best ways to go around isolating where the issue with this slowness is?
Mine is exactly the same, so if there is an answer, then I would love to hear it. I connect from a HTPC and an android client. The MySQL is on a Synology NAS.
I converted all the tables to InnoDB, and that helped a lot.
Followed the steps on this page:

http://www.tweaking4all.com/home-theatre...s-in-sync/
Probably need to edit my.conf see this thread for ideas http://forum.xbmc.org/showthread.php?tid=162603&page=10