Does the kernel options MAXSSIZ affect the MySQL max connections on FreeBSD
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Does the kernel options MAXSSIZ affect the MySQL max connections on FreeBSD
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 | 1 | | 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]
mySQL max connections
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I have a mySQL database thats taking a bit of a hammering - enough so that the number of connections spirals up and out of control. max_connections was originally at the default of 100 - but rising above 50 or so meant actual throughput dropped so the db never got a chance to keep up (meaning manually restarting the db). I've lowered max_connections to 40 which at least keeps the db alive. But, the number of connections keeps rising to and bouncing off this limit - and for the users that hit it a 'Too many connections' error is given. Now, I've optimised all the tables and queries as much as is humanely possible - - and the only way out I can see so far is to have some kind of connection queue to keep people waiting for the 1/2 second or so until the load spike drops off (I'd rather have a few slow pages than errors any day). Is there any way of doing this - I've looked at back_log (the listen() backlog), but that doesnt really apply. Short of writing a 'hide-warning-wait-a-bit-and-try-again' chunk in PHP (sucky!) I'm stuck! Using persistent connections doesn't stunningly help either - it only gives a small performance increase. If it makes any odds, the SQL only talks to 3 tables, all are properly indexed and there's enough RAM to keep it all from swapping. Any help appreciated, thanks. - -- Shane http://www.shanewright.co.uk/ Public key: http://www.shanewright.co.uk/files/public_key.asc -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9Rosv5DXg6dCMBrQRAkMXAKCvGx8mYNEJoUPobtI093amT6RHAACcD3za xMUz0AP1fcMxJoZZdO0BixY= =zBoX -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
increase mysql max connections over 1024
Hello list, I'd like to increase the number of max connections above 1024 in Linux. I think I have to increase PTHREAD_THREADS_MAX in /usr/include/bits/local_lim.h /* The number of threads per process. */ #define _POSIX_THREAD_THREADS_MAX 64 /* This is the value this implementation supports. */ #define PTHREAD_THREADS_MAX 1024 My question is, what should I do after modify this file. Should I rebuild mysql-server .deb package again? Or I just set mysql max connections and restart mysql server? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php