wolo;191894 Wrote:
I know this has been stated in other threads, but I wanted to mention it
again:
If you are running an on-access virus scanner, try adding *.MYD and
*.MYI to the exclusion list.
Adding C:\Program Files\SlimServer\ and its sub-directories had no
effect on my machine,
agentsmith;200886 Wrote:
However, I am also running SS my corporate laptop, and the McAfee virus
scanner is locked with a password.
Does anyone know how to stop McAfee temporarily when it is secured? I
cannot even stop the tasks from WIndows Task Manager.
Sounds like your corporate
I tried the above recommendations and it improved speed greaty in most
cases. For instance searching on my 17000+ songs database less than a
second now Vs 5-10 seconds.
However, browsing into artists and albums remain excruciatingly slow.
Curiously I took the advise of ont of the poster and
JJZolx;194709 Wrote:
I'd be willing to bet that a _much_ larger gain in performance could be
had by switching to MyISAM tables and maybe getting rid of all the
text/blob fields.
I've since had a chance to try this theory out...
I'm running SlimServer 6.5.2 with purely MyISAM tables and it
studley;194512 Wrote:
is it key_buffer or key_buffer_size?
It's key_buffer_size, but (I asked the question on a MySQL list) this
option only affects the performance with MySAM tables. Since
SlimServer uses InnoDB tables, this setting should have no affect on
SlimServer performance.
Actually,
is it key_buffer or key_buffer_size?
--
studley
The Guide is definitive. Reality is often inaccurate.
Sign The Petition
http://www.savethestreams.org/
Know me... know my music...
http://www.last.fm/listen/user/dstudley/personal
I can't honestly say this is a major issue for me, its just a little
irritating, and I'm left with the feeling that it could be better if
only I could find the magic button to push.
I'm running on Windows XP Pro SP2, SS 6.5.1, 2.8GHz P4, 1GB RAM,
internal disc. 727 albums with 8219 songs by 1510
The benchmark I'm using is how long it takes to respond to the Browse
Albums click through the Web UI: typically 12 seconds, can be as much
as 15. During this time CPU goes to 100%.
IMHO the bottleneck here isn't the database, but the web part, template
parsing etc. No way to improve
Michael Herger;192193 Wrote:
The benchmark I'm using is how long it takes to respond to the
Browse
Albums click through the Web UI: typically 12 seconds, can be as
much
as 15. During this time CPU goes to 100%.
IMHO the bottleneck here isn't the database, but the web part, template
Is there anything going on to change the web part to be faster?
AFAICT the developers are aware of the issue.
--
Michael
-
http://www.herger.net/SlimCD - your SlimServer on a CD
http://www.herger.net/slim - AlbumReview,
I know this has been stated in other threads, but I wanted to mention it
again:
If you are running an on-access virus scanner, try adding *.MYD and
*.MYI to the exclusion list.
Adding C:\Program Files\SlimServer\ and its sub-directories had no
effect on my machine, so I just assumed I was
It'd be very useful to have input from a SlimDevices developer about
these changes being made the MySQL settings. Erland... as the person
who may well be closest to the SlimDevices developers (due to your
wonderful plugin developement) have you any idea which developer would
know most about the
jfo;185321 Wrote:
How does one do this?? I can't seem to find this in the admin tool.
Go to your SlimServer installation folder, and edit MySQL/my.tt with
your favorite text editor.
--
Ron Olsen
Ron Olsen's Profile:
Thanks. I tried this before in Notepad and simply didn't scroll far
enough to find the settings! Another simple question...I see a
rectangular box symbol at the end of each setting statement. Is it
necessary to add this if I include the innodb variable? If so, what is
it??
Thanks. Jim
--
jfo
jfo;185447 Wrote:
Thanks. I tried this before in Notepad and simply didn't scroll far
enough to find the settings! Another simple question...I see a
rectangular box symbol at the end of each setting statement. Is it
necessary to add this if I include the innodb variable? If so, what is
it??
JFO, the my.tt file was written out with only carriage returns, not
carriage return / line feed combinations as notepad requires. You can
load it in WordPad which will handle that and write it out with the
CR/LF combos so notepad can then open it.
--
Tarn
I just made the same changes to my.tt (in Windows under Program
Files\SlimServer\Server\MySQL):
key_buffer_size = 32M
table_cache = 256
sort_buffer_size = 4M
read_buffer_size = 1M
Added variables:
innodb_buffer_pool_size = 64M
I don't know how to run the MySQL admin tool so I don't know if the
erland;177463 Wrote:
You need to make the changes in:
MySQL/my.tt
How does one do this?? I can't seem to find this in the admin tool/\.
Thanks,
Jim
--
jfo
jfo's Profile:
I am not able to add innodb_buffer_pool_size=64M to my.tt. After
restarting all, I see a wrong value if I use the admin-tool.
Does anybody can send me the my.tt file with
innodb_buffer_pool_size=64M?
Thanks
Christian
--
Schindler
egd;178455 Wrote:
Have you considered dual-booting rather than getting another PC?
Wouldn't that make it impossible to us the Squeezebox whilst using
Windows?
MC
--
ModelCitizen
Now what?
Transporter Naim NAP 250 PMC OB1s.
http://modelcitizen.mine.nu/music.txt
egd;178455 Wrote:
Absolutely. slimserver is an absolute dog for me on two separate w2k3
boxes, one of which is a fresh base install with not even an AV or
firewall in its way. So slow in fact, it is almost unusable.
Slimserver running on the same boxes under Linux and looking at the
same
ModelCitizen;178484 Wrote:
Wouldn't that make it impossible to use the Squeezebox whilst using
Windows?
I guess it would mean having to run Linux to use the SB3 without the
performance issues. I can see why it might be a problem for someone
who wants to retain a windows desktop for reasons
egd wrote:
ModelCitizen;178484 Wrote:
Wouldn't that make it impossible to use the Squeezebox whilst using
Windows?
I guess it would mean having to run Linux to use the SB3 without the
performance issues. I can see why it might be a problem for someone
who wants to retain a windows
Yes, good idea. It would also include the browser my wife need, and it
can be installed on HDD if it works as expected.
--
tommypeters
SB3--Meridian G68--NuForce Ref8--Bc Acoustique ACT A3
tommypeters's Profile:
This is a great thread. I've been having SlimServer performance issues
on Windows for quite some time now. I'm going to try out making those
changes to the amount of RAM it uses. I think it would be even better
if SlimServer would optimize the commands that it uses for the MySQL to
be more
FYI, I made the changes to my.tt and restarted slimserver.
Unfortunately that hasn't solved my problems. The web interface seems
to choke if I add say a dozen albums to it and then try to navigate.
For example I tried clicking on page 2 of 3 and the web interface is
pretty much completely
bgriffis;178232 Wrote:
I'm really getting sick of this damn thing. I've been thinking about
getting a second PC and running Linux. Maybe I'd have better results
there.
Absolutely. slimserver is an absolute dog for me on two separate w2k3
boxes, one of which is a fresh base install with
I'm very interested in optimising MySQL for Windows use and would very
much appreciate it if anyone who does any testing with the settings
would report back here, stating their library size and the settings
they found worked best for them. My library consist of *only* 18,000
(flac) songs but I've
ModelCitizen wrote:
I'm very interested in optimising MySQL for Windows use and would very
much appreciate it if anyone who does any testing with the settings
would report back here, stating their library size and the settings
they found worked best for them. My library consist of *only*
Peter;13 Wrote:
Just so you know, 18.000 records is *nothing* for MySQL.
Yes that is true. As long as you don't memory starve it. Otherwise
you'll put the HD speed in the equation...
My DB data file is about 240MB, yet SlimServer comes with MySQL
configured to the default
Adding 1500 files takes 50 seconds. This is very very slow, and I'm
totally convinced this could be speeded up by at least an order of
magnitude by simple optimization in the way slimserver handles the
database. Basically, the SQL engine should be allowed to do more of the
work.
Michael Herger wrote:
Adding 1500 files takes 50 seconds. This is very very slow, and I'm
totally convinced this could be speeded up by at least an order of
magnitude by simple optimization in the way slimserver handles the
database. Basically, the SQL engine should be allowed to do more of the
Not while adding (already indexed) tracks to a playlist?
Oops... didn't read that log file that well :-/.
--
Michael
-
http://www.herger.net/SlimCD - your SlimServer on a CD
http://www.herger.net/slim - AlbumReview, Biography,
Peter;177790 Wrote:
Then slimserver does 1500 single inserts, like this:
INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?,
?):
'351', '354', '8399'
Surely there's a more efficient way thinkable
Check out this link for multiple inserts:
bergek wrote:
Peter;177790 Wrote:
Then slimserver does 1500 single inserts, like this:
INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?,
?):
'351', '354', '8399'
Surely there's a more efficient way thinkable
Check out this link for multiple inserts:
Michael Herger wrote:
Not while adding (already indexed) tracks to a playlist?
Oops... didn't read that log file that well :-/.
I think you put me on the right track though, that's probably what's
happening, it's doing a full scan of the subtree and only then adds them
to the
Whenever I make the changes and save them, if I restart Slimserver it
overwrites them again!??
How can I stop it doing this?
My method of approach is;
Download the GUI admin tool from here;
http://dev.mysql.com/downloads/gui-tools/5.0.html
Connect to; 127.0.0.1 Port 9092
Slimserver Service is
cparker;177461 Wrote:
Whenever I make the changes and save them, if I restart Slimserver it
overwrites them again!??
How can I stop it doing this?You need to make the changes in:
MySQL/my.tt
--
erland
Erland Isaksson
'My homepage' (http://erland.homeip.net) 'My download page'
Strange. I also used the MySQL Administrator and it worked just fine.
--
Raptus
Raptus's Profile: http://forums.slimdevices.com/member.php?userid=1852
View this thread: http://forums.slimdevices.com/showthread.php?t=32417
erland;177463 Wrote:
You need to make the changes in:
MySQL/my.tt
Yep working now, excellent thanks! :)
--
cparker
cparker's Profile: http://forums.slimdevices.com/member.php?userid=2083
View this thread:
From http://forums.slimdevices.com/showpost.php?p=130572postcount=2 I
got that my.tt is a template for my.cnf, so I take my.cnf is
regenerated each time you start SlimServer. Correct?
--
Raptus
Raptus's Profile:
Raptus;177468 Wrote:
From http://forums.slimdevices.com/showpost.php?p=130572postcount=2 I
got that my.tt is a template for my.cnf, so I take my.cnf is
regenerated each time you start SlimServer. Correct?
err...
Well it would appear that my.tt overwrites the my.cnf
my.cnf is here
C:\Program
Hello there,
as in the default configuration the DB wasn't handling my 80K+ songs
well and noticing much disk activity during queries I looked into how
to increase buffering.
The settings below (to be found in my.cnf) really made SlimServer fly.
Changed variables:
key_buffer_size = 32M
I made some of the mods you did, albeit not as extreme, but I did add
innodb_buffer_pool_size=64M. My collection is about half the size of
yours (properly tagged though :P) and I've never had performance issues
under Linux, but Windows is an altogether different story. The tweaks
definitely sped
44 matches
Mail list logo
