Results 1 to 3 of 3

Thread: Does running 'Maintain' do any SQL database maintenance, like a compact or reorg ?

  1. #1
    Join Date
    May 2016
    Posts
    135

    Default Does running 'Maintain' do any SQL database maintenance, like a compact or reorg ?

    I ask this because each time I add a new title to my library, I run maintain on the folder that the title is stored in.

    I hesitate to turn on maintain because it only has the option to run daily, and I don't want to put extra wear on the drives if it can be avoided.

    That being said, if the 'Maintain' process actually does back-end database cleanup, and it's recommended to keep the database running smoothly, then I will reconsider scheduling it.

  2. #2
    Join Date
    Nov 2007
    Location
    Melbourne, Australia
    Posts
    11,616

    Default

    There's no reason to run daily maintenance now with Mezzmo v5.0+. Previously, it was necessary so that Mezzmo would re-scan the folders you added into Mezzmo and pick up new files in your folders on disk and add them into your Mezzmo library.

    For Mezzmo v5.0+, we've added a new "Refresh Interval" setting for folders and linked playlists that does this for you automatically now. It's much faster & more efficient. Right-click on a folder (or linked playlist) and click Properties. Scroll down the settings until you see Refresh Interval. This setting lets you tell Mezzmo how often you want Mezzmo to re-scan the folder (or linked playlist) to find new files. New files that Mezzmo finds are added to your Mezzmo library - including matching metadata & artwork - so they are ready for streaming.

    Another advantage of Refresh Interval is that, whereas scheduled maintenance required that you keep Mezzmo (Windows) app running, Refresh Interval works for both Mezzmo (Windows) app and Mezzmo server - so you can close Mezzmo (Windows) app and just keep Mezzmo server running - and Mezzmo will update your folders automatically for you.

    To answer your specific question, maintaining your library does do some database cleanup. So you may want to run this (say) once a month if you find that your Mezzmo library is getting large or slow to browse.

    Also, when you display the Tools/Maintain Library dialog, there is a Tools tab on the Maintain Library dialog and on this tab is a Compact Now button. This button lets you optimize your Mezzmo library. Typically you don't need to do this - but you can try it from time-to-time if you feel your Mezzmo database files are getting too large.

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

  3. #3
    Join Date
    May 2016
    Posts
    135

    Default

    Thank you Paul. Good info.

Similar Threads

  1. Convert, Compact Files and Replace Original File?
    By jdlev in forum Mezzmo Questions and Support
    Replies: 4
    Last Post: 08-01-2016, 06:09 PM
  2. Database maintenance very slow
    By SilvrDrgn in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 08-18-2015, 11:47 AM
  3. Maintain Library>Maintain Files>Close starts Maintenance
    By larrymcg in forum Mezzmo Questions and Support
    Replies: 2
    Last Post: 02-09-2015, 10:09 AM
  4. Mezzmo Maintenance
    By ftanner in forum Mezzmo Wish List and Feedback
    Replies: 3
    Last Post: 12-08-2014, 01:15 PM
  5. Mezzmo Database Maintenance and Enhancements
    By tyree in forum Mezzmo Wish List and Feedback
    Replies: 1
    Last Post: 01-03-2012, 09:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

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