Apache-Talk mailing list archive (apache-talk@lists.lexa.ru)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[apache-talk] =?koi8-r?B?UmVbMl06IFthcGFjaGUtdGFsa10g68/OxsnH1dLBw8nRLi4u?=
Hello Khimenko,
Monday, June 05, 2000, 8:46:11 PM, you wrote:
KV> :-)) В MySQL нужно ОБЯЗАТЕЛЬНО ограничить время удержания неактивного
KV> соединения с 8часов до 1часа (или даже 30минут), увеличить количество
пробовал.
KV> процессов (до 4000 как минимум) и вообще понять - где узкое место.
KV> Механическая замена Linux'а на FreeBSD ничего не даст.
вот живой конфиг моего sql:
+----------------------------+---------------------------------+
| Variable_name | Value |
+----------------------------+---------------------------------+
| back_log | 5 |
| connect_timeout | 5 |
| basedir | /usr/local/ |
| datadir | /usr/local/var/ |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| join_buffer | 131072 |
| flush_time | 0 |
| key_buffer | 8388600 |
| language | /usr/local/share/mysql/english/ |
| log | OFF |
| log_update | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| max_allowed_packet | 1048576 |
| max_connections | 100 |
| max_connect_errors | 10 |
| max_delayed_insert_threads | 20 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| net_buffer_length | 16384 |
| pid_file | /usr/local/var/sql_server.pid |
| port | 3306 |
| protocol_version | 10 |
| record_buffer | 131072 |
| skip_locking | OFF |
| skip_networking | OFF |
| socket | /tmp/mysql.sock |
| sort_buffer | 2097144 |
| table_cache | 64 |
| thread_stack | 65536 |
| tmp_table_size | 1048576 |
| tmpdir | /var/tmp/ |
| version | 3.22.26a |
| wait_timeout | 3600 |
+----------------------------+---------------------------------+
Best regards,
Alexei V. Alexandrov [AA4460, AVA32-RIPN, AA1829-RIPE]
------------------------------------------------------------------------
*** Alexei V. Alexandrov --- www.elcomsoft.com --- ava@elcomsoft.com ***
------------------------------------------------------------------------
=============================================================================
= Apache-Talk@lists.lexa.ru mailing list =
Mail "unsubscribe apache-talk" to majordomo@lists.lexa.ru if you want to quit.
= Archive avaliable at =
|
