Hi, I'm trying mysql installation, but mysqld crash during two hours from one hour. Do you have any hint and ideas?
(Loging File...) 080126 17:09:37 mysqld started 080126 17:09:37 InnoDB: Started; log sequence number 0 3594127 080126 17:09:37 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.33-log' socket: '/var/run/mysql/mysql.sock' port: 3306 OpenBSD port: mysql-server-5.0.33 080126 18:11:42 [ERROR] Error in accept: Bad file descriptor (I tried setting) changed kern.maxfiles and kern.maxvnodes => 16383 => 32767 => 65535 changed open_files_limit => 1024 => 2048 => 65535 changed max_connections => 512 => 256 (Envilonment) Intel(R) Xeon(R) CPU 5148 @ 2.33GHz Memory 2GB OpenBSD-4.1 stable Apache (OpenBSD bundled) PHP 5.1.6p2(Ports:make install) MySQL 5.0.33(Ports:make install) (kernel) GENERIC.MP (sysctl) kern.maxclusters=32768 kern.maxproc=10240 kern.maxfiles=65535 kern.maxvnodes=65535 kern.seminfo.semmns=2048 kern.seminfo.semmni=512 kern.seminfo.semmnu=1024 kern.shminfo.shmall=32768 kern.shminfo.shmmni=512 (my.cnf) max_connections = 256 open_files_limit = 65535 key_buffer = 64M max_allowed_packet = 1M table_cache = 1024 sort_buffer_size = 1M net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M innodb_data_home_dir = /var/mysql/ innodb_data_file_path = ibdata1:100M:autoextend innodb_log_group_home_dir = /var/mysql/ innodb_log_arch_dir = /var/mysql/ innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 8M innodb_log_file_size = 64M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50
