This query runs once a minute or so, and, well it sucks, creating huge
temporary tables all for what seems like a worthless statistic:
You might be up to something. I've added your comment to the following bug:
http://bugs.slimdevices.com/show_bug.cgi?id=13199
Please add any more information
SELECT COUNT( * ) FROM (SELECT me.id FROM tracks me WHERE ( me.audio = '1' )
GROUP BY me.id, me.url, me.content_type, me.title, me.titlesort,
me.titlesearch, me.album, me.primary_artist, me.tracknum, me.timestamp,
me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset,
I just posted a bit of a server log to the bug report. It's actually
run twice every minute. Looks like it's one of a series of four queries
being run to get counts of albums, artists, genres and tracks.
--
JJZolx
Jim
Meanwhile I did a clean reinstall and the problem persists. After
reinstalling he scans my music (the wrong path, only 300 files) and
everything's fine. after scanning my real music folder (80.000 files) i
get the error message. What makes me crazy: last week those nightlies
(the last sqlite
I just posted a bit of a server log to the bug report. It's actually
run twice every minute.
Might depend on your computer's performance. Mine wouldn't finish a run in
a minute...
--
Michael
___
beta mailing list
beta@lists.slimdevices.com
I'd say it's not MySQL per se that's too slow (I've seen it handling 1.5
million audio tracks in fractions of a second) but how efficient the SQL
statements are and how much work you give it.
Scanning the exact same library (~28k files) with another application
(SAM Broadcaster 4) that uses a
mherger;445302 Wrote:
Might depend on your computer's performance. Mine wouldn't finish a run
in
a minute...
I tried running it within MySQL Query Analyser, and the first time took
just over 2 seconds, and then subsequent calls were a few milliseconds
(query execution plan cached).
--
I tried running it within MySQL Query Analyser, and the first time took
just over 2 seconds, and then subsequent calls were a few milliseconds
(query execution plan cached).
Heh... I'm running my SC on a 5yrs old Via C3/1GHz :-)
--
Michael
___
Philip Meyer;445332 Wrote:
I tried running it within MySQL Query Analyser, and the first time took
just over 2 seconds, and then subsequent calls were a few milliseconds
(query execution plan cached).
Just to make sure, did you run it towards the bundled MySQL database or
towards a
I've made some progress on the original problem:
If I scroll up and down in the Browse Artist menu on the player, I
can see that all my artists are listed. But for some reason they're in 2
groups:
1 of 3828 10cc
38 of 3828 A.D.A.M
3599 of 3828ZZ Top
3600 of 38285th Order
3602
Erland, someone was me :-) But doing this kind of optimization
produced no noticeable improvement on my Fedora 11/MySQL
5.1.36/SC7.4-28002 installation.
Does the Linux RPM version of SC actually -have- a bundled MySQL? It
has its own system tables, but after a yum update SC showed the same
MySQL
Does the Linux RPM version of SC actually -have- a bundled MySQL?
I thought the bundled versions were always using the system's instance.
--
Michael
___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta
Hi,
could someone please tell me, when developing 8.0 (with SQlite) starts?
I can't use the MySQL-builds so I'm very interested in new SQLite
versions to get my Squeezebox running again.
Thanks
Frank
--
frank1969
erland;445345 Wrote:
Just to make sure, did you run it towards the bundled MySQL database or
towards a standalone MySQL instance ?
If I remember correctly someone got MySQL to perform a lot better if it
was assigned bigger caches than the default settings for the bundled
MySQL version.
could someone please tell me, when developing 8.0 (with SQlite) starts?
It has long ago. The 7.4 nightlies up until last week were all based on
the SQLite branch which will become 8.0
I can't use the MySQL-builds
Why not?
--
Michael
___
beta
The issue with the player panel not recognizing the player (SB3) is
still present in today's 28008 build. I understand that not enough time
has elapsed to address this issue, but it should be prioritized as the
majority of functions that need to be tested in the Web UI using these
new builds
However the path is NOT saved
Are you using the web UI or the control panel to set that value? There was
a major bug in the control panel which caused settings to be lost.
--
Michael
___
beta mailing list
beta@lists.slimdevices.com
However, to get the itunes ratings/playlist etc I was planning to
point, under the itunes tab to:
\\192.168.0.100\Music\itunes\itunes library.xml
However the path is NOT saved
Scratch my previous response... are you running SC as a service on Windows?
--
Michael
I know, therefore I use last weeks nightly from thursday, but it's buggy
so I wait for fixes in 8.0
why not?
7.3.2 stable crashed my database every 2nd or 3rd update-scan, no one
could solve. a rescan takes about 16 to 18 hours, just a matter for the
weekend
7.3.4 mysql-nightlies first didn't
7.3.2 stable crashed my database every 2nd or 3rd update-scan, no one
could solve. a rescan takes about 16 to 18 hours, just a matter for the
weekend
7.3.4 mysql-nightlies first didn't start SC, then they crashed my
windows (can't find user profile while starting - de-installing 7.3.4
mysql
sjchmura;445275 Wrote:
Running WHS version 29990 Aug 1, 2009 10:20am
EX485
All music is in D:\shares\Music
However, to get the itunes ratings/playlist etc I was planning to
point, under the itunes tab to:
\\192.168.0.100\Music\itunes\itunes library.xml
However the path is NOT saved
tamanaco;445368 Wrote:
Btw, is there any way to suppress the deprecated plugin function
messages in the sever log. I setup my logging options to show error
messages only, but this error message appears to be targeted to
developers only. I'm probably wrong, but some of the plugins continue to
mherger;445433 Wrote:
Did you contact support? Sounds like odd issues, never heard of the
last one...
No - do they support beta software/nightlys?
--
frank1969
frank1969's Profile:
Meanwhile I tried the last two SQLite-Version as well as the new
nightly
Version: 7.4 - r28008 @ Mon Aug 3 04:02:28
after a clean re-install.
The problem is the same so I think it should be a bug.
I can browse by albums - but I CANNOT browse by songs
No matter where, wherever I click on an
I've just installed/upgraded to 7.4 - r28008 and my iTunes import is
terminating unexpectedly. I've tried the various rescan options (and
the clean cache folder option) but it keeps terminating. The scanner
log has:
[09-08-03 22:30:18.3886] Slim::Music::Import::endImporter (674)
Completed
That error should now be fixed, thanks.
--
andyg
andyg's Profile: http://forums.slimdevices.com/member.php?userid=3292
View this thread: http://forums.slimdevices.com/showthread.php?t=66296
Cool, thanks. Will confirm back.
--
fozzie
fozzie's Profile: http://forums.slimdevices.com/member.php?userid=1737
View this thread: http://forums.slimdevices.com/showthread.php?t=66296
Just downloaded the latest Windows 7.4 version, and it doesn't work at
all. It installs fine, but the web page for the server takes 10 minutes
to load or perform any action, and when it finally loads none of my
players show up. None of my players can connect to my library either,
or to internet
Same with me, I described the problem in this thread
= http://forums.slimdevices.com/showthread.php?t=66292
but without answer till now.
What I recognized today:
Using the Control Panel it shows No connection to port 9000.
Beneath is a list:
The following applications are using port 9000:
But
29 matches
Mail list logo