[apache-talk] Re[2]: [apache-talk] Конфигурация...

["Alexei V. Alexandrov" <ava@xxxxxxxxxxxxx>]

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@xxxxxxxxxxxxx ***
------------------------------------------------------------------------


=============================================================================
=               Apache-Talk@xxxxxxxxxxxxx mailing list                      =
Mail "unsubscribe apache-talk" to majordomo@xxxxxxxxxxxxx if you want to quit.
=       Archive avaliable at http://www.lexa.ru/apache-talk                 =