I _need_ help with this connections-to-mysql issue. Until I changed a few stuff in the MySQL setup, I kept getting the "Too many connections" message when connecting. After increasing both max_connections and table_cache, I get the error: Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in db.php on line 15 Like... It's bissare! Something must be wrong with the threads on my system or something. I'm running RedHat 7.0 on a machine with 512 MB RAM and 1 ghz CPU, the memory is heaps free and the # of connections bareley passes a 100. Am running PHP 4.0.4 with persistant connections btw. Also I'm running glibc-2.1.92. Here's a few lines from mysqladmin: ---variables--- key_buffer_size 67104768 max_connections 300 sort_buffer 1048568 table_cache 512 thread_stack 65536 thread_cache_size 8 version 3.23.27-beta-log wait_timeout 120 ---extended-status--- Aborted_clients 1253 Bytes_received 12926501 Bytes_sent 439847544 Connections 3082 Key_read_requests 24690507 Key_reads 4379 Key_write_requests 1580553 Key_writes 17031 Max_used_connections 112 Open_tables 72 Open_files 91 Open_streams 1 Opened_tables 109 Questions 112882 Slow_launch_threads 1 Slow_queries 3 Threads_cached 7 Threads_connected 39 Threads_running 5 Uptime 9733 ---version--- Uptime: 2 hours 45 min 55 sec Queries per second avg: 11.665 I can post much much more if you want but I think this might be enough now. Does someone have any idea of what could be wrong? I really really need help with this! (And yes, I have read the manual. Many times. Nothing there seem to help me tough...) --- Johan Björk --------------------------------------------------------------------- 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
