[firnsy]

I have one question though: I've got the database on the server, and everything looks good, except none of my thumbnails are present except on the machine I initially used to scrape.

Yes, this is a side effect and you will still have to sync your thumbnail cache between boxes. During the new db rewrite this will be addressed.

edit: just updated my htpc box and things are running super slow. don't see anything obvious in the debug log... I'm no mysql expert, is there something simple that could be hugely slowing things down. From my mac to my linux server things are nice and snappy, but from my linux htpc to my linux server it is super slow.

of note, when I initially tried to connect to the database I created using my mac, it would not play back the files b/c it said they could not be found. I then created a new database on the server and started scanning things into it from the htpc. Its still super slow, but once the video stream is started it will playback HD video no problem. The slowness seems to be due solely to reading the database.

You have to remember that there is no optimisation done from the mysql side of the house, and this patch was cleaned up to get committed to the mainline and get some airtime.

There are bound to benefits gained from tuning your mysql server. For those who have trepidations about this, remember it is an advanced feature.