- March 24, 2007
- 12,073
- 7,459
- Home Country
-
Germany
- Moderator
- #1
MP2 - MySQL database provider, updated for Winter Release!
After a long day of coding and testing I implemented support for MySQL as database backend for MP2-Server!
What does this bring for users?
How big is the impact of chosen database?
For testing I created 4 shares:
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
After a long day of coding and testing I implemented support for MySQL as database backend for MP2-Server!
What does this bring for users?
- Much better performance compared to MSSQL-CE
- No size limit for your MediaLibrary
- Remove existing SQLCEDatabase plugin from MP2-Server\Plugins folder
- Place 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)
- If you like to change connection details, edit the "MySQLSettings.xml" inside plugin folder
- 21.02.2013: 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.
- 28.11.2012: initial version of MySQL plugin (removed)
How big is the impact of chosen database?
For testing I created 4 shares:
- 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")
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
Attachments
Last edited: