Is it just me or has the option to enable 1GB+ memory tuning for MySQL
disappeared from the final 7.5.2 release (using the debian version from
repository). I have checket my.tt and there seems to be no tuning there
either indicating some kind of auto-tuning.
--
marsboer
marsboer;596270 Wrote:
Is it just me or has the option to enable 1GB+ memory tuning for MySQL
disappeared from the final 7.5.2 release (using the debian version from
repository)?
The tuning is also not present in my.tt as it was in the betas.
No, it's not you. It's a pretty screwed up
marsboer;596270 Wrote:
Is it just me or has the option to enable 1GB+ memory tuning for MySQL
disappeared from the final 7.5.2 release (using the debian version from
repository)?
The tuning is also not present in my.tt as it was in the betas.
ANDYG, is this true? has anyone checked the
ANDYG, is this true? has anyone checked the 7.5.3 beta to see if its
in that?
Yes, that's true. If you read the announcement then you'll see that the
released 7.5.2 was basically a firmware release only. Don't panic: if
you've been using 7.5.2 before, you should upgrade to the 7.5.3
Scans had grown to 9 hours and it was now taking more than 50 seconds
for new items added to a playlist to appear in my own server system!
Thanks to new parameters, scanning is back to 2 hours (42000 tracks)
and basic operations are now typically back to 1s.
Using HP MediaSmart (old gen) that
After doing some reading on MySQL performance tuning, it looks like
innodb_buffer_pool_size, if memory permits, should be set to 110% of
the database size.
If you have a MySQL user setup you can use a SQL query to get the size
of the DB. Otherwise, just look at the size of the ibdata file. In
Hello,
I have been reading this thread and this evening I did the following on
my Debian server. This completely killed the Squeezebox Server:
Stopped SqueezeboxServer + MySQL
Deleted both:
/etc/mysql/my.cnf
/var/lib/squeezeboxserver/cache/my.cnf
Edited:
Hello,
I have been reading this thread and this evening I did the following on
my Debian server. This completely killed the Squeezebox Server:
Stopped SqueezeboxServer + MySQL
Deleted both:
/etc/mysql/my.cnf
/var/lib/squeezeboxserver/cache/my.cnf
Edited:
lloyd,
the option is now a built in setting in 7.5.2beta settings. very
stable, i recommend using that.
--
MrSinatra
www.lion-radio.org
using:
sb2 sbc (my home) / sbrec ipeng (parents' home) - sbs 7.5.2b - win
xp pro sp3 ie8 - p4(ht) 3.2ghz, 2gig ram - 1tb wd usb2 raid1 - d-link
dir-655 -
Right now my system is completely trashed.
I have had to remove/purge squeezeboxserver.
--
DLloyd
DLloyd's Profile: http://forums.slimdevices.com/member.php?userid=9063
View this thread:
Apologies for the delayed reply
I have a 1GB RAM ReadyNAS NV+ with the following library stats :-
Total Tracks: 22,261
Total Albums: 2,116
Total Artists: 3,373
Total Genres: 29
Total Playing Time: 1751:33:33
Music Scan Details
Directory Scan (22268 of 22268) Complete 02:38:01
Any experiences with using these newly added options ?
Recommended settings ?
--
rolski
rolski's Profile: http://forums.slimdevices.com/member.php?userid=23776
View this thread:
what do you mean?
i just enable it via the webui settingsadvanced page.
i think it works great as is, but it prob could use more than just
on/off, (to be even better).
its in 7.5.2b and 7.6b
--
MrSinatra
www.lion-radio.org
using:
sb2 sbc (my home) / sbrec ipeng (parent's home) - sbs
Done, it's in 7.5 in r31367.
--
andyg
andyg's Profile: http://forums.slimdevices.com/member.php?userid=3292
View this thread: http://forums.slimdevices.com/showthread.php?t=70371
sorry to bug you Andy, but whats the word?
--
MrSinatra
www.lion-radio.org
using:
sb2 sbc (my home) / sbrec ipeng (parent's home) - sbs 7.5.2b - win
xp pro sp3 ie8 - p4(ht) 3.2ghz, 2gig ram - 1tb wd usb2 raid1 - d-link
dir-655 - 43k+ mp3
Sorry haven't got around to it yet, will do it tomorrow.
--
andyg
andyg's Profile: http://forums.slimdevices.com/member.php?userid=3292
View this thread: http://forums.slimdevices.com/showthread.php?t=70371
andyg;577959 Wrote:
Sorry haven't got around to it yet, will do it tomorrow.
thx, u rock! so tomorrow's nightly then... looking forward to it.
--
MrSinatra
www.lion-radio.org
using:
sb2 sbc (my home) / sbrec ipeng (parent's home) - sbs 7.5.2b - win
xp pro sp3 ie8 - p4(ht) 3.2ghz, 2gig
andyg;573093 Wrote:
OK it's pretty self-contained so I can backport it to 7.5.
Andy,
just installed 7.5.2 to my Dad's system, but i don't see it... is it
there yet? if yes, where? can it be in tonights nightly if not?
thx.
--
MrSinatra
www.lion-radio.org
using:
sb2 sbc (my home) /
andyg;570884 Wrote:
KISS is right. I've just added an option to the Performance settings
page called Database Memory Config. Currently this only works for
MySQL and uses Moonbase's config which is listed below. I expect in
the future we can also include some SQLite settings when this
I've updated my-highmem.tt with these newer values.
--
andyg
andyg's Profile: http://forums.slimdevices.com/member.php?userid=3292
View this thread: http://forums.slimdevices.com/showthread.php?t=70371
Before:
Directory Scan (78706 of 78706) Complete 02:02:54
Playlist Scan (5882 of 5882) Complete 00:08:48
Merge Various Artists (9901 of 9901) Complete 00:05:37
Artwork Scan (10249 of 10249) Complete 01:18:49
Total Time: 03:36:08 (Saturday, August 28, 2010 / 6:06 PM)
but what about webui? does the interface seem snappier?
ANDYG,
can/will you backport this to 7.5.2?
i think it makes a lot of sense to get this mod into what looks to be
the last mysql only SBS. thx!
--
MrSinatra
www.lion-radio.org
using:
sb2 sbc (my home) / sbrec ipeng (parent's home)
thx andy! i'll look for it this week.
--
MrSinatra
www.lion-radio.org
using:
sb2 sbc (my home) / sbrec ipeng (parent's home) - sbs 7.5.2b - win
xp pro sp3 ie8 - p4(ht) 3.2ghz, 2gig ram - 1tb wd usb2 raid1 - d-link
dir-655 - 43k+ mp3
Thanks Moonbase for this thread.
For folks with a relatively powerful Squeezebox Server system and **RAM
to burn** :-), I've attached my settings for my.tt. For those running
into trouble, rebooting and doing a Clear library and rescan
everything will avoid database issues.
On my system (4G
KISS is right. I've just added an option to the Performance settings
page called Database Memory Config. Currently this only works for
MySQL and uses Moonbase's config which is listed below. I expect in
the future we can also include some SQLite settings when this option is
enabled, once we
I also added the following pragmas for SQLite when highmem mode is
enabled:
Code:
PRAGMA cache_size = 2;
PRAGMA temp_store = MEMORY;
This should let the database use up to 20MB for page cache and store
temporary files in memory (used
wow, this is awesome...
what would be killer, would be for someone (not necessarily AndyG) to
explain in remarks in the code, what each line is for and some advice
on what ranges to use given what hardware one has.
i agree with the KISS thing too, but eventually it would be good to
have
This is awesome ! thankyou :)
Btw the differing level would not only match hardware but ones needs .
Me, I want to flat out use my whole little server for sbs ! an easy
case.
But it can easily be so that people with powerful machines but not that
much focus on sbs want's to run other
EVERYONE,
AndyG is willing to make a pref for this, see here:
http://bugs.slimdevices.com/show_bug.cgi?id=14921
however, i don't know how to answer his question... i wish moonbase
was still around. we need a DB settings expert to submit to AndyG in
that bug exactly what would be best, and
I am not the database expert you're looking for, but I suggest applying
the KISS principle. There's one set of values (from Moonbase) that has
been tested by members of this forum for almost a year now, and we've
had overwhelmingly positive reports. I don't suggest making new sets of
values, that
I applied the settings on my NAS but I didn't notice any obvious WebUI
or scanner speedups. OTOH Controller operation has sped up
dramatically, instead of 5-10 sec delays the Controller now displays
lists nearly instantly (1 sec) when searching for music. Quite a
significant improvement in
turls;552454 Wrote:
Are the tweaks in here still valid?
Yes.
These are tweaks to improve the performance of MySQL in the special
case of having a database small enough to fit into memory (MySQL is
normally used with databases that do -not- fit). Further, the default
settings that SqueezeServer
It seems surprising that this thread has not been posted to since
January. Are the tweaks in here still valid? I voided my HP WHS
warranty to beef it up with a faster proc and more memory and SB is
still slow. I guess I won't hurt anything trying these tweaks, but
there are only a couple of
the tweaks are for MySQL users. SBS seems to be going to a SQLite by
default setup, and so you can't do the tweaks with that. If you do use
MySQL for your install, i have not seen the tweaks hurt anyone, while
they do seem to help a lot of people.
--
MrSinatra
www.lion-radio.org
using:
sb2
Sorry, I lost my before log, but it was a total of 8 minutes and 20
seconds.
The following is my new timing:
Code:
Library Statistics
Total Tracks: 7,084
Total Albums: 500
Total Artists: 491
Total Genres: 55
Total Playing Time: 552:49:02
Music Scan
So I ran some timings and I was quite surprised:
Standard my.tt
Directory Scan (19021 of 19021) Complete 00:51:48
Playlist Scan (10 of 10) Complete 00:00:05
Merge Various Artists (1870 of 1870) Complete 00:01:31
Artwork Scan (1966 of 1966) Complete 00:37:08
Total
if i might be so bold, perhaps you didn't delete the cached my.tt each
time with a stopped SBS?
somehow i doubt it made no difference. almost everyone has reported
faster scanning or faster UI, or normally both. i also doubt the
dramatic difference you noted in the UI in your first post was
I changed the mytt. Sorry, I didn't bother to log scan times: they
don't usually bother me since I do them at night or when I'm not using
the SB. I'll try to note them at some stage but not just now.
But the change in the Web UI was really noticeable. I was so pleased I
pushed the
My results (SheevaPlug, ARM, 1.2 GHz, 512 MB RAM, Ge network) -
Squeezebox Server Status
Version: 7.4.1 - r28947 @ Tue Oct 20 08:02:44 PDT 2009
Hostname: debian
Server IP Address: 127.0.0.1
Server HTTP Port Number: 9000
Operating system: Debian - EN - iso-8859-1
Platform Architecture:
mherger;484651 Wrote:
I haven't seen many Linux systems so far. Is this more important on
Windows I wonder?
I think, to see the difference of a larger innodb_buffer_pool_size in
Linux, you also need to set
innodb_flush_method=O_DIRECT
otherwise you're still double-buffering in the OS and
My results
System - WHS (Windows Server 2003), 1GB RAM, Dual Core Pentium (E2180)
@2Ghz
Version: 7.4.1 - r28947 @ Tue Oct 20 08:13:15 PDT 2009
Hostname: home-server
Server IP Address: 192.168.0.100
Server HTTP Port Number: 9000
Operating system: Windows Home Server - EN - cp1252
Platform
MrSinatra;486218 Wrote:
it was dramatic for me. how many files do you guys have? i think the
effect is linear based on the more you have, the more potent the effect.
That would be straightforward to test. Divide your library up into
increasingly large subsets, whether through temporarily
aubuti;485837 Wrote:
After trying it out some more I'd say the mysql tweak may speed up the
web ui a little bit on my system, but it's hard to say for sure.
Certainly nothing that I would describe as obvious or dramatic.
Same here. It's maybe a bit quicker but I didn't consider it slow in
it was dramatic for me. how many files do you guys have? i think the
effect is linear based on the more you have, the more potent the effect.
--
MrSinatra
www.lion-radio.org
using:
sb2 sbc (my home) / sbr (parent's home) - sbs 7.4.2b - win xp pro sp3
ie8 - p4(ht) 3.2ghz / 2gig ram - 1tb wd
MrSinatra;486218 Wrote:
it was dramatic for me. how many files do you guys have? i think the
effect is linear based on the more you have, the more potent the effect.
Around 22k.
--
radish
'HELP ME RAISE MONEY FOR CHILDREN'S CANCER RESEARCH!'
(HTTP://WWW.ADAMREEVE.COM/24IN24/)
MrSinatra;485009 Wrote:
some people have talked about doing searches or drilling down to artists
or songs via different nav paths.
but if you mean a true benchmark, no. most people mentioning this hav
simply said they have seen an obvious, for the better, improvement.
i know in my
guys, remember, scan times is just HALF the tweak. the other half is a
dramatic increase in UI responsiveness.
also, we need prob 30 votes for this to get implemented officially, so
everyone PLEASE VOTE!
https://bugs.slimdevices.com/show_bug.cgi?id=14921
--
MrSinatra
www.lion-radio.org
some people have talked about doing searches or drilling down to artists
or songs via different nav paths.
but if you mean a true benchmark, no. most people mentioning this hav
simply said they have seen an obvious, for the better, improvement.
i know in my usage, album art in the webui loads
mherger;484897 Wrote:
Ok, here go my numbers (this is a Via C3/1GHz, 1GB RAM box):
Before (SBS MySQL):
After (using system's MySQL):
Michael,
i don't do linux, but i'm confused... you have two mysql's? and did
you apply the moonbase file to the second one only?
i think your tests
MrSinatra;484935 Wrote:
guys, remember, scan times is just HALF the tweak. the other half is a
dramatic increase in UI responsiveness.
I admit I haven't done much systematic comparison of ui responsiveness,
but the little I have done certainly didn't show dramatic differences.
Maybe I'll do
i don't do linux, but i'm confused... you have two mysql's? and did
Yes. Only the packages use the system's mysqld by default. As I'm running from
trunk (svn checkout) I was too lazy configuring this before. I didn't care
about the additional memory load.
you apply the moonbase file to the
Here are results on my massive library:
PC Spec:
Windows XP SP3
Pentium 4 - 3.0 Ghz
2.5 GB Ram
Most music on 2 external 1TB USB Western Digital Drives, some on
internal 750 GB IDE drive.
Library size: 2.2 Terabytes, about 75% FLAC, the rest in MP3
Squeezebox Server Status
Version: 7.4.2 -
this is great, but we need MORE results and MORE votes!!!
vote for the bug!!!
https://bugs.slimdevices.com/show_bug.cgi?id=14921
i'm surprised some of the old guard here hasn't posted their results
yet. (even just an idea of how much improved, if you don't have pre
tweak stats)
--
this is great, but we need MORE results and MORE votes!!!
I eventually gave this a try, tweaking both the mysqld instance shipped with
SBS as well as my system's configuration. None made a notable difference (1-2%
at max). I haven't seen many Linux systems so far. Is this more important on
this is great, but we need MORE results and MORE votes!!!
I eventually gave this a try, tweaking both the mysqld instance shipped
with SBS as well as my system's configuration. None made a notable
difference (1-2% at max). I haven't seen many Linux systems so far. Is
this more important on
sheevaplug is linux right? made a big difference on that. in moonbases
orig thread another linux user had a HUGE benefit, 4hr to 2.5 r u sure
you implemented the tweak in the right place? linux seems to be more
variable as to where the file should go. and how many files, etc?
--
MrSinatra
I have lived with a modded my.tt (see my posts earlier in this thread)
with set innodb_buffer_pool_size set to 500m for two weeks, monitoring
the memory usage via Windows Task Manager.
Unless I have performed a Clear Rescan, mysqld.exe does not use more
than about 125M. Lazy searches are extra
As promised, here are my results. Not a huge improvement in actual time,
but it works out to around 10% which isn't terrible. This is on my
production server which is an AthlonXP/2G RAM.
Version: 7.4.2 - r29220 @ Tue Nov 10 04:01:26 PST 2009
Hostname: gary
Server IP Address: 192.168.2.163
Server
Ok, here go my numbers (this is a Via C3/1GHz, 1GB RAM box):
Version: 7.5.0 - rTRUNK @ UNKNOWN
BS: Red Hat - DE - utf8
Plattform: i686-linux
Perl-Version: 5.10.0 - i386-linux-thread-multi
MySQL-Version: 4.1.22
Before (SBS MySQL):
Durchsuche Musik-Verzeichnis (15435 von 15435) Beendet
My system is an Atom single-core 1.6MHz (Intel 945GC) with 2GB RAM,
although only 1.6GB is available because 0.4GB is allocated to a virtual
machine, which was suspended while running these tests. The OS is Ubuntu
8.10 Desktop, and running SBS is about all the machine does.
The directory scan
Summary:
Overall scan time decreased by around 11% (from 46 mins to 41 mins)
Note: Playlist scan time increased by a couple of seconds due to
addition of new playlist between scans
PC Spec:
7.4.1 on XP Pro
2.5ghz. AMD Athlon Dual Core 4850e
3gb Ram
1tb Internal SataII music disk
Total Tracks:
More experimantation, different server Q9450, music on 5400rpm WD Green
Power 1Tb and Samsung 1.5Tb EcoGreen HD154UI, 4GbRAM. XP Pro SP3
Version: 7.3.4 - 28402 @ Sun Sep 13 03:01:44 PDT 2009
Standard my.tt
Directory Scan (97147 of 97147) Complete 01:12:22
MusicIP Import (97146 of
Standard my.tt , system is XP SP3, Q9300, 4Gb RAM, music on 1Tb WD Green
Power and 1.5Tb Samsung EcoGreen 154UI, both low performance 5400rpm
disks.
Version: 7.3.4 - 28402 @ Sun Sep 13 03:01:44 PDT 2009
Operating system: Windows XP - EN - cp1252
Platform Architecture: 586
Perl Version: 5.8.8 -
erland, other guys, did you do the tweak? post the results! everyone
so far has gotten some kind of boost from it...
--
MrSinatra
www.lion-radio.org
using:
sb2 sbc (my home) / sbr (parent's home) - sbs 7.4.2b - win xp pro sp3
ie8 - p4(ht) 3.2ghz / 2gig ram - 1tb wd usb2 raid1 - d-link
I'll do it tonight if I get a chance.
--
radish
'HELP ME RAISE MONEY FOR CHILDREN'S CANCER RESEARCH!'
(HTTP://WWW.ADAMREEVE.COM/24IN24/)
http://www.last.fm/user/polymeric
radish's Profile:
I ran this on my 2Ghz (celeron) Win XP box, 512MB RAM, music collection
on an external USB2 drive. (Yes, I know I'm a little light on RAM, but
hopefully this helps you plumb the lower end.)
Before optimization:
Total Tracks: 23,880
Total Albums: 4,322
Total Artists: 2,164
Total Genres: 174
mherger;478121 Wrote:
On Linux systems the pre-installed database server is being used. The
changes discussed would need to be applied to the main mysql instance.
Configuration will influence other apps using it too.
Not always. I'm running a SVN checkout of 7.3.x, and it's using a
my.cnf
peterw;478995 Wrote:
Not always. I'm running a SVN checkout of 7.3.x, and it's using a
my.cnf file in the SqueezeCenter Cache directory. SqueezeCenter spawns
separate mysqld processes for SqueezeCenter using mysqld binaries
compiled by Logitech and pulled from Subversion. SVN checkouts of
MrSinatra;477909 Wrote:
webui response better?
Yes, the WebUI looks more responsive.
--
verypsb
2x Duet, 1x Boom, 1x Classic
verypsb's Profile: http://forums.slimdevices.com/member.php?userid=17295
View this thread:
where can i find the my.tt file in a debian install?
--
raven22
Setup: 1 SB3, 3 Booms.
Server: SheevaPlug running Debian 6.0 Squeeze on SD-card with
SqueezeBoxServer 7.4.1
raven22's Profile:
raven22;478079 Wrote:
where can i find the my.tt file in a debian install?
i don't know, isn't it roughly in the same spot? did u try reading the
whole thread at the first link i posted?
--
MrSinatra
www.lion-radio.org
using:
sb2 sbc (my home) / sbr (parent's home) - sbs 7.4.2b - win xp
where can i find the my.tt file in a debian install?
On Linux systems the pre-installed database server is being used. The changes
discussed would need to be applied to the main mysql instance. Configuration
will influence other apps using it too. Be sure what you're doing.
Configuration
raven22;478079 Wrote:
where can i find the my.tt file in a debian install?
edit: found it! it is in /usr/share/squeezeboxserver/MySQL
just in case you missed his edit.
--
MrSinatra
www.lion-radio.org
using:
sb2 sbc (my home) / sbr (parent's home) - sbs 7.4.2b - win xp pro sp3
ie8 -
mherger;478121 Wrote:
where can i find the my.tt file in a debian install?
On Linux systems the pre-installed database server is being used. The
changes discussed would need to be applied to the main mysql instance.
Configuration will influence other apps using it too. Be sure what
thats what we're trying to figure out... the default my.tt is set to
work with even the most low power hardware, (think NAS, etc) so moonbase
setup a tweaked file to unchoke the DB, but his values for it are really
just guesses. the danger is the tweaks could outpower someones
hardware, but we
I saw some mention of SQLite so I wanted to clear up some confusion.
SQLite has no tunable parameters like this. It is faster during
scanning (no IPC traffic to MySQL) but not as fast during complex browse
queries where MySQL is more advanced.
The current plan is to include full support for
That's good news. I am still figuring out how to migrate my iTunes smart
playlists to MySQL playlists, and was a bit worried that these might not
be compatible with the next major release.
--
usch
usch's Profile:
if you feel that scans take too long, the UI's are too slow, read this
thread:
http://forums.slimdevices.com/showthread.php?t=60682
and vote for this bug:
https://bugs.slimdevices.com/show_bug.cgi?id=14921
hopefully, eventually the optimization will be automated at install.
in the meantime,
Is this not too much work, when there soon will be a switch to SQLite
from MySQL?
--
verypsb
2x Duet, 1x Boom, 1x Classic
verypsb's Profile: http://forums.slimdevices.com/member.php?userid=17295
View this thread:
verypsb;477801 Wrote:
Is this not too much work, when there soon will be a switch to SQLite
from MySQL?
What is soon? :)
The release of the Touch?
--
signor_rossi
signor_rossi's Profile:
i'm not 100% positive, but i believe there will be a variation of this
applicable to the forthcoming SQLite ver of SBS. AndyG needs our data
in order to implement the feature.
--
MrSinatra
www.lion-radio.org
using:
sb2 sbc (my home) / sbr (parent's home) - sbs 7.4.2b - win xp pro sp3
ie8 -
Total Tracks: 35,792
Total Albums: 3,445
Total Artists: 1,033
Total Genres: 151
Total Playing Time: 2767:39:29
Music Scan Details (Before)
Directory Scan (35792 of 35792) Complete 00:35:37
Playlist Scan ( of ) Complete 00:00:00
MusicIP Import (35321 of 35321) Complete
interesting... your directory scan part only improved a min or two, but
your musicip part improved by around 10min. in my case, i don't use
musicip, but my directory scan improved by about 9min. i think other
people will get better results since my music is on an ext usb2 drive.
hard drive
83 matches
Mail list logo
