Hello there, as in the default configuration the DB wasn't handling my 80K+ songs well and noticing much disk activity during queries I looked into how to increase buffering.
The settings below (to be found in my.cnf) really made SlimServer fly. Changed variables: key_buffer_size = 32M table_cache = 256 sort_buffer_size = 4M read_buffer_size = 1M Added variables: innodb_buffer_pool_size=64M Probably some of those are overkill, so I'm going to test the impact of each one to determine a more efficient value set. Right now I'm under the impression that the innodb buffer makes for the biggest performance gain by far (and task manager shows the memory really being used). Suggestions are welcome :) PS.: you need to restart the mysqld.exe for changes to take effect. -- Raptus ------------------------------------------------------------------------ Raptus's Profile: http://forums.slimdevices.com/member.php?userid=1852 View this thread: http://forums.slimdevices.com/showthread.php?t=32417 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
