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