2013-11-12, 04:24
Hello all,
I am potentially looking for direction here re: MySQL tweaks ?
My combo of XBMC Frodo clients + MySQL has been working very well for a long time.
Not sure if my current challenge is related to the size of our collection or not.
We use MySQL via a QNAP NAS unit and we do not use the MyMusic32 DB at all despite that it exists.
Our focus is on videos.
The MyVideos75 DB has grown to ~56.7MB (43 tables and 536,185 rows).
Initially I thought our issue was due to our wireless bridge so I ran a CAT6 STP line directly to the OSX XBMC system.
No change.
After watching anything, it takes upwards of 2 to 3 minutes before the video is marked as "watched" with a checkmark.
Meanwhile XBMC is locked in limbo until the checkmark appears.
Annoying to say the least.
I have contemplated moving MySQl to another host but am not convinced that will resolve this challenge.
I have searched and applied various MySQL tweaks but nothing seems to assist.
So ... hence my plea to the XBMC Users Group ... and I say .. WTF !?!
Any and all suggestion appreciated.
I am potentially looking for direction here re: MySQL tweaks ?
My combo of XBMC Frodo clients + MySQL has been working very well for a long time.
Not sure if my current challenge is related to the size of our collection or not.
We use MySQL via a QNAP NAS unit and we do not use the MyMusic32 DB at all despite that it exists.
Our focus is on videos.
The MyVideos75 DB has grown to ~56.7MB (43 tables and 536,185 rows).
Initially I thought our issue was due to our wireless bridge so I ran a CAT6 STP line directly to the OSX XBMC system.
No change.
After watching anything, it takes upwards of 2 to 3 minutes before the video is marked as "watched" with a checkmark.
Meanwhile XBMC is locked in limbo until the checkmark appears.
Annoying to say the least.
I have contemplated moving MySQl to another host but am not convinced that will resolve this challenge.
I have searched and applied various MySQL tweaks but nothing seems to assist.
So ... hence my plea to the XBMC Users Group ... and I say .. WTF !?!
Any and all suggestion appreciated.