Hello! I have installed OpenBSD 3.8 and MySQL server 4.0.24 (from ports)
From time to time (after high load) I got next - mysql drops connects
by TCP/IP (simple connection closed after telnet to port 3306) and next in logs: Few lines like 060620 14:51:06 [ERROR] /usr/local/libexec/mysqld: Can't find file: './tasktrack er/mantis_news_table.frm' (errno: 9)
then, after I send HUP signal to mysqld process, I got next in error output: Status information: Current dir: /var/mysql/ Running threads: 2 Stack size: 196608 Current locks: lock: 0x7ee75a24: lock: 0x8bab9a24: Then also a lot of locks (about 100 total locks listen) and, finally, log ends width: Key caches: default Buffer_size: 268435456 Block_size: 1024 Division_limit: 100 Age_limit: 300 blocks used: 9524 not flushed: 0 w_requests: 3798 writes: 1898 r_requests: 346940 reads: 2035 handler status: read_key: 371358 read_next: 488795 read_rnd 14869 read_first: 2385 write: 34562 delete 341 update: 242660 Table status: Opened tables: 334 Open tables: 334 Open files: 664 Open streams: 0 Alarm status: Active alarms: 2 Max used alarms: 61 Next alarm time: 28780 # cat /etc/sysctl.conf | grep -v "^#" kern.maxfiles=20000 #cat /etc/my.cnf |grep -v "^#" [client] port = 3306 socket = /tmp/mysql.sock [mysqld] user = _mysql open-files=20000 set-variable = max_connections=300 set-variable = back_log=120 skip-locking set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = sort_buffer=1M set-variable = record_buffer=1M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 set-variable = thread_concurrency=2 log_slow_queries = slow_query.log tmpdir = /tmp/ datadir = /var/mysql [mysqldump] quick set-variable = max_allowed_packet=16M [isamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout Where is my error in configuration? I tired to download and install fresh stable mysql-4 brach but I got same result. -- Thank you. Vladimir. Y. Plotnikov, http://www.smartwebco.com/
