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,475
    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

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

    OP Similar threads Forum Replies Date
    morpheus_xx [WiP] "What's New" plugin for MP2 upgrades MediaPortal 2 5
    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 4
    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) 11
    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 9
    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
    L Mediaportal 1.21 and Windows 10: user schedules de-activated when powerscheduler plugin is selected General Support 1
    Similar threads

























    Top Bottom