Home of the Squeezebox™ & Transporter® network music players.
Page 1 of 5 123 ... LastLast
Results 1 to 10 of 43
  1. #1
    Dave Strickler
    Guest

    When should I switch from SQLLite to MySQL?

    I have about 13,000 MP3s ripped down to a dedicated SuSE server, running
    Slimserver v6.2. Its not a rockin server, but its got 4GB of RAM and a
    1.3GB processor, and normally has a 0.5 to 1.0 LA.

    While Slimserver is working perfectly, its a little sluggish to search
    for songs, sometimes taking 15-20 seconds to return a search. I am
    planning on ripping more CDs, so I fear the response time will lag
    further in the future.

    My thought is, perhaps its time to switch to MySQL for better
    performance. But my question is, would it be worth it? Will I really see
    that much of a speed gain?

    Thanks,

    Dave Strickler
    MailWise LLC
    617-933-5810 (direct)
    www.mailwise.com
    "Intelligent E-mail Protection"


    ----------------------------
    This message has been certified virus-free by MailWise Filter - The real-time, intelligent, e-mail firewall used to scan inbound and outbound messages for SPAM, Viruses and Content. For more info visit: http://www.mailwise.com

  2. #2
    Senior Member Browny's Avatar
    Join Date
    Nov 2005
    Location
    Suffolk, UK
    Posts
    187
    I have updated from using SQLite to MySQL (4.1) and found performance to be MUCH more to my liking - in particular in relation to doing a complete rescan. I'm currently running 6000 flacs on a ClarkConnect 1.3Ghz Athlon Server with 512Mb RAM. There are no latency issues for that I can see - searches included.

    The reason I switch was to allow me to view and update the Slimserver database while slimserver is running.

    If you look at Slimserver's roadmap you will find that MySQL is the way Slimserver is going for the future. Why not early adopt? It is pretty painless (see the wiki) and you can go back very easily if you don't like it.

    One final note of caution - I have seen a couple of posts relating to issues running on MySQL 5. Stick with 4.1 for now.

  3. #3
    Robin Bowes
    Guest

    When should I switch from SQLLite to MySQL?

    Dave Strickler said the following on 01/21/2006 03:29 PM:
    > I have about 13,000 MP3s ripped down to a dedicated SuSE server, running
    > Slimserver v6.2. Its not a rockin server, but its got 4GB of RAM and a
    > 1.3GB processor, and normally has a 0.5 to 1.0 LA.


    Is this server running other stuff as well as slimserver?

    My slimserver is running on a dual 1GHz P3 with 1.5GB RAM. It hardly
    shows any load.

    > While Slimserver is working perfectly, its a little sluggish to search
    > for songs, sometimes taking 15-20 seconds to return a search. I am
    > planning on ripping more CDs, so I fear the response time will lag
    > further in the future.
    >
    > My thought is, perhaps its time to switch to MySQL for better
    > performance. But my question is, would it be worth it? Will I really see
    > that much of a speed gain?


    Not if the other stuff on the box is causing the load problem.

    It's easy enough to test though; just create the DB and change your
    config and re-scan.

    R.


  4. #4
    Dave Strickler
    Guest

    When should I switch from SQLLite to MySQL?

    Sounds like I should give it a shot. I had trouble creating the DBs the
    other day, so I will see if I am doing something wrong. I'll let you
    know my experiences.

    Thanks for the feedback...

    Dave Strickler
    MailWise LLC
    617-933-5810 (direct)
    www.mailwise.com
    "Intelligent E-mail Protection"


    >>> Browny.220d00 (AT) no-mx (DOT) forums.slimdevices.com 6:22:40 PM Saturday,

    January 21, 2006 >>>

    I have updated from using SQLite to MySQL (4.1) and found performance
    to
    be MUCH more to my liking - in particular in relation to doing a
    complete rescan. I'm currently running 6000 flacs on a ClarkConnect
    1.3Ghz Athlon Server with 512Mb RAM. There are no latency issues for
    that I can see - searches included.

    The reason I switch was to allow me to view and update the Slimserver
    database while slimserver is running.

    If you look at Slimserver's roadmap you will find that MySQL is the
    way
    Slimserver is going for the future. Why not early adopt? It is pretty
    painless (see the wiki) and you can go back very easily if you don't
    like it.

    One final note of caution - I have seen a couple of posts relating to
    issues running on MySQL 5. Stick with 4.1 for now.


    --
    Browny
    ------------------------------------------------------------------------
    Browny's Profile: http://forums.slimdevices.com/member.php?userid=2295

    View this thread: http://forums.slimdevices.com/showthread.php?t=20281



  5. #5
    Senior Member max.spicer's Avatar
    Join Date
    Apr 2005
    Location
    York, United Kingdom
    Posts
    1,661
    Well prompted! I put mysql on my server last week in order to serve another application. Your post prompted me to take the obvious step of making SlimServer use it. Following the wiki entry, it took me an obsolute maximum of 5 minutes to set up. I'd say things definitely seem faster as a result, although I've not had much time to check. I'm convinced that random mix now takes less time to select tracks - the gap between starting a mix and the first song starting to play seems much shorter.

    Max
    Some people think the title of this song is irrelevant,
    but it's not irrelevant - it's a hippopotamus.

  6. #6
    Dr Lovegrove
    Guest

    Re: When should I switch from SQLLite to MySQL?

    On 24/01/06, max. spicer <max.spicer.225tzn (AT) no-mx (DOT) forums.slimdevices.com> wrote:
    >
    > Well prompted! I put mysql on my server last week in order to serve
    > another application. Your post prompted me to take the obvious step of
    > making SlimServer use it. Following the wiki entry, it took me an
    > obsolute maximum of 5 minutes to set up.


    I switched yesterday as well, and am pretty impressed with performance
    as well.. No more pauses in randommix - yay ! :-)

    Few minor gripes though:

    Be nice to have better instructions on how to install MySQL itself.. Took me
    a while to suss that I had to login as root, create a new user, create the
    database, grant root permissions to use the database, grant the new user
    permissions, etc.. This was all with 4.1.. Maybe it's better with 5 ?

    Slimserver 6.5 kept falling over on startup as it turns out it needed some
    CPAN stuff adding..

    Oh, also I had to upgrade my version of perl for 6.5 - kept giving a popup
    about some kind of memory thing not being supported.. Latest activestate
    build did the trick..

    --
    - Dr Lovegrove
    http://www.rusticrhino.com/drlovegrove

  7. #7
    Senior Member Patrick Dixon's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    1,805
    Hmm, well I've spent the 5 minutes and I'm getting nowhere ...

    I'm getting:

    mysql> Ungrant all on slimserver.* to slimserver [identified by 'password'];
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Ungrant all on slimserver.* to slimserver [identified by 'password']' at line 1

    and I have no idea what any of it means!

  8. #8
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,460

    Re: When should I switch from SQLLite to MySQL?

    > Be nice to have better instructions on how to install MySQL itself..
    > Took me
    > a while to suss that I had to login as root, create a new user, create
    > the
    > database, grant root permissions to use the database, grant the new user
    > permissions, etc.. This was all with 4.1.. Maybe it's better with 5 ?


    Install phpMyAdmin. It's so much easier to do these administrative tasks.

    > Oh, also I had to upgrade my version of perl for 6.5


    ....and I'd have to install MySQL 4.x - Slimserver does not like 3.x. :-/

    --

    Michael

    -----------------------------------------------------------
    Help translate SlimServer by using the
    SlimString Translation Helper (http://www.herger.net/slim/)


  9. #9
    Senior Member Patrick Dixon's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    1,805
    Be nice to have better instructions on how to install MySQL itself.. Took me
    a while to suss that I had to login as root, create a new user, create the
    database, grant root permissions to use the database, grant the new user
    permissions, etc.. This was all with 4.1.. Maybe it's better with 5 ?
    Any chance you could share your knowledge?

    I'm blindly following the wiki instructions - I figured out how to login as root -
    mysql -u root

    and the first line -
    create database slimserver;

    which I assume creates the db, seems to execute. After that ?????

    Thanks

  10. #10
    Quote Originally Posted by Patrick Dixon
    Hmm, well I've spent the 5 minutes and I'm getting nowhere ...

    I'm getting:

    mysql> Ungrant all on slimserver.* to slimserver [identified by 'password'];
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Ungrant all on slimserver.* to slimserver [identified by 'password']' at line 1

    and I have no idea what any of it means!
    Apologies if I'm barking up the wrong tree here, because I'm not using slimserver myself (yet!), but I assume you should be typing something like:

    Code:
    Ungrant all on slimserver.* to slimserver identified by 'your_password_here';
    Or, if the user 'slimserver' doesn't have a password defined for them, just:

    Code:
    Ungrant all on slimserver.* to slimserver;

Posting Permissions

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