October 27, 201114 yr 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/
October 27, 201114 yr 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
October 27, 201114 yr Perhaps I should move my media library database off my HTPC and on to the unRAID box?
January 9, 201214 yr 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
January 10, 201214 yr Author 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.
January 11, 201214 yr Thanks. Just getting my server set up, and looking for all the speed I can get.
Archived
This topic is now archived and is closed to further replies.