Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 32

Thread: Database file size

  1. #21
    Join Date
    Jan 2012
    Posts
    19

    Default

    Shamelessly bumping this thread as the issue still seems unresolved.

    FWIW my db file is close to 4GB with just 74 movie files, a tad over 16,500 music files and no play lists.

    I realize adrian has kindly provided his php binary in a post above, but for those of us who don't want to go through installing and configuring php, sqlite, etc for the sole purpose of reducing the mezzmo database file (self-defeating if you have to install something to reduce disk space usage), there doesn't seem to be much of an option right now (unless of course some kind soul could convert that php to a vbs script for other to run?).

    So is there a real solution on the horizon for this?

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

    Default

    We are fixing this for the upcoming Mezzmo 4.0.

    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. #23

    Default

    I created a ZIP archive with all files needed to run the database cleanup script. Since it's 3 MB I had to upload it (couldn't attach it here).

    Download link: http://we.tl/AHkUJqJJFa (auto-expires in 7 days)

    Instructions: unzip archive right next to the Mezzmo.db file. You should end up with the following file structure:
    - [...]
    - Mezzmo.db
    - db_compact
    ___ - fixMezzmoDb.php
    ___ - run_cleanup.bat
    ___ - php*

    Double click the run_cleanup.bat file - it will launch the php.exe interpreter which will load and run the fixMezzmoDb.php script.
    The archive is self-contained, no additional runtime or libraries are required.
    You will need to have an additional free space at least the same size as the Mezzmo.db file or else the compact will fail.. If your database is 7 GB, you need to have at least 7.01 GB of free space. After the compact finishes, you will get back both the 7 GB required by the temporary journaling, plus the trimmed 6+ GB from the original database file

    Note that this solution is not permanent. When Mezzmo updates a dynamic playlist (after adding some new files for example), all affected playlists will again duplicate all thumbnails. Slowly it will grow, and grow, and grow... I would run this script daily for example.
    Last edited by adrian; 01-13-2014 at 08:11 AM.

  4. #24

    Default

    Sorry for two posts in a row, but I suggest the following to the Mezzmo developers, since they'll probably scratch their heads after the issue will be noticed in the future:

    After you guys fix this redundancy/space problem, you will need to keep the existing user data. You probably understand by now that re-compacting a database that has gigabytes in size, will be impossible in the most scenarios, due to space and performance limitations. So here's my most valuable advice for your 4.0 issue-solver code: do not run a VACUUM on a database with gigabytes in size, since it could take like forever. Be smart and create a NEW database file, and copy the existing un-redundant tables and data from the OLD Mezzmo.db file. This will not require the same-as_db-size free space issue.

    I could have done this myself in the script I posted, but since I have no idea what tables or columns you might decide to add in a future scheme, it's basically not something I would risk myself to do. Plus, the database might be updated by the Mezzmo process while the script is still copying data, so yeah... it's your responsability to solve this.
    Last edited by adrian; 01-13-2014 at 08:33 AM.

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

    Default

    Many thanks for all your helpful information, adrian. We'll run various tests on our new v4.0 database (including upgrading) and make sure it all operates OK.

    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

  6. #26
    Join Date
    Dec 2012
    Location
    Sierra Vista, Arizona
    Posts
    51

    Default

    Quote Originally Posted by adrian View Post
    ...Slowly it will grow, and grow, and grow... I would run this script daily for example.
    Adrian, thank you for the script. It would not run on my computer until I downloaded the latest PHP files and placed them in the directory. How long did it take to run on your computer. After running for 12 hours I had to reboot so I don't think it ever completed. DB is still 5.1GB. I might run it like once every two weeks just due to how long it took to execute.

  7. #27

    Default

    Quote Originally Posted by scottier View Post
    Adrian, thank you for the script. It would not run on my computer until I downloaded the latest PHP files and placed them in the directory. How long did it take to run on your computer. After running for 12 hours I had to reboot so I don't think it ever completed. DB is still 5.1GB. I might run it like once every two weeks just due to how long it took to execute.
    The operation time depends on database size, processing power, memory, and hard drive performance. I takes 10 minutes for my 4 GB database, but I have a powerful PC.

    I've updated the PHP script to run faster, by copying the entire final content into a new database file instead of doing a reconstruct of the original, as I explained earlier. You can try running this and see how it works. It should be way faster, since it will only do a secvential write operation.

    Note that at the end you have to delete the Mezzmo.db file and rename the Mezzmo_temp.db to Mezzmo.db. I can't do this automatically because you will need to manually shutdown Mezzmo server before you will be able to delete the database file.
    Attached Files Attached Files

  8. #28

    Default

    Since I am not allowed to start a new thread I'll have to tag on to the end of this one! My gripe is that whilst some media servers allow the user to turn off thumbnaiing (altogether) Mezzmo does not. I insist on having this feature and if it's not included in the very near future I shall have to ask for a refund.
    I have another gripe, and although it's not related to this thread I'm going to append it here (again because I am not allowed to start a new one + I dont' want to be bothered rummaging thro' old posts). It's a combination of two things: (1) that Mezzmo defaults to putting it's database + all its temp. files on C: (without 1st asking the user), and (2) it downloads updates to C: (again without 1st asking the user). I like, as far as possible to reserve C: for the OS and object to this behaviour.

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

    Default

    Not sure why you cannot create a new thread

    In Mezzmo v4.0 we've just added backdrop artwork and we do allow you to turn these off (via the Metadata Retrieval Settings dialog), so for consistency we should also allow users to turn off poster artwork as well. We'll look into it for a future version.

    In Mezzmo v4.0, you can now change/move the Mezzmo database location to any drive/folder in the Options dialog (General page). Click the folder icon in the Mezzmo database location edit box and click OK.

    Regarding updates, you can change the folder using the following steps:

    • Using Windows Explorer, go to the Mezzmo program folder and run AutoUpdate.exe. Close this program after it runs.
    • Used Windows Registry Editor (regedit.exe) to edit your registry (be careful - make a backup of your registry before making any changes!) Go to the following location in your registry:
      "HKEY_LOCAL_MACHINE\Software\Conceiva\Mezzmo\Autou pdate\Folder" and you can edit the "Temp" entry to change the location of where updates are downloaded to.

    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

  10. #30
    Join Date
    Mar 2012
    Posts
    227

    Default

    Quote Originally Posted by Paul View Post
    Not sure why you cannot create a new thread

    In Mezzmo v4.0 we've just added backdrop artwork and we do allow you to turn these off (via the Metadata Retrieval Settings dialog), so for consistency we should also allow users to turn off poster artwork as well. We'll look into it for a future version.

    In Mezzmo v4.0, you can now change/move the Mezzmo database location to any drive/folder in the Options dialog (General page). Click the folder icon in the Mezzmo database location edit box and click OK.

    Regarding updates, you can change the folder using the following steps:

    • Using Windows Explorer, go to the Mezzmo program folder and run AutoUpdate.exe. Close this program after it runs.
    • Used Windows Registry Editor (regedit.exe) to edit your registry (be careful - make a backup of your registry before making any changes!) Go to the following location in your registry:
      "HKEY_LOCAL_MACHINE\Software\Conceiva\Mezzmo\Autou pdate\Folder" and you can edit the "Temp" entry to change the location of where updates are downloaded to.
    Be careful with moving the database. I did this and it wiped out all of my Mezzmo settings and database contents. I suspect that the contents are still there since the folder where I moved them to is almost 3GB in size, but Mezzmo no longer sees the data. It's been just shy of two weeks now, and despite being told on the 10th that they had a fix for it, I am now being told that I have to re-submmit my log files. I made the mistake of assuming that they had the database movement working. They do not. Sure, I could completely re-create my database, but I *SHOULD NOT* have to do this after using a feature that they say is working. Especially considering that I have about 700 movies and dozens of TV shows, in addition to about 500GB of music.

Similar Threads

  1. Changing Subtitle Color and Size
    By guhorns in forum Mezzmo Questions and Support
    Replies: 5
    Last Post: 07-13-2013, 02:35 PM
  2. TV Icon Size
    By sysv in forum Mezzmo Questions and Support
    Replies: 5
    Last Post: 01-02-2012, 05:19 AM
  3. Render to exact screen size
    By FlyingVguitarist in forum Mezzmo Questions and Support
    Replies: 2
    Last Post: 09-29-2011, 01:43 AM
  4. Video Thumbnail Size on Samsung TV
    By Gus in forum Mezzmo Questions and Support
    Replies: 10
    Last Post: 06-29-2011, 09:53 AM
  5. Size Limitation
    By MPG in forum Mezzmo Questions and Support
    Replies: 2
    Last Post: 11-17-2010, 04:18 PM

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
  •