Just wanted to add: it always loses connection when uptime=180 it restarts every 180 seconds?? the uptime count starts again at 0, so does the query count. >>Hello All, >> >>I frequently get this error message. >>Seems it has to do with number of open tables bigger than 10?? >>Do I have a bad setup?? please verify my setup file at the end. I think I >>exaggerated the memory, it only uses 4 Megabytes anyway. bash-2.01$ mysqladmin -i 5 status Uptime: 174 Threads: 1 Questions: 821 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 10 Uptime: 179 Threads: 1 Questions: 846 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 10 Lost connection to MySQL server during query Uptime: 9 Threads: 1 Questions: 59 Slow queries: 0 Opens: 11 Flush tables: 1 Open tables: 7 Uptime: 14 Threads: 1 Questions: 59 Slow queries: 0 Opens: 11 Flush tables: 1 Open tables: 7 Uptime: 19 Threads: 1 Questions: 104 Slow queries: 0 Opens: 11 Flush tables: 1 Open tables: 7 Uptime: 24 Threads: 1 Questions: 104 Slow queries: 0 Opens: 11 Flush tables: 1 Open tables: 7 Uptime: 29 Threads: 2 Questions: 122 Slow queries: 0 Opens: 11 Flush tables: 1 Open tables: 7 Uptime: 34 Threads: 1 Questions: 130 Slow queries: 0 Opens: 11 Flush tables: 1 Open tables: 7 Uptime: 39 Threads: 1 Questions: 152 Slow queries: 0 Opens: 11 Flush tables: 1 Open tables: 7 Uptime: 44 Threads: 1 Questions: 182 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 49 Threads: 1 Questions: 182 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 54 Threads: 1 Questions: 182 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 60 Threads: 2 Questions: 203 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 65 Threads: 1 Questions: 236 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 70 Threads: 1 Questions: 236 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 75 Threads: 1 Questions: 267 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 80 Threads: 1 Questions: 277 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 85 Threads: 2 Questions: 280 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 90 Threads: 2 Questions: 393 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 95 Threads: 2 Questions: 450 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 100 Threads: 1 Questions: 462 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 105 Threads: 2 Questions: 470 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 110 Threads: 1 Questions: 495 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 115 Threads: 1 Questions: 531 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 120 Threads: 1 Questions: 531 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 125 Threads: 1 Questions: 558 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 130 Threads: 2 Questions: 592 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 135 Threads: 3 Questions: 712 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 8 Uptime: 140 Threads: 4 Questions: 896 Slow queries: 0 Opens: 13 Flush tables: 1 Open tables: 9 Uptime: 146 Threads: 3 Questions: 1037 Slow queries: 0 Opens: 13 Flush tables: 1 Open tables: 9 Uptime: 151 Threads: 4 Questions: 1130 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 10 Uptime: 156 Threads: 4 Questions: 1266 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 10 Uptime: 161 Threads: 3 Questions: 1418 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 10 Uptime: 166 Threads: 2 Questions: 1475 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 10 Uptime: 171 Threads: 1 Questions: 1485 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 10 Uptime: 176 Threads: 1 Questions: 1509 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 10 Lost connection to MySQL server during query Uptime: 6 Threads: 1 Questions: 13 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 6 Uptime: 11 Threads: 1 Questions: 34 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 6 Uptime: 16 Threads: 1 Questions: 34 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 6 Uptime: 22 Threads: 2 Questions: 44 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 6 Uptime: 27 Threads: 1 Questions: 59 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 6 Uptime: 32 Threads: 1 Questions: 71 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 6 Uptime: 37 Threads: 1 Questions: 82 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 6 Uptime: 42 Threads: 1 Questions: 82 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 6 Uptime: 47 Threads: 1 Questions: 117 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 6 bash-2.01$ cat /etc/my.cnf # One can use all long options that the program supports. # Run the program with --help to get a list of available options # The MySQL server [mysqld] user = mysql port = 3306 socket = /tmp/mysql.sock set-variable = max_connections=30 set-variable = max_connect_errors=100 set-variable = back_log=128 set-variable = max_allowed_packet=1024k set-variable = table_cache=256 set-variable = wait_timeout=600 set-variable = key_buffer=96000k set-variable = long_query_time=10 set-variable = record_buffer=1M set-variable = sort_buffer=12M # set-variable = tmp_table_size =12M enable-locking big-tables log = /usr/local/var/logs/access_log Mike(mickalo)Blezien ======================================== Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 ========================================= --------------------------------------------------------------------- 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