Plugin: MySQL database provider - better performance and no size limit for your MP2-MediaLibrary (1 Viewer)

MJGraf

Retired Team Member
  • Premium Supporter
  • January 13, 2006
    2,478
    1,385
    Country flag
    Hi jehe,
    that's most likely the famous "never use MS products to unzip files you downloaded from the internet"-bug :D
    Try to unzip the files using 7zip or alternatively, right-click all the files in the MySQLDatabase plugin directory, click on properties and choose "unblock" (right lower end of the dialog). .Net refuses to load DLLs, which were downloaded from the internet. Unfortunately, the inbuilt MS zip explorer extension propagates this "dirty"-flag to all the files contained in a zip file, which itself was downloaded. We already thought about uploading all our plugins as .7z files, where this problem cannot occur...
    Thanks for testing!
    Michael
     

    breese

    Retired Team Member
  • Premium Supporter
  • July 11, 2011
    3,903
    769
    62
    Arlington Heights, Illinois
    United States of America United States of America
    Country flag
    While I have not found if there is a fix for the "Path" issue, there is a work around in 5.6
    I will be downloading and installing MySQL 5.7.2M12 today

    [1 Aug 12:09] Jefferson Dollar
    It looks like this is a issue depending on the collation for the table. In MySQL 5.6.13, if the collation was set to utf8 - default collation, creating an index over a certain size will fail. However, if the collation for the table is set to latin1 - default collation, the index is silently truncated.

    Edit: Crashed - MP2 Server will not start
    Removed MP2, Installed Mysql5.7.2.M12
    I did a fresh install of MP2
    Stopped the MP2-Server process
    Installed the last post of MySQLDatabase to MP2-Server
    MP2-Server process would not start.
    Crash folder also has install and temp files from MySQL
    Let me know if there is anything else you need.... If you would like me to try something, please give me detail because I do not know what I am doing with MySQL outside of the config file.
     

    Attachments

    Last edited:

    breese

    Retired Team Member
  • Premium Supporter
  • July 11, 2011
    3,903
    769
    62
    Arlington Heights, Illinois
    United States of America United States of America
    Country flag
    But there seems to be different behaviour in differnt MySQL versions
    If you reduce the InnoDBpage size to 8KB or 4KB by specifying the innodb_page_size option when creating the MySQL instance, the maximum length of the index key is lowered proportionally, based on the limit of 3072 bytes for a 16KB page size. That is, the maximum index key length is 1536 bytes when the page size is 8KB, and 768 bytes when the page size is 4KB.

    http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html[DOUBLEPOST=1382015913][/DOUBLEPOST]Morpheus, is there a configuration file I can change so as to test a mysql 5.6 or higher install?
    I was thinking about installing 5.5, import a few things, Export the DB, upgrade it to 5.6 and see what happens
     
    Last edited:

    breese

    Retired Team Member
  • Premium Supporter
  • July 11, 2011
    3,903
    769
    62
    Arlington Heights, Illinois
    United States of America United States of America
    Country flag
    I installed MySQL 5.5, Installed a fresh Mp2 with MySQL plugin, imported 1 album.
    Went into MySQL and exported the MP2 database
    Maybe this will help with getting MP2 working with MySQL 5.6 or higher
     

    Attachments

    ArnoldGoat

    MP Donator
  • Premium Supporter
  • May 27, 2007
    96
    18
    73
    Lyttelton
    New Zealand New Zealand
    Country flag
    I am contemplating moving from MP1 to MP2. I have always liked the notion of a 'proper' database and use MySQL for this and many other things. But the trail has been cold for 7 years now, so is this plugin still maintained and/or working?
     

    Lehmden

    Retired Team Member
  • Premium Supporter
  • December 17, 2010
    12,202
    3,725
    Lehmden
    Germany Germany
    Country flag
    Hi.
    This Database provider is obsolete as it has no advantages but only disadvantages compared to the now (since a long time) default SQLite (that is included in the main installer package for sure). SQLite needs no external database server, it also is unlimited in DB size and it's ten times faster than MySQL (real live speed tested by ourselves). The only "downside" of SQLite is that there can be only one writing access at a time. Opposite to MP1 where everyone can fiddle around with the database of TV server the MP2 server is the only task that read and write to the MP2 database. Sp this is no disadvantage in this use case. I was part of the testing team as we finally (but very easily in the end) decided to go with SQLite. It definitely is way better than any other option we could test ...

    MySQL (that meanwhile is commercial, so it should be MariaDB instead nowadays) is the db engine to choose if you need a "multi- user from multi- location" access to the database. This is valid for MP1 and also for Kodi, but this is not the case for MP2. Under "one- user from one location only" access as it is the case for MP2, SQLite is the much better, the best choice without any doubt.
     

    ArnoldGoat

    MP Donator
  • Premium Supporter
  • May 27, 2007
    96
    18
    73
    Lyttelton
    New Zealand New Zealand
    Country flag
    Thanks for the prompt reply and recommendation. I have used MySQL since the last century, and stayed with the Community Edition when Oracle took it over. I use it for several projects, and with a bit of glue software, I use it to synchronise TV series and movies between the MP1 server and clients. It seems that the synchronising is redundant now in MP2. Please confirm that the server software for MP1 and MP2 can coexist on the same hardware, provided only one is running at a time. Then it should be relatively easy to switch back if it all turns pear-shaped. The things I worry about are Netflix and TVNZ catchup which don't play nicely with other software. I use IRSS to switch between them and MP1.
     

    morpheus_xx

    Lead Dev MP2
  • Team MediaPortal
  • March 24, 2007
    11,597
    7,059
    Germany Germany
    Country flag
    • Thread starter
    • Moderator
    • #39
    Please confirm that the server software for MP1 and MP2 can coexist on the same hardware, provided only one is running at a time. Then it should be relatively easy to switch back if it all turns pear-shaped.
    Yes, I can confirm the two versions can coexists. If you are using MP1 TVServer, you must make sure to stop the service first before you install and setup MP2. Both version are using different program and data folders and even different database engines.
     

    Users who are viewing this thread

    Similar threads
    OP Title Forum Replies Date
    C Issue with plugin initialisation My TVSeries 7
    morpheus_xx [Finished] "What's New" plugin for MP2 upgrades MediaPortal 2 20
    da3dsoul [Request] An MVP Plugin example for custom settings in MP2 Plugin Development 2
    da3dsoul MP2 Plugin - Getting Started (Directory Tree and Player) Plugin Development 27
    M Installing Plugins Newcomers Forum 2
    joecrow 1.25.0 Radio Time plugin fails after Resume from Sleep with MP 1.25 Bugreports 10
    P MP2: US user, OTA - can NOT get SchedulesDirect plugin to work on MP1 or MP2 --> how do I get OTA schedule? General 5
    E aktuelle englische Forums Webseite von - Showtime Plugin v3 Plugins & Erweiterungen 4
    mrmojo666 [Tv Server Plugin ]Direct Show Video Control Plugin 0.0.0.1 for Hauppauge PVR cards MediaPortal 1 Plugins 0
    joecrow MultiShortcut Plugin (Uavailable) in DWHD skin General Support 58
    vapourEyes Building TV Plugin General Development (no feature request here!) 49
    Golf4 Nach Windows-Updates läuft TV-Plugin nicht mehr Allgemeines Support- und Diskussionsforum 0
    joecrow How about a Launcher plugin for MP1? MediaPortal 1 6
    D [solved] TVServer Plugin must be missing something. General Development (no feature request here!) 1
    framug Nouveau plugin XmlTvFR pour récupérer le guide télé français Kazer / ZguideTv (WebEPGfr) 28
    emphatic Allow remote control mapping of all plugins Improvement Suggestions 0
    D Where should plugins be located on hard drive? General Support 0
    D how to disengage from one version of a plugin to use another Newcomers Forum 0
    cbr954rr How to disable a pre-configured plugin? General 2
    mrmojo666 [Plugin]Marantz Control Plugin 0.0.0.2 MediaPortal 1 Plugins 2
    mrmojo666 beginner: trying to write a plugin, need help to catch event General Development (no feature request here!) 3
    framug [Rejected] Fix PowerScheduler plugin for MP2 single seat Submit: Code Patches 11
    doskabouter [Question] Stale plugins Developer Discussions 9
    M MP1 stops responding after Starting Plugins General Support 14
    Terra LAVFilter Plugin cannot be updated (MP1.23) MediaPortal 1 Plugins 10

    Similar threads

    Top Bottom