2013-10-06, 11:36
I'm trying to move to MySQL to store my XBMC database, but it's running really slowly. Starting a film playing takes around 40 seconds, and adding one seems to take around 30 seconds. I'd wondered whether it was a caching issue, but it still takes the same amount of time, even after starting the the same film around 20 times.
I'm using an IP address not a DNS name, and I've set mysql to skip-name-resolve, but that's made no difference. I've checked that I'm using MySQL 5.5. I've tried searching forums and reading through the logs, but I can't work out what's causing the problem. I'd be very grateful for some help.
Log for adding a film (North by Northwest): http://xbmclogs.com/show.php?id=66598
Log for playing a film (The Big Lebowski): http://xbmclogs.com/show.php?id=66586
I'm using an IP address not a DNS name, and I've set mysql to skip-name-resolve, but that's made no difference. I've checked that I'm using MySQL 5.5. I've tried searching forums and reading through the logs, but I can't work out what's causing the problem. I'd be very grateful for some help.
Log for adding a film (North by Northwest): http://xbmclogs.com/show.php?id=66598
Log for playing a film (The Big Lebowski): http://xbmclogs.com/show.php?id=66586
