I have 2 kodi boxes ( 1 upstairs 1 down) and recently we wanted to share the watched status between both boxes.
Setup MySQL 8 on the same server (Windows Server 2019) thats hosting all the media.
Every thing works great apart from every now and again (~ 1 out of 3) the down stairs box takes an age before you can view the media.
Its just an annoyance more than any thing as in the end it does load.
I’d rather it not though 
both boxes are similar spec intel 8100, 8GB ram, win 10, kodi 19.3 both worked fine no issues before MySQL shared Db
Debug log of it working normally https://paste.kodi.tv/foxizifago.kodi
Degug log with delay of ~60 seconds https://paste.kodi.tv/turepodoqe.kodi
Both boxes do an automatic scan on startup, I usually wait for this to pop up as this is when I can view the media. Which is normally ~5 seconds after kodi starts yet, sometimes hangs for ~60 seconds or so.
Any pointers would be much appreciated.