pippin;480718 Wrote: > Did you import old TrackStat ratings? > I recently re-setup my server and moved to 7.5.0 and when I let > TrackStat (2.10, I believe) import my old ratings it took down the > server for around 12h (it's a slow server), logged a LOT of stuff and > caused mysql load that was so heavy that I couldn't even connect a > player to the server. > > I let it run overnight and now it looks like it calmed down and I'm > back to normal operation. > > I remember Erland had some issues with some db change in 7.4 that > caused slow lookups and one proposed solution was to generate an > additional table with hash ids to speed things up and only cause the > slow operation once at startup. > I don't know whether Erland implemented that but this was _my_ suspect > for the cause, I'll see how it will work in the future... > > > Thanks :-) Have fun with it.
I did try to import an XML library file from iTunes that had all of my current track ratings. It had been running for about 24 hours on a very fast HP EX495 that is set up with dual core 2.5ghz cpu. I just had to uninstall it because it is causing way too much server load and I don't understand what it found in the import that caused it to start trashing everything. I'm hoping this explains my loss of presets on the radio although it's a bit hard to understand. I will just recreate the presets and see how things work over the next couple of days. -- jmpage2 ------------------------------------------------------------------------ jmpage2's Profile: http://forums.slimdevices.com/member.php?userid=41 View this thread: http://forums.slimdevices.com/showthread.php?t=70788 _______________________________________________ Radio mailing list Radio@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/radio
