Re: table_cache too high?
Yes, you are correct and it can be worse because you have not considered that there are some descriptors required by other processes running. I suggest you increase your file limit to at least 2048. Good luck Ken - Original Message - From: Lance Lovette [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 12:12 AM Subject: table_cache too high? My database has many hundreds of tables. Originally I set my table_cache to 512. Today I realize this might not be a good idea. By default open_files_limit is 0. According to my understanding of the manual this means each MySQL process will open at most 1124 file handles: max_connections + (table_cache * 2) = 100 + (512 * 2) = 1124 ulimit -n says the process file handle limit is 1024. Am I correct in assuming this configuration could potentially put the server in an unstable situation? Thanks! Lance - 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 - 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
Re: table_cache too high?
and how on-the-fly? Thomas On Wed, 20 Nov 2002 09:18:15 -0500 Ken Menzel [EMAIL PROTECTED] wrote: Yes, you are correct and it can be worse because you have not considered that there are some descriptors required by other processes running. I suggest you increase your file limit to at least 2048. Good luck Ken - Original Message - From: Lance Lovette [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 12:12 AM Subject: table_cache too high? My database has many hundreds of tables. Originally I set my table_cache to 512. Today I realize this might not be a good idea. By default open_files_limit is 0. According to my understanding of the manual this means each MySQL process will open at most 1124 file handles: max_connections + (table_cache * 2) = 100 + (512 * 2) = 1124 ulimit -n says the process file handle limit is 1024. Am I correct in assuming this configuration could potentially put the server in an unstable situation? Thanks! Lance - 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 - 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 - 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
Re: table_cache too high?
If you with Linux, you can use the 'sysctl' programm. sysctl -h gives you the parameters (i.e -u is for the maximum number of processes created by a user). I use the sysctl command in the safe_mysqld script to increase this number. if you want to set a parameter systemwide you may also use /etc/sysctl.conf. Regards, Philipp - Original Message - From: Thomas Seifert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 3:25 PM Subject: Re: table_cache too high? and how on-the-fly? Thomas On Wed, 20 Nov 2002 09:18:15 -0500 Ken Menzel [EMAIL PROTECTED] wrote: Yes, you are correct and it can be worse because you have not considered that there are some descriptors required by other processes running. I suggest you increase your file limit to at least 2048. Good luck Ken - Original Message - From: Lance Lovette [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 12:12 AM Subject: table_cache too high? My database has many hundreds of tables. Originally I set my table_cache to 512. Today I realize this might not be a good idea. By default open_files_limit is 0. According to my understanding of the manual this means each MySQL process will open at most 1124 file handles: max_connections + (table_cache * 2) = 100 + (512 * 2) = 1124 ulimit -n says the process file handle limit is 1024. Am I correct in assuming this configuration could potentially put the server in an unstable situation? Thanks! Lance - 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 - 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 - 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 - 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
Re: table_cache too high?
Hi Thomas, This would be a question for your OS support list, however an example from FreeBSD: bash-2.04$ sysctl -a | grep files kern.maxfiles: 2 kern.maxfilesperproc: 19000 kern.openfiles: 1569 bash-2.04$ su tuvok# sysctl kern.maxfiles=20001 kern.maxfiles: 2 - 20001 tuvok# Hope this helps, but it is off topic for this list. Ken - Original Message - From: Thomas Seifert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 9:25 AM Subject: Re: table_cache too high? and how on-the-fly? Thomas On Wed, 20 Nov 2002 09:18:15 -0500 Ken Menzel [EMAIL PROTECTED] wrote: Yes, you are correct and it can be worse because you have not considered that there are some descriptors required by other processes running. I suggest you increase your file limit to at least 2048. Good luck Ken - Original Message - From: Lance Lovette [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 12:12 AM Subject: table_cache too high? My database has many hundreds of tables. Originally I set my table_cache to 512. Today I realize this might not be a good idea. By default open_files_limit is 0. According to my understanding of the manual this means each MySQL process will open at most 1124 file handles: max_connections + (table_cache * 2) = 100 + (512 * 2) = 1124 ulimit -n says the process file handle limit is 1024. Am I correct in assuming this configuration could potentially put the server in an unstable situation? Thanks! Lance - 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 - 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 - 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 - 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
Re: table_cache too high?
thanks a lot for both replies. I just asked as this question was brought up with the post before mine. I will ask further off-list :-). Thomas On Wed, 20 Nov 2002 15:25:32 +0100 Thomas Seifert [EMAIL PROTECTED] wrote: and how on-the-fly? Thomas On Wed, 20 Nov 2002 09:18:15 -0500 Ken Menzel [EMAIL PROTECTED] wrote: Yes, you are correct and it can be worse because you have not considered that there are some descriptors required by other processes running. I suggest you increase your file limit to at least 2048. Good luck Ken - Original Message - From: Lance Lovette [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 12:12 AM Subject: table_cache too high? My database has many hundreds of tables. Originally I set my table_cache to 512. Today I realize this might not be a good idea. By default open_files_limit is 0. According to my understanding of the manual this means each MySQL process will open at most 1124 file handles: max_connections + (table_cache * 2) = 100 + (512 * 2) = 1124 ulimit -n says the process file handle limit is 1024. Am I correct in assuming this configuration could potentially put the server in an unstable situation? Thanks! Lance - 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 - 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 - 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 - 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