[Aquarius]

Dear all,

I have a question about performance improvements possible for the mysql db.

I have a working Video and Music mysql library on my Qnap TS-412 NAS (4 bays, low power Marvell ARM CPU, 512Mb RAM).
I have 600+GB of music (mainly FLACs bur also old mp3 which means probably more than or about 100 000 music files (Bach and Mozart "Complete Works" are BIG). XBMC is installed on a Raspi, a Bay Trail HTPC and an old Core2Duo desktop computer.

The library indexing is agonisingly slow and crashed a couple of times. But more than that I now have 10-30seconds lag after I click on "Music" to display the library or the directories.

I read this:
http://wiki.xbmc.org/index.php?title=MyS...nced_notes
And other tips telling me to switch the storage engines on my database tables to InnoDB.
I have done all this (except skip-name-resolve but will do soon).

What now? Is there a big benefit in increasing the amount stored in RAM ? (increasing buffer size of the InnoDB tables, like I read here:
http://dev.mysql.com/doc/refman/5.1/en/i..._pool_size
)
(note: I have no grasp on how big my 100000 songs table would take in my NAS RAM, It might just be unrealistic).

Other question: My HTPC has a bay trail CPU and 8GB RAM and is mostly-permanently-on, would it make a huge difference to use it to store the DB instead of my NAS?)

Thanks

EDIT bonus question:
Reading http://wiki.xbmc.org/index.php?title=MyS...ng_up_XBMC
It looks like I could have a shared Video library (share Whatched status, thumbails, metadata ...) but a keep a separate Music library for each XBMC instance. For that I would just have to remove the <musicdatabase> part in the xml file.
Basically I would avoid all the headaches caused by the size of my music library and just use directory structure for browsing music, while keeping a nice and easy-to-use video library.
Will this work ?