search for: join_buffer_size

...SQL typical set the default interactive_timeout to 8hrs (28800) this has bitten me a few times with sleeping processess or stale connections. What I have done in the past was optimize mysql with the following variable changes (/etc/my.cnf) wait_timeout=60 connect_timeout=10 interactive_timeout=120 join_buffer_size=1M query_cache_size=128M query_cache_limit=2M sort_buffer_size=8M key_buffer = 256M key_buffer_size=64M ... According to the mongrel docs it says to use 4hrs - assuming you didn''t edit mysql default settings- but what I am curious to know, is what most people set this to, those of us who...

...10 sec to connect to the database. I optimized all possible parameters in my.cnf: max_connection=1000 wait_timeout=60 query_cache_type=1 query_cache_limit=4M query_cache_size=512M interactive_timeout=120 connect_timeout=80 table_cache=1024 thread_concurrency=8 long_query_time=10 tmp_table_size=64M join_buffer_size=1M thread_cache_size=200 key_buffer=32M table_cache=1024 sort_buffer_size=2M read_buffer_size=2M read_rnd_buffer_size=4M And I am running on asterisk 1.4.22.1, Quadcore processor 2.4Ghz, 4GB RAM, mysql 5.0. Some times we get dead air even after 50-100 calls. Is there any other additional parameter...

...skip-name-resolve back_log=100 interactive_timeout=172800 default-storage-engine = INNODB default-character-set = utf8 max_connections = 500 max_connect_errors=100000 max_allowed_packet = 4M max_heap_table_size = 1024M max_length_for_sort_data = 4096 net_buffer_length = 8K sort_buffer_size = 8M join_buffer_size = 16M #if lock memory #memlock table_cache = 1024 thread_cache_size = 512 thread_concurrency = 8 query_cache_type=0 #memory table max size tmp_table_size = 128M #******************************* Logs related settings *************************** log-error=/usr/local/mysql/log/error3.log long_qu...