Speed up your massive XBMC MySQL Libraries

I started playing around with query caching recently and it has markedly improved the speed of my XBMC clients.

http://www.howtogeek.com/howto/programming/speed-up-your-web-site-with-mysql-query-caching/

Intersting.

Played with it before but will again.

I recently moved from MySQL on windows to the same dbase as a virtual machine in linux (running on the same host)

The difference in speed was 10 fold. Crazy

Perhaps I should move my media library database off my HTPC and on to the unRAID box?

I started playing around with query caching recently and it has markedly improved the speed of my XBMC clients.

 

http://www.howtogeek.com/howto/programming/speed-up-your-web-site-with-mysql-query-caching/

did you modify your my.cnf file?  from what I understand, unmenu's mysql install overwrites the my.cnf at boot?

Can you share your settings and/or steps to make the changes permanent?

Thanks,

mike

 

did you modify your my.cnf file?  from what I understand, unmenu's mysql install overwrites the my.cnf at boot?

 

Can you share your settings and/or steps to make the changes permanent?

 

Thanks,

mike

Yes. I'm using:

query_cache_limit = 2M

query_cache_size = 32M

It's way more than necessary. I'm showing 30M free, but RAM is cheap.

I'm running MySQL inside a Linux VM. I have used it in UnRAID in the past though. You need to edit the correct my.cnf file inside the actual package. If I remember correctly, the unmenu package uses the mymedium.cnf by default. If you're using the plugin it's a little different, but I can't recall how.

Thanks. Just getting my server set up, and looking for all the speed I can get.