[confirm] DataBase Size Error (1 Viewer)

guytpetj

MP Donator
  • Premium Supporter
  • March 24, 2005
    424
    57
    56
    USA
    United States of America United States of America
    morpheus_xx

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

    morpheus_xx

    Lead Dev MP2
  • Team MediaPortal
  • March 24, 2007
    11,400
    6,971
    Germany Germany
    Country flag
    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...
     

    guytpetj

    MP Donator
  • Premium Supporter
  • March 24, 2005
    424
    57
    56
    USA
    United States of America United States of America
    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.
     

    guytpetj

    MP Donator
  • Premium Supporter
  • March 24, 2005
    424
    57
    56
    USA
    United States of America United States of America
    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.
     

    morpheus_xx

    Lead Dev MP2
  • Team MediaPortal
  • March 24, 2007
    11,400
    6,971
    Germany Germany
    Country flag
    Ouch... Sorry to hear that. I hope your system gets running soon again! Good luck!
     

    guytpetj

    MP Donator
  • Premium Supporter
  • March 24, 2005
    424
    57
    56
    USA
    United States of America United States of America
    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
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    toricred Using TMM, How to Stop Importer From Going to The Movie Database for Data General 1
    H MP2 database won't keep in synch with recordings General 8
    F How to reset tv recordings database General 5
    A Synchronizing client databases MediaPortal 1 Talk 10
    R Problems accessing MySQL database remotely MediaPortal 1 Talk 0
    globaldonkey Music Database Error Listen Music 1
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    H [solved] Video database genres, sort titles and collection thumbnails Newcomers Forum 12
    G MP1 TV Server "failed to upgrade the database" using MS Sql Server Installation, configuration support 3
    D PC rebuild & MP2 upgrade - how to preserve database and settings? General 1
    H MP1.21F video database scan, can it be scheduled to automatically run in background General Support 5
    D Large xml database in My Movies Management. I remain unclear on use My Films as bridge to MP2.2 General 9
    ajs Sync databases by Media Sync Service MediaPortal 1 Talk 26
    J Database schema General 0
    W [solved] MP 1.20 Video IMDB no showing plot General Support 129
    hounddog How to get My Films working in MP 1.20 My Films 5
    C How well can MediaPortal handle 10,000+ recordings? MediaPortal 1 Talk 3
    H Database migration Archive 85
    D Single Seat Install - can another single seat use the same databases? Installation, configuration support 1
    P [Resolved] Missing column in database My TVSeries 7
    M Need advice on writing plugin that modifies EPG database TV-Server 2
    ajs [WiP] 5030: Add UHD Thumb size to TV Server MediaPortal 1 0
    azzuro [fixed] 5011: Version label in Splash screen - pos, size from skin MediaPortal 1 61
    wizard123 [solved] Auto sizing buttons to text content MediaPortal 1 11
    Similar threads

























    Top Bottom