huang leo 写道: > hi,everyone, > I just did a test to find out the MySQL4.1.12 max connections on > FreeBSD 5.4 Release and FreeBSD 4.11 Release. The first test, the > MAXSSIZ is default(64MB), and MAXSDIZ is 1GB because I have 1GB > memory. The second test, I setted the MAXSSIZ=1GB, and the MAXDSIZ is > also 1GB. The two test show that the MySQL max connections is the > same. The max connections is about 1000. > Have anyone kown how to tune the FreeBSD and MySQL to increase the max > connections? > > Best regards, > leo huang > [EMAIL PROTECTED] > 2005-06-17 > > _________________________________________________________________ > 与联机的朋友进行交流,请使用 MSN Messenger: http://messenger.msn.com/cn > mysql> show variables like '%max%'; +---------------------------------+----------------------+ | Variable_name | Value | +---------------------------------+----------------------+ | bdb_max_lock | 10000 | | ft_max_word_len | 84 | | group_concat_max_len | 1024 | | innodb_max_dirty_pages_pct | 90 | | innodb_max_purge_lag | 0 | | max_allowed_packet | 1048576 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | max_connect_errors | 10 | | max_connections | 100 | | max_delayed_threads | 20 | | max_error_count | 64 | | max_heap_table_size | 16777216 | | max_insert_delayed_threads | 20 | | max_join_size | 18446744073709551615 | | max_length_for_sort_data | 1024 | | max_relay_log_size | 0 | | max_seeks_for_key | 4294967295 | | max_sort_length | 1024 | | max_tmp_tables | 32 | | max_user_connections | 0 | | max_write_lock_count | 4294967295 | | myisam_max_extra_sort_file_size | 2147483648 | | myisam_max_sort_file_size | 2147483647 | +---------------------------------+----------------------+ 24 rows in set (0.00 sec)
You can see max_connections=100. Change that variable to get max connections you want. Regards, Gu Lei -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]