xbmc on Atv2 is extremely slow after configuring MySQL

Were are the thumbs stored? Are they on a slow drive? are you on GB network?

My buddy is running his on a SSD on a GB network and his thumbs all load up nice and quick.

Hi JPColin -

I wrote the Quixventure guide and I'm sorry to hear that your set-up is running slow. XBMC/MySQL runs very quickly for me and I am only using a cheap DS110j as my MySQL server...

I am reading the speed up tweaks now and will try them out at home, then update the guide if they show any improvement.

If you make any interesting progress, let me know and I will add it to my guide as well!

EDIT: Just added the my.conf entry and I think it may have added a little extra bump in performance. Let me know if you need any help setting it up on the Synology, I'll probably add a post to Quixventure shortly!

(2012-04-12 14:14)DLeavy Wrote:  [quote='jpcolin' pid='1073554' dateline='1334216122']

I do share my thumbnail directory, and the response isn't that bad - never more than a second to load the fanart in the background

There must be something wrong in my setup then!
Is more like 20-30s to load a menu!

I use a DS410 on a Dlink Gigabit router (of course ATV2 is 100Mbit)
I use SMB.
All is Cat5e Wired.

Until now the thumbs where on the ATV, and now on the Synology.

@Ozymandyaz
you have a setup with a synology as MySQL server and an ATV2 without the skip-name-resolve and it runs quickly? and you share the thumbs?
there must be something really wrong in my setup then

Well, you can determine if it's the MySQL database or the thumbs, by only changing one of them and testing - i.e use the MySQL database, but keep the thumbs local. See if you're still getting a performance hit.

Might also consider turning on debugging and posting a log debug log - this might tell you where it's spending all its time.

(2012-04-12 16:53)jpcolin Wrote:  

(2012-04-12 14:14)DLeavy Wrote:  [quote='jpcolin' pid='1073554' dateline='1334216122']

I do share my thumbnail directory, and the response isn't that bad - never more than a second to load the fanart in the background

There must be something wrong in my setup then!
Is more like 20-30s to load a menu!

I use a DS410 on a Dlink Gigabit router (of course ATV2 is 100Mbit)
I use SMB.
All is Cat5e Wired.

Until now the thumbs where on the ATV, and now on the Synology.

@Ozymandyaz
you have a setup with a synology as MySQL server and an ATV2 without the skip-name-resolve and it runs quickly? and you share the thumbs?
there must be something really wrong in my setup then

Its gotta be the thumbs... I use MySQL on the NAS and I have my thumbs shared via path substitution using NFS. All other connections are SMB... Maybe try NFS just for the thumbs? I have used SMB for thumbs and did not see much difference, so YMMV.. But yeah, a debug log may be a good idea, see what's really going on! There is probably a permission problem somewhere.

Ok removed the substitution for the thumbs, still no go.

I folloewd your toturial Ozymandyaz.

created a new user in myphp (synology) with username: xbmc, password xbmc
Granted all access..

here is my log, there is something wrong with the db!
http://pastebin.com/efbYtmhh

Ok, I see the issue, there are empty databases named xbmc_video and xbmc_music. In the past you needed to create those, but now it screws up XBMC... Go into phpmyadmin and delete those databases. You only want the ones that end with numbers to remain, I.e. xbmc_video60 and xbmc_music19.

I only have my iPhone right now but if you get stuck I can post a video later this happened to me a few times too... I think it's common enough that I should post an update about it...

^^ what OZYMandyaz said - there are a lot of old instructions (e.g. Lifehacker) that are out of date and have you performing steps that aren't necessary, like creating the databases in MySQL.

reason I'm replying, is that I did notice from your log that you're running RC2. Any reason why you're not upgrading to Eden final? Note that if you're looking to share your library, they will all need to be on the same XBMC release. I'm not saying this will fix your issue with performance (but, hey, it might). Just seems to make sense to upgrade from the release candidate to Eden final.

ok indeed i followed some time ago another tutorial saying i had to create those databases...
i'll try to delete them... and keep you informed.

Wel the reason i don't update to the latest is that everything works fine, no buffering at all,...
and i have read some post saying there is buffering with the latest...
so i'm often think : if it ain"t broken don't fix it!

At the moment i only have 1 xbmc running, but i'm preparing for ATV3, so..... ;-)

I have two ATV1 (Crystalbuntu) boxes, two ATV2s (one on 4.3 and one on 4.4) and a few Windows boxes all running the Eden final release =) Go for the upgrade!

And... up till a few months ago my guides also had the wrong info about creating the initial databases =(