search for: key_buffer

...= /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp skip-external-locking bind-address = 0.0.0.0 key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M log_error = /var/log/mysql/error.log expire_logs_days = 10 max_binlog_size...

...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 do performance tweak their mysql servers. Also, if there is anything recomme...

...ized 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 parameters or variables or resources (hardwar...