Ok mysql it is,.. it is very interresting - here you can do a lot | | interactive_timeout=10
good to have it low but be aware of sideeffects in other applications | wait_timeout=3600 | connect_timeout=20 | thread_cache_size=128 | key_buffer=64M ## 32MB for every 1GB of RAM you really need 64mb key buffer? for shure? what does the runtime env say. how much % you use really ? | join_buffer=1M way to high do a 128.00k | max_connect_errors=20 | max_allowed_packet=16M you can lower this way down. this is the max size a blob can have. problem is that every connection will resevere memory for that | table_cache=8196 how much (in %) table cache is used ? | record_buffer=1M ?? 1mb each mb who tols you that back to 128k for both | sort_buffer_size=2M ## 1MB for every 1GB of RAM | read_buffer_size=2M ## 1MB for every 1GB of RAM here again 128k - it doenst help here a bigger size like above - it just slows down | read_rnd_buffer_size=2M ## 1MB for every 1GB of RAM | thread_concurrency=8 ## Number of CPUs x 2 how many concurrenct cannects you allow DOES NOT depend on the cpu it depens on memory and which settings are above - keep it lower is not a mistake but maybe you can speed up with more simulatan processes | myisam_sort_buffer_size=32M lower that one too. - special you dont use myisam anyway :-) lower than myisam down to a few mb max | pbxt-record-cache-size=1G | pbxt-index-cache-size=1G pretty shure too high try it out and make a stress test bevore and after - (you can do some crazy sql statements for this and read the reaction time ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
