Nilsen Posted October 17, 2014 Share Posted October 17, 2014 I used to have mysql running with a shared XBMC library on my unraid server. I recently did a clean unraid install to version 5.0.5. I'm in the progress of adding the plugins I've been used to having. The problem I'm having with mysql is that XBMC is slow as syrup after I add the advancedsettings.xml file. I'm using a new install of XBMC Gotham on a Windows 7 PC The only plugins running on the unraid server is sabnzbd and nzbdrone. What I've done is installed mysql on the cache disk, created user xbmc with pass: xbmc, and granted all privileges to the user. This is the advancedsettings.xml file I've placed in %APPDATA%\XBMC\userdata : <advancedsettings> <videodatabase> <type>mysql</type> <host>192.168.0.100</host> <port>3306</port> <user>xbmc</user> <pass>xbmc</pass> </videodatabase> <musicdatabase> <type>mysql</type> <host>192.168.0.100</host> <port>3306</port> <user>xbmc</user> <pass>xbmc</pass> </musicdatabase> <videolibrary> <importwatchedstate>true</importwatchedstate> <dateadded>0</dateadded> </videolibrary> </advancedsettings> When I start XBMC now for the first time after adding the advancedsettings.xml it will take several minutes to start up. This is the log: 19:35:43 T:2836 NOTICE: Checking resolution 16 19:35:44 T:2836 NOTICE: No Joystick name specified, loading default map 19:35:44 T:2836 NOTICE: Previous line repeats 35 times. 19:35:44 T:2836 NOTICE: Running database version Addons16 19:35:44 T:2836 NOTICE: Running database version ViewModes6 19:35:44 T:2836 NOTICE: Running database version Textures13 19:35:54 T:2836 ERROR: Unable to open database: MyMusic46 [1049](Unknown database 'MyMusic46') 19:36:04 T:2836 ERROR: Unable to open database: MyMusic45 [1049](Unknown database 'MyMusic45') 19:36:14 T:2836 ERROR: Unable to open database: MyMusic44 [1049](Unknown database 'MyMusic44') 19:36:24 T:2836 ERROR: Unable to open database: MyMusic43 [1049](Unknown database 'MyMusic43') 19:36:34 T:2836 ERROR: Unable to open database: MyMusic42 [1049](Unknown database 'MyMusic42') 19:36:44 T:2836 ERROR: Unable to open database: MyMusic41 [1049](Unknown database 'MyMusic41') 19:36:54 T:2836 ERROR: Unable to open database: MyMusic40 [1049](Unknown database 'MyMusic40') 19:37:04 T:2836 ERROR: Unable to open database: MyMusic39 [1049](Unknown database 'MyMusic39') 19:37:14 T:2836 ERROR: Unable to open database: MyMusic38 [1049](Unknown database 'MyMusic38') 19:37:24 T:2836 ERROR: Unable to open database: MyMusic37 [1049](Unknown database 'MyMusic37') 19:37:34 T:2836 ERROR: Unable to open database: MyMusic36 [1049](Unknown database 'MyMusic36') 19:37:44 T:2836 ERROR: Unable to open database: MyMusic35 [1049](Unknown database 'MyMusic35') 19:37:54 T:2836 ERROR: Unable to open database: MyMusic34 [1049](Unknown database 'MyMusic34') 19:38:04 T:2836 ERROR: Unable to open database: MyMusic33 [1049](Unknown database 'MyMusic33') 19:38:14 T:2836 ERROR: Unable to open database: MyMusic32 [1049](Unknown database 'MyMusic32') 19:38:24 T:2836 ERROR: Unable to open database: MyMusic31 [1049](Unknown database 'MyMusic31') 19:38:34 T:2836 ERROR: Unable to open database: MyMusic30 [1049](Unknown database 'MyMusic30') 19:38:44 T:2836 ERROR: Unable to open database: MyMusic29 [1049](Unknown database 'MyMusic29') 19:38:54 T:2836 ERROR: Unable to open database: MyMusic28 [1049](Unknown database 'MyMusic28') 19:39:04 T:2836 ERROR: Unable to open database: MyMusic27 [1049](Unknown database 'MyMusic27') 19:39:14 T:2836 ERROR: Unable to open database: MyMusic26 [1049](Unknown database 'MyMusic26') 19:39:24 T:2836 ERROR: Unable to open database: MyMusic25 [1049](Unknown database 'MyMusic25') 19:39:34 T:2836 ERROR: Unable to open database: MyMusic24 [1049](Unknown database 'MyMusic24') 19:39:44 T:2836 ERROR: Unable to open database: MyMusic23 [1049](Unknown database 'MyMusic23') 19:39:54 T:2836 ERROR: Unable to open database: MyMusic22 [1049](Unknown database 'MyMusic22') 19:40:04 T:2836 ERROR: Unable to open database: MyMusic21 [1049](Unknown database 'MyMusic21') 19:40:14 T:2836 ERROR: Unable to open database: MyMusic20 [1049](Unknown database 'MyMusic20') 19:40:24 T:2836 ERROR: Unable to open database: MyMusic19 [1049](Unknown database 'MyMusic19') 19:40:34 T:2836 ERROR: Unable to open database: MyMusic18 [1049](Unknown database 'MyMusic18') 19:41:01 T:2836 ERROR: Unable to open database: MyVideos78 [1049](Unknown database 'MyVideos78') 19:41:11 T:2836 ERROR: Unable to open database: MyVideos77 [1049](Unknown database 'MyVideos77') 19:41:21 T:2836 ERROR: Unable to open database: MyVideos76 [1049](Unknown database 'MyVideos76') 19:41:31 T:2836 ERROR: Unable to open database: MyVideos75 [1049](Unknown database 'MyVideos75') 19:41:41 T:2836 ERROR: Unable to open database: MyVideos74 [1049](Unknown database 'MyVideos74') 19:41:51 T:2836 ERROR: Unable to open database: MyVideos73 [1049](Unknown database 'MyVideos73') 19:42:01 T:2836 ERROR: Unable to open database: MyVideos72 [1049](Unknown database 'MyVideos72') 19:42:11 T:2836 ERROR: Unable to open database: MyVideos71 [1049](Unknown database 'MyVideos71') 19:42:21 T:2836 ERROR: Unable to open database: MyVideos70 [1049](Unknown database 'MyVideos70') 19:42:31 T:2836 ERROR: Unable to open database: MyVideos69 [1049](Unknown database 'MyVideos69') 19:42:41 T:2836 ERROR: Unable to open database: MyVideos68 [1049](Unknown database 'MyVideos68') 19:42:51 T:2836 ERROR: Unable to open database: MyVideos67 [1049](Unknown database 'MyVideos67') 19:43:01 T:2836 ERROR: Unable to open database: MyVideos66 [1049](Unknown database 'MyVideos66') 19:43:11 T:2836 ERROR: Unable to open database: MyVideos65 [1049](Unknown database 'MyVideos65') 19:43:21 T:2836 ERROR: Unable to open database: MyVideos64 [1049](Unknown database 'MyVideos64') 19:43:31 T:2836 ERROR: Unable to open database: MyVideos63 [1049](Unknown database 'MyVideos63') 19:43:41 T:2836 ERROR: Unable to open database: MyVideos62 [1049](Unknown database 'MyVideos62') 19:43:51 T:2836 ERROR: Unable to open database: MyVideos61 [1049](Unknown database 'MyVideos61') 19:44:01 T:2836 ERROR: Unable to open database: MyVideos60 [1049](Unknown database 'MyVideos60') 19:44:28 T:2836 NOTICE: Running database version TV22 19:44:28 T:2836 NOTICE: Running database version Epg7 19:44:28 T:2836 WARNING: JSONRPC: Could not parse type "GUI.Property.Value" 19:44:28 T:2836 WARNING: JSONRPC: Could not parse type "Setting.Details.SettingList" 19:44:28 T:2836 NOTICE: initialize done 19:44:28 T:3764 NOTICE: Thread LanguageInvoker start, auto delete: false 19:44:28 T:2836 NOTICE: Running the application... 19:44:28 T:3764 NOTICE: -->Python Interpreter Initialized<-- 19:44:28 T:4328 NOTICE: Thread JobWorker start, auto delete: true 19:44:38 T:2836 NOTICE: ES: Starting event server 19:44:38 T:3560 NOTICE: Thread EventServer start, auto delete: false 19:44:38 T:3560 NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777 19:44:38 T:3560 NOTICE: UDP: Listening on port 9777 19:44:38 T:2936 NOTICE: Thread TCPServer start, auto delete: false 19:44:38 T:1040 NOTICE: Thread AlarmClock start, auto delete: false 19:44:38 T:3844 NOTICE: Thread RSSReader start, auto delete: false 19:45:08 T:3724 NOTICE: Thread LanguageInvoker start, auto delete: false 19:45:08 T:3724 NOTICE: -->Python Interpreter Initialized<-- After it finally starts up I can see that XBMC has created MyMusic46 and MyVideos78 databases. This is the log after closing XBMC and starting it again: 20:12:33 T:112 NOTICE: Checking resolution 16 20:12:34 T:112 NOTICE: No Joystick name specified, loading default map 20:12:34 T:112 NOTICE: Previous line repeats 35 times. 20:12:34 T:112 NOTICE: Running database version Addons16 20:12:34 T:112 NOTICE: Running database version ViewModes6 20:12:34 T:112 NOTICE: Running database version Textures13 20:12:44 T:112 NOTICE: Running database version MyMusic46 20:12:54 T:112 NOTICE: Running database version MyVideos78 20:12:54 T:112 NOTICE: Running database version TV22 20:12:54 T:112 NOTICE: Running database version Epg7 20:12:54 T:112 WARNING: JSONRPC: Could not parse type "GUI.Property.Value" 20:12:54 T:112 WARNING: JSONRPC: Could not parse type "Setting.Details.SettingList" 20:12:54 T:112 NOTICE: initialize done 20:12:54 T:4908 NOTICE: Thread LanguageInvoker start, auto delete: false 20:12:54 T:4908 NOTICE: -->Python Interpreter Initialized<-- 20:12:54 T:112 NOTICE: Running the application... 20:13:24 T:2276 NOTICE: Thread JobWorker start, auto delete: true 20:13:44 T:112 NOTICE: ES: Starting event server 20:13:44 T:4732 NOTICE: Thread EventServer start, auto delete: false 20:13:44 T:4732 NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777 20:13:44 T:4732 NOTICE: UDP: Listening on port 9777 20:13:44 T:2396 NOTICE: Thread TCPServer start, auto delete: false 20:13:44 T:4652 NOTICE: Thread AlarmClock start, auto delete: false 20:13:44 T:2568 NOTICE: Thread RSSReader start, auto delete: false It still takes a long time to start up now as you can see. And doing anything inside XBMC takes a really long time, like trying to add a source. I've also added "skip-name-resolve" to the my.cnf file without it doing much difference at all. I've tried earlier versions of XBMC with the same results too. I'm out of ideas, hope someone can help me. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.