Home of the Squeezebox™ & Transporter® network music players.
Page 5 of 8 FirstFirst ... 34567 ... LastLast
Results 41 to 50 of 73
  1. #41
    Senior Member
    Join Date
    Jan 2013
    Posts
    313
    Quote Originally Posted by mherger View Post
    > I am running LMS 8.1.1 on Windows 10. How do I ascertain if I am using
    > MySQL or SQLite? There are folders for both within Squeezebox\server.


    If you don't know what you're using, you're using SQLite :-)

    MySQL really only is there for legacy reason. There might be some users
    of it, but it requires manual configuration. Therefore you'd know about it.
    Fair enough, that makes sense. I must be running SQLite!

  2. #42
    Senior Member philchillbill's Avatar
    Join Date
    Jan 2019
    Location
    The Netherlands
    Posts
    621
    Quote Originally Posted by Shozzer View Post
    Fair enough, that makes sense. I must be running SQLite!
    How much less sugar does it have than the regular non-diet version ?


    Sent from my iPhone using Tapatalk

  3. #43
    Senior Member
    Join Date
    Mar 2011
    Posts
    156
    Quote Originally Posted by Roland0 View Post
    Thanks for the feedback.

    I'm still fiddling with some of the parameters (cache sizes, mainly). Currently, they should be fine for ~1-2GB free memory.
    However, if enough people with different requirements use this (probably unlikely...), it might make sense to add some kind of configuration mechanism.
    Another idea would be to add an auto max config, which simply sets the caches to the sizes of the databases (although my artwork db currently has 1,2GB, so for a small system this may not be such a great idea)
    i'm on of those guys willing to throw more RAM on the issue. I'm also willing to test (with you) how much more RAM is really needed to speed up the things. I have 32 GB which are more or less usable. But i also think, there must be a break even point where adding more RAM doesn't help anymore.

    Also, because i'm curious and have DB spcialists here, why is the whole stuff file based and would a dedicated DB server or a Redis server help?

  4. #44
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,530

    [Announce] Database Optimizer plugin

    > Also, because i'm curious and have DB spcialists here, why is the whole
    > stuff file based and would a dedicated DB server or a Redis server help?


    File based: it's simpler and good enough.

    We used to ship with MySQL for a while, but maintaining MySQL in the
    background on Windows in a user friendly package wasn't easy.

    Redis: isn't a general purpose database, and certainly not SQL.

    But you should be able to use MySQL, if you wanted to give it a try.
    Would be interesting if that would turn out to be faster. One advantage
    certainly would be that it would use another core on today's multi-core
    systems, whereas SQLite is running inside the single LMS thread.

  5. #45
    Senior Member SpiderJon's Avatar
    Join Date
    Dec 2008
    Location
    Cardiff, Wales, UK
    Posts
    202

    Re-enabling the sqlite_stat4 table

    Quote Originally Posted by Roland0 View Post
    DB Optimizer is a plugin for LMS to improve it's database performance and memory use.
    More information can be found on the homepage.
    Hi Roland0

    Re: Re-enabling the sqlite_stat4 table in "Other methods to improve performance" on your LMS DB Optimizer info page.

    Where is Makefile.PL? And is there anything else you need to do after uncommenting the line '-DSQLITE_ENABLE_STAT4' to get things going?

    Thanks
    Duet x 3, via various hi-fi. LMS on Raspberry Pi OS (Debian 10) on a Pi4.

  6. #46
    Senior Member
    Join Date
    Jan 2013
    Posts
    313
    Quote Originally Posted by philchillbill View Post
    How much less sugar does it have than the regular non-diet version ?


    Sent from my iPhone using Tapatalk
    I'm not sure that sugar enters into it. More like steroids. When TrackStat was enabled for LMS 8.* I immediately installed it, only to uninstall it very shortly afterwards - starting and stopping LMS was taking too long. Out of curiosity I have installed the Optimizer plugin and also TrackStat. Starting and Restarting the server is now extremely quick. I did a complete clear and rescan but funnily enough that seemed to take longer. I will have to keep an eye on that.

    There is one side effect I am experiencing. The Control Panel refuses to open. I restarted my Windows 10 PC and tried to open the panel. It opened straight away. I closed it and tried again a short while after and now it refuses to open. Any pointers on this please?

  7. #47
    Senior Member
    Join Date
    Mar 2011
    Posts
    156
    Quote Originally Posted by Shozzer View Post
    I'm not sure that sugar enters into it. More like steroids. When TrackStat was enabled for LMS 8.* I immediately installed it, only to uninstall it very shortly afterwards - starting and stopping LMS was taking too long. Out of curiosity I have installed the Optimizer plugin and also TrackStat. Starting and Restarting the server is now extremely quick. I did a complete clear and rescan but funnily enough that seemed to take longer. I will have to keep an eye on that.
    are your files tagged with musicbrainz_id? If so, then you can disable the musicbrainz id stuff within trackstat settings. Would be interesting if this is the cause of the slow startb and stop. If so, then you're number two of those guys which have this. I'm working on a fix for that. But not ready for primetime.

  8. #48
    Senior Member
    Join Date
    Mar 2011
    Posts
    156
    Quote Originally Posted by mherger View Post
    >
    But you should be able to use MySQL, if you wanted to give it a try.
    Would be interesting if that would turn out to be faster. One advantage
    certainly would be that it would use another core on today's multi-core
    systems, whereas SQLite is running inside the single LMS thread.
    It wasn't clear to me that this is an option. I will try this at least to report here the outcome. Oh i love the flexibility of this stuff. Pure fun.

  9. #49
    Senior Member
    Join Date
    Aug 2012
    Location
    Austria
    Posts
    1,192
    Quote Originally Posted by mherger View Post
    > I'm still fiddling with some of the parameters (cache sizes, mainly).
    > Currently, they should be fine for ~1-2GB free memory.


    I'll have to play with this, in particular with the imageproxy.db, too:
    MAI makes heavy use of it to cache artist artwork etc... Are you using MAI?
    I am (artists only), but my imageproxy.db is only 8MB (even though I've checked " Download and pre-cache artist pictures from online sources"), so I haven't bothered with it.
    Do you have an idea what typical sizes would be?
    Various SW: Web Interface | TUI | Playlist Editor / Generator | Music Classification | Similar Music | Announce | EventTrigger | DB Optimizer | Chiptunes | LMSlib2go | ...
    Various HowTos: build a self-contained LMS | Bluetooth/ALSA | Control LMS with any device | ...

  10. #50
    Senior Member
    Join Date
    Aug 2012
    Location
    Austria
    Posts
    1,192
    Quote Originally Posted by mherger View Post
    But you should be able to use MySQL, if you wanted to give it a try.
    Would be interesting if that would turn out to be faster. One advantage
    certainly would be that it would use another core on today's multi-core
    systems,
    I'd speculate MySQL won't be faster.
    There are a couple of methods to exploit multi-threading. Ignoring processing several SQL queries at once (as LMS sends queries sequentially) and more esoteric ones (data sharding etc.), this basically leaves intra query parallelism, e.g.
    - if a query has subqueries, processing those in parallel
    - under certain (limited) conditions, certain ops during query processing can be parallelized (e.g. higher level (table scans etc., usually requires explicit declaration), lower level (e.g. sorting results))
    MySQL will be better at this, but SQLite actually supports a (very) limited form of the latter approach (iirc sorting results, maybe more?). Multi-threading is, however, disabled by default. My plugin enables it (2 threads), but atm I have no idea if it is ever used.
    On the flip side, SQLite has an advantage in having siqnificantly less overhead (no server etc.) and no intra-process communication.
    And there is a real question if LMS even uses single queries worth parallelizing (in terms of both complexity and data volume), as this generates overhead of it's own (thus, SQLite has built-in heuristics to decide how many threads it uses for a query).

    Nevertheless, I agree, if anyone bothers to invest time in actually benchmarking this, it'll interesting to the see the results.

    Quote Originally Posted by mherger View Post
    SQLite is running inside the single LMS thread.
    I don't think this prevents SQLite from launching additional threads if it is so inclined.
    Various SW: Web Interface | TUI | Playlist Editor / Generator | Music Classification | Similar Music | Announce | EventTrigger | DB Optimizer | Chiptunes | LMSlib2go | ...
    Various HowTos: build a self-contained LMS | Bluetooth/ALSA | Control LMS with any device | ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •