home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 2
Plugin Development
Plugin: MySQL database provider - better performance and no size limit for your MP2-MediaLibrary
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="morpheus_xx" data-source="post: 936726" data-attributes="member: 48495"><p><span style="font-size: 18px"><u><strong>MP2 - MySQL database provider, <u><span style="color: #ff0000">updated for Winter Release</span></u>!</strong></u></span></p><p> </p><p>After a long day of coding and testing I implemented support for MySQL as database backend for MP2-Server!</p><p> </p><p><u><strong>What does this bring for users?</strong></u></p><ul> <li data-xf-list-type="ul">Much better performance compared to MSSQL-CE</li> <li data-xf-list-type="ul">No size limit for your MediaLibrary</li> </ul><p><u><strong>How to install and configure?</strong></u></p><ul> <li data-xf-list-type="ul"><span style="color: #ff0000"><strong>Remove</strong></span> existing SQLCEDatabase plugin from MP2-Server\Plugins folder</li> <li data-xf-list-type="ul"><span style="color: #000000">Place</span> MySQLDatabase plugin into MP2-Server\Plugins folder (there can be only one!!!)</li> <li data-xf-list-type="ul">Overwrite contents of MP2-Server with contents from MP2_Server_Update (smaller changes on medialibrary were needed)</li> <li data-xf-list-type="ul"><span style="color: #888888"><span style="color: #000000">If you like to change connection details, edit the "MySQLSettings.xml" inside plugin folder</span></span></li> </ul><p><span style="font-size: 18px"><strong><u>Changelog:</u></strong></span></p><ul> <li data-xf-list-type="ul"><span style="color: #ff0000"><strong>21.02.2013</strong></span>: Updated to work with MP2 Alpha1 Winter Release! This version works much easier, with close to zero configuration requirements. I removed all old notes, as they are no longer required.<br /> </li> <li data-xf-list-type="ul"><strong>28.11.2012</strong>: initial version of MySQL plugin (removed)</li> </ul><p></p><p><u>How big is the impact of chosen database?</u></p><p> </p><p>For testing I created 4 shares:</p><ul> <li data-xf-list-type="ul">local folder with BluRay images (type "Movie")</li> <li data-xf-list-type="ul">local folder with custom videos (type "Video")</li> <li data-xf-list-type="ul">folder with Series on NAS (type "Series")</li> <li data-xf-list-type="ul">folder with Music on NAS (type "Audio")</li> </ul><p>A normal import using the default SQL-CE database took ~9 minutes. This includes thumbnail extraction and DB access.</p><p> </p><p>Using MySQL on same PC the import time decreased to ~4 minutes! It's twice as fast as MSSQL-CE.</p><p> </p><p>The reason for this is probably the fact, that MSSQL-CE is run in the process of the host (MP2-Server) and it's not as efficient as a dedicated database process. On analysis I found out, that most time was spent on a "DELETE" SQL-statement that uses subqueries with "LIKE" on the path part. MySQL performs a lot better, probably because it is able to use the existing index on path.</p><p> </p><p>To get a number: for MSSQL-CE the time for DB-Access was double of the time required for thumbnail creation! (160 sec vs. 80 sec!)</p><p> </p><p>Stay tuned <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p></blockquote><p></p>
[QUOTE="morpheus_xx, post: 936726, member: 48495"] [SIZE=5][U][B]MP2 - MySQL database provider, [U][COLOR=#ff0000]updated for Winter Release[/COLOR][/U]![/B][/U][/SIZE] After a long day of coding and testing I implemented support for MySQL as database backend for MP2-Server! [U][B]What does this bring for users?[/B][/U] [LIST] [*]Much better performance compared to MSSQL-CE [*]No size limit for your MediaLibrary [/LIST] [U][B]How to install and configure?[/B][/U] [LIST] [*][COLOR=#ff0000][B]Remove[/B][/COLOR] existing SQLCEDatabase plugin from MP2-Server\Plugins folder [*][COLOR=#000000]Place[/COLOR] MySQLDatabase plugin into MP2-Server\Plugins folder (there can be only one!!!) [*]Overwrite contents of MP2-Server with contents from MP2_Server_Update (smaller changes on medialibrary were needed) [*][COLOR=#888888][COLOR=#000000]If you like to change connection details, edit the "MySQLSettings.xml" inside plugin folder[/COLOR][/COLOR] [/LIST] [SIZE=5][B][U]Changelog:[/U][/B][/SIZE] [LIST] [*][COLOR=#ff0000][B]21.02.2013[/B][/COLOR]: Updated to work with MP2 Alpha1 Winter Release! This version works much easier, with close to zero configuration requirements. I removed all old notes, as they are no longer required. [*][B]28.11.2012[/B]: initial version of MySQL plugin (removed) [/LIST] [U]How big is the impact of chosen database?[/U] For testing I created 4 shares: [LIST] [*]local folder with BluRay images (type "Movie") [*]local folder with custom videos (type "Video") [*]folder with Series on NAS (type "Series") [*]folder with Music on NAS (type "Audio") [/LIST] A normal import using the default SQL-CE database took ~9 minutes. This includes thumbnail extraction and DB access. Using MySQL on same PC the import time decreased to ~4 minutes! It's twice as fast as MSSQL-CE. The reason for this is probably the fact, that MSSQL-CE is run in the process of the host (MP2-Server) and it's not as efficient as a dedicated database process. On analysis I found out, that most time was spent on a "DELETE" SQL-statement that uses subqueries with "LIKE" on the path part. MySQL performs a lot better, probably because it is able to use the existing index on path. To get a number: for MSSQL-CE the time for DB-Access was double of the time required for thumbnail creation! (160 sec vs. 80 sec!) Stay tuned :) [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
Plugin Development
Plugin: MySQL database provider - better performance and no size limit for your MP2-MediaLibrary
Contact us
RSS
Top
Bottom
