2013-07-01, 19:50
Until yesterday morning, I ran my XBMC database from my Synology NAS. My library has 300 films, about 30 TV shows with about 2000 episodes, so it's sizable, but compared to some I've seen, it's really nothing. Things were moving along with the Synology okay for about a year until I added about 50 new episodes of a show a couple days ago and then XBMC started performing horribly (15-30 second delays after selecting TV Shows or Movies, another long delay after selecting a TV show, another long delay after selecting a season, etc). The XBMC debug log didn't really show anything other than big gaps in time between entries.
After messing around with it for a couple hours, watching the PhpMyAdmin and Synology's performance (CPU and RAM never got above 20% at any time), I decided to install MySQL on another computer I have. Instead of rebuilding all the database schemata and content, I decided I'd see really quick if I had some data corruption and imported both from the Synology into the new MySQL instance. After 30 minutes, that was complete and I repointed my 3 XBMC boxes to the new MySQL instance. Performance has never been better. Navigating around (TV Shows, then a show, then a season, back out to the main menu, into movies, etc) is instantaneous. Even when I thought the Synology solution was good, I notice that the 2-3 second delays are gone. Network wise, there's nothing different. 1 Gbps, same subnet, same switch (the XBMC clients, the Synology and the new MySQL box). Other than MySQL performance, the Synology flies (CIFS, SMB, and NFS are lightning quick).
So I'm keeping the XBMC data on this new MySQL instance for now. I guess my question is, why is this the case? Anyone observe the same?
(I realize this isn't really an XBMC specific issue, but I'm having trouble locating something "official" that says, "Yes, MySQL on Synology is pretty slow." There were a few complaints, but no answers)
After messing around with it for a couple hours, watching the PhpMyAdmin and Synology's performance (CPU and RAM never got above 20% at any time), I decided to install MySQL on another computer I have. Instead of rebuilding all the database schemata and content, I decided I'd see really quick if I had some data corruption and imported both from the Synology into the new MySQL instance. After 30 minutes, that was complete and I repointed my 3 XBMC boxes to the new MySQL instance. Performance has never been better. Navigating around (TV Shows, then a show, then a season, back out to the main menu, into movies, etc) is instantaneous. Even when I thought the Synology solution was good, I notice that the 2-3 second delays are gone. Network wise, there's nothing different. 1 Gbps, same subnet, same switch (the XBMC clients, the Synology and the new MySQL box). Other than MySQL performance, the Synology flies (CIFS, SMB, and NFS are lightning quick).
So I'm keeping the XBMC data on this new MySQL instance for now. I guess my question is, why is this the case? Anyone observe the same?
(I realize this isn't really an XBMC specific issue, but I'm having trouble locating something "official" that says, "Yes, MySQL on Synology is pretty slow." There were a few complaints, but no answers)