MySQL Database: Multiple XBMC HTPC's with 1 Shared Library

MrWedel

Try this and see if it helps, I had the same kind of problem with Win 7 hosting my files and this seems to have fixed it for me so far. http://forum.xbmc.org/showpost.php?p=959...stcount=18

block134 Wrote:MrWedel

Try this and see if it helps, I had the same kind of problem with Win 7 hosting my files and this seems to have fixed it for me so far. http://forum.xbmc.org/showpost.php?p=959...stcount=18

Checked my server and it already has these settings..
But I am not sure how that would help the credential issue I have.
I get 50 Audit failed errors on the server when starting the XBMC on the Apple TV.
XBMC is presenting itself as "mobile" and there are no "mobile" user on the server and it does not help if I add a user to the server called mobile and gives is alpine as psw..

I need a little help! New to mysql and having a few problems. Have everything set up and sharing libraries from MySQL. But i'm struggling to apply the index tweaks in post #5 of this thread.

When I apply the code, it reports back:
Query OK, 0 records affected
Records: 0 Duplicates: 0 Warnings: 0

But I have 200+ records in the movie table. Why are no records updated? Could it be an access problem? I'm logged into root.

thanks for any advice
Dave

I'm getting the error "firewall exception rule not applied" or something like that, when i get done with the initial configuration of MySQL.

I've forwarded the port 3306 in my router, and added an exception for the installer and the TCP/UDP ports in windows firewall.

I go through the user creation in the server and create the databases.
When running the command: SELECT host,user from mysql.user;
I get a return with the ip 127.0.0.1, instead of the machine ip. I'm lost. Should i be pointing the AS.xml to that ip address, or my machine's local ip, as set with the router?

I've read through this thread. I still can't get XBMC to perform using a shared mySQL database with a large video library.

I've applied all the mySQL tweaks
I've applied the SMB registry tweaks
I've used symlinks
I've tried syncing via SyncToy
I've tried Dharma
I've tried Eden
Tried MySql 5.1 and MySql 5.5

Still, the performance is atrocious if you have a large library, e.g. 1000+ movies. It takes 30-40 seconds to load. At this point, I am thinking sharing a large XMBC database among multiple XBMC clients isn't feasible practically. Technically it works, but the performance in loading the library isn't responsive enough.

Anything else I could check? Or are others also experiencing the same performance with 1000+ movies.

I did some testing and it looks like there is a check going on before you see your movie list:

(2012-02-24 12:56)DasMarx Wrote:  snip

jmarshall actualy answered this and i think we might see some change in this behavior in the future ( probably not in eden)

(2012-02-24 00:49)jmarshall Wrote:  It's not asking mysql at all about the existence of a thumbnail. The thumbnail check is a simple file stat. As the thumbnail is probably located on a network share (via pathsubstitution) this is slow as hell.

I've said about a million times that this is A BAD IDEA for exactly this reason.

Note that it won't be solved until the thumbs move into the texture cache (I'm about 70% of the way there for video thumbs).

Cheers,
Jonathan

If I host the MySQL database on my main HTPC will the library be just as quick as it used to be without MySQL

I host it on another computer and don't notice anything.

if I set up a MySQL database now and then a few weeks later I want to add another HTPC and use that with the MySQL database how do I add another machine at a later date?

Also if I don't share my thumbnail folder and each machine has there own one (copied originally from the main HTPC) when are the images updated/added to the thumbnail folder?

(2012-03-12 17:43)baldsasquatch Wrote:  I've applied all the mySQL tweaks
...
Anything else I could check? Or are others also experiencing the same performance with 1000+ movies.

Im no expert but...

If you have not already done so..

Enable Query cache

Based on your server specs, adjust
query_cache_size
query_cache_min_res_unit
query_cache_limit
max_allowed_packet

Enable the slow query log, and set it to something reasonable (I have mine set to 1 sec) that will tell you what operations are taking long. My server has been up for 14 days after the last restart, and I have had 113 out of 1986800 questions that take longer than 1 sec. to complete

Also ensure that your server is able to cache connections and threads, if its trying to establish a new connection each time it asks a question, that causes overhead as well

Quirky thing with the qcache is that if there is an update to the underlying table, the cache gets invalidated and MySQL goes back to disk to fetch the result set again

That being said, I have ~1700 movies and over 3000 TV Show episodes and MySQL running off a dedicated NAS, and looking at my DB logs, MySQL still returns result sets in under a second, but it sometimes takes XBMC anywhere between 5-10 seconds to process through the response depending on my HTPC hardware (the Intel i7 is the fastest, while my ATV2 is pretty slow).. It also varies depending on how long instances have been running or if they have just been started.. I am guessing thats because there is a bunch of addon scripts that get run as soon as XBMC starts which slows down other operations such as listing the libraries

The other bottleneck I see (as others have pointed out) is the Thumbnails folder, which I have also on the NAS shared through NFS across 4 XBMC instances