Hi Folks, This might be fixed for some folks, but it's still going strong for me (I'm using 7.0.1). I've been battling this issue for a while and finally had some time to search the forums. In my case, the genre with lots of tracks in it is 'Rock'. I have 17,000+ tracks (1500+ albums) in that genre, which is quite a bit more than the 4000+ tracks suggested in the bug. Perhaps that accounts for why I'm still seeing this issue when the 7.0.1 fix has worked for others?
My symptoms are exactly the same. If I select Genres->Rock from the SBC, mysqld will sit on top for about 2 or 3 minutes using 100% of the CPU. Meanwhile, the buffers will underrun in any playing squeezebox or transporter and the controller will lose connection to the server. In contrast, when using the web interface, selecting Genres->Rock takes < 10 seconds. I've captured a slow query log as suggested in the bug. In my case, almost 9 million rows examined in the queries. Ouch. The log follows. Let me know if there's more I can provide. Thanks, John /u1/opt/squeezecenter-7.0.1/Bin/i386-linux/mysqld, Version: 5.0.21-standard-log. started with: Tcp port: 9092 Unix socket: /home/slim/Cache/squeezecenter-mysql.sock Time Id Command Argument # Time: 080703 13:32:45 # [EMAIL PROTECTED]: [slimserver] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 1 Rows_examined: 8949789 use slimserver; SELECT COUNT( DISTINCT( me.id ) ) FROM contributors me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.contributor = me.id ) JOIN tracks track ON ( track.id = contributorTracks.track ) LEFT JOIN genre_track genreTracks ON ( genreTracks.track = track.id ) LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = '0' ) ) AND contributorTracks.role IN ( '1', '5' ) AND genreTracks.genre = '13' ) ) ); # Time: 080703 13:33:42 # [EMAIL PROTECTED]: [slimserver] @ localhost [127.0.0.1] # Query_time: 57 Lock_time: 0 Rows_sent: 198 Rows_examined: 8950353 SELECT me.id, me.name, me.namesort, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.contributor = me.id ) JOIN tracks track ON ( track.id = contributorTracks.track ) LEFT JOIN genre_track genreTracks ON ( genreTracks.track = track.id ) LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = '0' ) ) AND contributorTracks.role IN ( '1', '5' ) AND genreTracks.genre = '13' ) ) ) GROUP BY me.id ORDER BY me.namesort LIMIT 198; # Time: 080703 13:33:53 # [EMAIL PROTECTED]: [slimserver] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 1 Rows_examined: 8949789 SELECT COUNT( DISTINCT( me.id ) ) FROM contributors me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.contributor = me.id ) JOIN tracks track ON ( track.id = contributorTracks.track ) LEFT JOIN genre_track genreTracks ON ( genreTracks.track = track.id ) LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = '0' ) ) AND contributorTracks.role IN ( '1', '5' ) AND genreTracks.genre = '13' ) ) ); # Time: 080703 13:34:51 # [EMAIL PROTECTED]: [slimserver] @ localhost [127.0.0.1] # Query_time: 58 Lock_time: 0 Rows_sent: 198 Rows_examined: 8950353 SELECT me.id, me.name, me.namesort, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.contributor = me.id ) JOIN tracks track ON ( track.id = contributorTracks.track ) LEFT JOIN genre_track genreTracks ON ( genreTracks.track = track.id ) LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = '0' ) ) AND contributorTracks.role IN ( '1', '5' ) AND genreTracks.genre = '13' ) ) ) GROUP BY me.id ORDER BY me.namesort LIMIT 198; -- 2eleven ------------------------------------------------------------------------ 2eleven's Profile: http://forums.slimdevices.com/member.php?userid=4685 View this thread: http://forums.slimdevices.com/showthread.php?t=46850 _______________________________________________ jive mailing list [email protected] http://lists.slimdevices.com/cgi-bin/mailman/listinfo/jive
