[confirm] - DataBase Size Error | Page 3

Discussion in 'Older releases' started by guytpetj, March 4, 2012.

  1. morpheus_xx
    • Team MediaPortal

    morpheus_xx Lead Dev MP2

    Joined:
    March 24, 2007
    Messages:
    11,090
    Likes Received:
    4,766
    Ratings:
    +6,826 / 11
    Home Country:
    Germany Germany
    Show System Specs
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. guytpetj
    • Premium Supporter

    guytpetj MP Donator

    Joined:
    March 24, 2005
    Messages:
    424
    Likes Received:
    53
    Gender:
    Male
    Occupation:
    Director - Oil and Gas Exploration
    Location:
    USA
    Ratings:
    +58 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    • Like Like x 1
  4. guytpetj
    • Premium Supporter

    guytpetj MP Donator

    Joined:
    March 24, 2005
    Messages:
    424
    Likes Received:
    53
    Gender:
    Male
    Occupation:
    Director - Oil and Gas Exploration
    Location:
    USA
    Ratings:
    +58 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    morpheus_xx

    The file is uploaded to folder as per previous post. let me know if you can open it and extract the database.
     
  5. morpheus_xx
    • Team MediaPortal

    morpheus_xx Lead Dev MP2

    Joined:
    March 24, 2007
    Messages:
    11,090
    Likes Received:
    4,766
    Ratings:
    +6,826 / 11
    Home Country:
    Germany Germany
    Show System Specs
    Thanks for sharing your DB! I spent some time to check if there are errors, but all seems to be ok. The most space inside DB is occupied by the thumbnails (~800 MB in sum). Your DB also helps to find bottlenecks and some (size, speed) limits in our communication architecture.

    I think you have a setup that brings the "small SQL CE" engine to its limits. We will provide another DB adapter in future, maybe for MySQL or PostGreSQL to have a "real RDBMS" that can deal with this size without problems. This will introduce a more difficult setup though...
     
    • Like Like x 2
  6. guytpetj
    • Premium Supporter

    guytpetj MP Donator

    Joined:
    March 24, 2005
    Messages:
    424
    Likes Received:
    53
    Gender:
    Male
    Occupation:
    Director - Oil and Gas Exploration
    Location:
    USA
    Ratings:
    +58 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    I'm glad the database was of use to you.

    I think that people with databases as big as mine have enough "geekness" to deal with a special more complicated db setup. The important thing is to keep it simple for the average user.

    Anyway, if you want me to test some code related to different database engines in the future than just let me know.
     
    • Like Like x 2
  7. morpheus_xx
    • Team MediaPortal

    morpheus_xx Lead Dev MP2

    Joined:
    March 24, 2007
    Messages:
    11,090
    Likes Received:
    4,766
    Ratings:
    +6,826 / 11
    Home Country:
    Germany Germany
    Show System Specs
    • Like Like x 2
  8. guytpetj
    • Premium Supporter

    guytpetj MP Donator

    Joined:
    March 24, 2005
    Messages:
    424
    Likes Received:
    53
    Gender:
    Male
    Occupation:
    Director - Oil and Gas Exploration
    Location:
    USA
    Ratings:
    +58 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    Excellent, will install this in the week-end and let you know how things went.
     
    • Like Like x 1
  9. guytpetj
    • Premium Supporter

    guytpetj MP Donator

    Joined:
    March 24, 2005
    Messages:
    424
    Likes Received:
    53
    Gender:
    Male
    Occupation:
    Director - Oil and Gas Exploration
    Location:
    USA
    Ratings:
    +58 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    OK, may be a little later than this week-end.

    I started with a fresh MP2 install, than applied the patch, so far so good. Did this on my server.
    Unfortunately during scanning my media and some other software activity at the same time my server CPU and motherboard went up in smoke.
    Server had been running for 5 years 24/7, I guess it died of old age.
    Waiting now for the new CPU, motherboard, RAM and PSU to arrive. Luckely my HDD's and RAID arrays survived.
     
  10. morpheus_xx
    • Team MediaPortal

    morpheus_xx Lead Dev MP2

    Joined:
    March 24, 2007
    Messages:
    11,090
    Likes Received:
    4,766
    Ratings:
    +6,826 / 11
    Home Country:
    Germany Germany
    Show System Specs
    Ouch... Sorry to hear that. I hope your system gets running soon again! Good luck!
     
  11. guytpetj
    • Premium Supporter

    guytpetj MP Donator

    Joined:
    March 24, 2005
    Messages:
    424
    Likes Received:
    53
    Gender:
    Male
    Occupation:
    Director - Oil and Gas Exploration
    Location:
    USA
    Ratings:
    +58 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    All up and running again with my server.

    Started with a clean fresh system install.
    Installed MP2 autumn plus MySQL patch.
    Added: 1,000 movies, 517series (19,600 episodes), 35,000 songs and 63,000 picture and let MP2 do its magic.
    The importing of all the media did indeed go faster, still took more then 10 hours, but a big improvement over previous.

    But it is not all good news, I did find some strange behaviour in MP2.
    • MP2 is slower than before when searching the database and creating views
    • Movies works fine
    • Audio, Video, series and Images all come with the same error, see pictures below.



    MP2_Audio.PNG
    MP2_Video.PNG
    MP2_Images.PNG
    MP2_Series.PNG
     
    • Like Like x 2
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!