Performance awful of Music with shared DB on Synology NAS

El_Matthews · 2013-05-20 14:42

Due to the multiple Xbmc’s at home I decided to move to a shared DB. In general this is working well except for the performance while browsing my music.

When I browse my library by Artist, after I select the artist (depending on the number of albums) I have to wait between 30 to 50 seconds before albums are displayed. I agree that I have quite a big library (11713 artists with 3516 albums) but this feels very slow. Do other shared db users have same issues?

I already checked forums and found some tweak settings. I applied the skip-name-resolve and modified the read_buffer_size = 256K in my.cnf for the Mysql server. Is there anything else I can do?

Code:

/etc/my.cnf

# The MySQL server

[mysqld]

port            = 3306

socket          = /tmp/mysql.sock

skip-locking

skip-name-resolve

key_buffer_size = 16K

max_allowed_packet = 1M

table_open_cache = 4

sort_buffer_size = 64K

read_buffer_size = 256K

read_rnd_buffer_size = 256K

net_buffer_length = 2K

If I would have to guess, it looks like there is no indexed link between artist and album in the db?

[/i]PS: when browsing in file mode, everything seems immediate
PS2: it first sight no problems are logged in the debug.log