HOW-TO:Share libraries using MySQL: Wiki Edition
(2018-01-07, 20:04)ventolin Wrote: I've downgraded to mysql 5.6 and everything is behaving itself again, so I'm happy for the time being. 

In your tests, what size does the MyMusic db have? I would suggest filling it with an awful lot of data in order to simulate this behaviour. For example:

I don't recall but probably not that many, I guess the important thing is that there was no obvious difference in performance.

It's entirely possible there is a regression/bug in the MySQL 5.7.19 server you were testing - I think we did internal testing with MySQL 5.7.20/MariaDB 10.1.26. This is really the biggest problem with server-based relational databases - every version can behave a little differently, whether intentionally or not.
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Reply


Messages In This Thread
RE: HOW-TO:Share libraries using MySQL: Wiki Edition - by Milhouse - 2018-01-07, 20:21
Logout Mark Read Team Forum Stats Members Help
HOW-TO:Share libraries using MySQL: Wiki Edition2