Triode Wrote: > I see you have sql debugging on to - could you turn this off?
I don't have SQL logging turned on, but maybe I've been confusing things by posting the output of /tmp/slimserver.log. I assumed this was the same as the output given in http://musicserver:9000/log.txt, but I now see that the web log doesn't show any SQL. I will use that log from now on (where is it held in the filesystem?). > Do you get the same figure every time for this, or is it dependant on > disk spin ups etc? I think the times vary quite a bit. If I retry an operation it is normaly much better (and may not freeze at all). I always assumed this was due to MySQL caching the relevant rows/tables. I'm afraid I don't know if disk spin up times are affecting this. My server is nowhere near the client, and even then, the power supply in the server (soon to be replaced) is so loud I can't really guage what the disk is doing. I wouldn't have thought I'd given the disk time to spin down, but can't say for sure. Unfortunately all the Alien BBC streaming stations (except Virgin) seem to be broken in the latest 6.5 build (discussed in another posting), so this has significantly limited the testing I can now do. As Virgin still works, I've done another test with that. Interestingly I just managed to get an "All Songs" list without a freeze. As this is just streaming MP3, maybe it is a little more tolerant (though I have previously had problems with Virgin). Here's the log: Code: -------------------- 2006-07-02 12:27:05.7854 string: Undefined string: 2006-07-02 12:27:05.7860 string: Requested language: EN - failsafe language: EN 2006-07-02 12:27:07.4219 Web Page Build > 0.5 : 2.98616003990173 2006-07-02 12:27:07.4234 Generating page for browsedb.html 2006-07-02 12:27:07.4327 Select Task > 0.5 : 3.14266800880432 2006-07-02 12:27:07.4352 Slim::Web::HTTP::processHTTP 2006-07-02 12:27:14.8023 Response Time > 0.5 : 2.25810503959656 2006-07-02 12:27:15.1372 Timer Late > 0.5 : 2.27033400535583 2006-07-02 12:27:15.4319 Timer Late > 0.5 : 2.02666091918945 2006-07-02 12:27:23.2871 Timer Late > 0.5 : 7.14820408821106 2006-07-02 12:27:23.2924 Timer Late > 0.5 : 6.88713788986206 2006-07-02 12:27:23.2999 Timer Late > 0.5 : 5.37283086776733 2006-07-02 12:27:23.6917 Select Task > 0.5 : 0.544349908828735 2006-07-02 12:27:23.6930 Slim::Web::HTTP::processHTTP 2006-07-02 12:27:24.0004 Response Time > 0.5 : 0.700595855712891 2006-07-02 12:27:24.0376 Timer Late > 0.5 : 0.632393836975098 2006-07-02 12:27:24.9331 Timer Late > 0.5 : 0.527911901473999 2006-07-02 12:27:34.5642 Timer Late > 0.5 : 7.15897083282471 2006-07-02 12:27:34.8987 Timer Late > 0.5 : 7.1380660533905 2006-07-02 12:27:45.4038 Timer Late > 0.5 : 7.10718083381653 2006-07-02 12:27:45.7007 Timer Late > 0.5 : 7.2954478263855 2006-07-02 12:27:54.6794 Response Time > 0.5 : 1.80719113349915 2006-07-02 12:27:55.5424 Response Time > 0.5 : 0.860433101654053 2006-07-02 12:27:55.5490 Timer Late > 0.5 : 7.143718957901 2006-07-02 12:27:55.5574 Timer Late > 0.5 : 6.45143985748291 2006-07-02 12:28:24.1011 Web Page Build > 0.5 : 71.555743932724 2006-07-02 12:28:24.1026 Generating page for browsedb.html 2006-07-02 12:28:24.1342 Select Task > 0.5 : 71.7365140914917 2006-07-02 12:28:24.1412 Slim::Web::HTTP::processHTTP 2006-07-02 12:28:24.8019 Select Task > 0.5 : 0.52831506729126 2006-07-02 12:28:24.8033 Slim::Web::HTTP::processHTTP -------------------- Those last lines keep appearing whatever I do. Triode Wrote: > Also which version of 6.5 and what is the size of of the library? Since this thread started I've moved from 6.2.2 through to (via a complete server rebuild) 6.5 from 29/06, and now I'm on the very latest build (6.5b1 - 8242) at the time of typing this. My library is 535 albums with 6451 songs by 232 artists (currently no playlists). Thanks again for your help, Richard -- SadGamerGeek ------------------------------------------------------------------------ SadGamerGeek's Profile: http://forums.slimdevices.com/member.php?userid=6145 View this thread: http://forums.slimdevices.com/showthread.php?t=24990 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
