2011-06-24, 11:17
Hi guys and gals,
I'm looking for a bit of help figuring out where my speed problem is coming from. I have successfully set up the database and everything is functioning as expected, including thumbnail shares. Apon first load, I have the recently added movies,episodes display and they load up with no hesitation. My issue comes when I click on my movie library. I have aprox 200 movies on my main xbmc player/server windows 7 64 sharing via SMB. when I click on the movies link, it takes aproximately 10 seconds before the thumbnails show up, then another 10 seconds (with the working animation moving for about 6 secs then freeze) before I can move about my library. Once the initial wait is over, the images, fanart ect work like its a local machine, so I assume it is mysql causing the issue. I have troubleshot with firewall disabled on both machines with no change. The only change to the sql ini I made was adding skip_name_resolve which was supposed to help the problem, but no luck. I have also created indexes, per another post to try and help, listed below. I have also attached the pastebin of my current sql ini in hopes that something sticks out. Please give me some idea as to how to make things just work (:
Using the latest stable release, windows 7
The issue is only present on the remote xbmc install. The main unit with sql, thumbs share, and movies/shows have 0 lag when using sql setup.
Home network, I am usually connected via N wireless on remote system, but have tested hardwired as well (100). Main server is hardwired as well(100).
I have looked at the log file but do not see anything that would explain the hit in performance. Thanks for reading!
my.ini
And how about a video showing the delay
EDIT - Hopefully someone can help me sort this out, but I got to thinking. Would it be possible to have a centralized "addons" folder as well. I know it is not that much of a pain, bit it would be neat to set it and forget it. Having the same thing everywhere without having to think would be swell
I'm looking for a bit of help figuring out where my speed problem is coming from. I have successfully set up the database and everything is functioning as expected, including thumbnail shares. Apon first load, I have the recently added movies,episodes display and they load up with no hesitation. My issue comes when I click on my movie library. I have aprox 200 movies on my main xbmc player/server windows 7 64 sharing via SMB. when I click on the movies link, it takes aproximately 10 seconds before the thumbnails show up, then another 10 seconds (with the working animation moving for about 6 secs then freeze) before I can move about my library. Once the initial wait is over, the images, fanart ect work like its a local machine, so I assume it is mysql causing the issue. I have troubleshot with firewall disabled on both machines with no change. The only change to the sql ini I made was adding skip_name_resolve which was supposed to help the problem, but no luck. I have also created indexes, per another post to try and help, listed below. I have also attached the pastebin of my current sql ini in hopes that something sticks out. Please give me some idea as to how to make things just work (:
Using the latest stable release, windows 7
The issue is only present on the remote xbmc install. The main unit with sql, thumbs share, and movies/shows have 0 lag when using sql setup.
Home network, I am usually connected via N wireless on remote system, but have tested hardwired as well (100). Main server is hardwired as well(100).
I have looked at the log file but do not see anything that would explain the hit in performance. Thanks for reading!
Indexes Used Wrote:use xbmc_video;
ALTER TABLE movie ADD INDEX ix_idFile(idFile);
ALTER TABLE movie ADD INDEX idMovie(idMovie);
ALTER TABLE movie ADD INDEX idFile(idFile);
use xbmc_music;
CREATE INDEX test_idx ON song(idAlbum);
alter table song add index idArtist(idArtist);
alter table song add index idGenre(idGenre);
my.ini
And how about a video showing the delay
EDIT - Hopefully someone can help me sort this out, but I got to thinking. Would it be possible to have a centralized "addons" folder as well. I know it is not that much of a pain, bit it would be neat to set it and forget it. Having the same thing everywhere without having to think would be swell