Speed up your massive XBMC MySQL Libraries

[cpshoemake]

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/

[NAS]

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

[inh]

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

[momoz]

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

 

[cpshoemake]

 

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.

[flippedcracker]

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