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
    770
    62
    Arlington Heights, Illinois
    Home Country
    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

    • Crash_15.10.2013_0755.zip
      791.9 KB · Views: 95
    Last edited:

    breese

    Retired Team Member
  • Premium Supporter
  • July 11, 2011
    3,903
    770
    62
    Arlington Heights, Illinois
    Home Country
    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
    770
    62
    Arlington Heights, Illinois
    Home Country
    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

    • MP2Export.zip
      88.5 KB · Views: 93

    ArnoldGoat

    MP Donator
  • Premium Supporter
  • May 27, 2007
    103
    20
    74
    Lyttelton
    Home Country
    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,329
    3,792
    Lehmden
    Home Country
    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
    103
    20
    74
    Lyttelton
    Home Country
    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,752
    7,115
    Home Country
    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

    It is looking and working very well now and I am almost at the point of switching my HTPC to MP2, madvr would definitely push me over the edge for sure.;)
    It is looking and working very well now and I am almost at the point of switching my HTPC to MP2, madvr would definitely push me...
    We are proud to present MediaPortal 2.3 MediaPortal 2.3 is a full-blown media center software that addresses the most common user...
    Replies
    4
    Views
    2K
    MP1 MP2 MediaPortal2-Buddy DE
    That’s what Lehmden said. Watched flags get migrated when updating to 2.2. Also a new plugin is almost finished to backup watched flags and restore later.
    That’s what Lehmden said. Watched flags get migrated when updating to 2.2. Also a new plugin is almost finished to backup watched...
    Hi. And here is another "Buddy"... Today's Buddy is "MediaPortal2-Buddy" (or short, MP2-Buddy), a tool to do some work around...
    Replies
    4
    Views
    9K
    Also being in the U.S. (Chicagoland) I would be very interested in knowing what you have or plan to work on... ATSC is a real pain for us and if you have the experience in making it easier, I am sure the other Dev's would love the help. Are you on ATCS, cable card, etc????
    Also being in the U.S. (Chicagoland) I would be very interested in knowing what you have or plan to work on... ATSC is a real pain...
    After having failed to create a plugin for MP1; rather than dive into it to figure out why I decided why not bring up mediaportal 2...
    Replies
    9
    Views
    2K
    We are proud to present MediaPortal 2.2 Pre-Release It has been some time since last release, but we were intensively working on the implementation of new features and some fundamental changes in the core of MediaPortal 2. As a result, we proudly present the next major release of MediaPortal 2 in version 2.2. MediaPortal 2.2 is a...
    We are proud to present MediaPortal 2.2 Pre-Release It has been some time since last release, but we were intensively working on...
    We are proud to present MediaPortal 2.2 Pre-Release It has been some time since last release, but we were intensively working on...
    Replies
    0
    Views
    3K
    Attention WMC skin users: a very minor optical bug got introduced that leads to some navigation buttons being permanently visible when playing TV. We will exchange the download version on SourceForge as soon as possible.
    Attention WMC skin users: a very minor optical bug got introduced that leads to some navigation buttons being permanently visible...
    The MP2 team is proud to present the release of MediaPortal 2.1.2 MediaPortal 2.1.2 is a full-blown media center software that...
    Replies
    1
    Views
    11K
    Top Bottom