After just a short time it seems that MYSQL stops responding. Any website that is database driven stops operating until MYSQL is restarted either from the ISPConfig web interface or via rc.d scripts. I've been searching around and can't find anything that would be an issue. Logs don't tell me anything. I have a file, "/etc/my.cnf" that supposedly operates MYSQL. It's contents is as follows: ------------------------------------------- [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 # begin changes # key_buffer=48M max_allowed_packet=1M table_cache=400 sort_buffer=4M record_buffer=1M thread_cache=8 thread_concurrency=4 myisam_sort_buffer_size=32M max_connections=250 open_files_limit=750 long_query_time=4 # end changes # [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid ------------------------------------------- If you have any ideas on how to keep this frmo happening, I'd love to know. Thanks again. Where's the donate button???
Please check with: df -h if you have enough space on disk. You can also try to enable logging in mysql by adding the following line to my.cnf in the [mysqld] section and restart mysql: log = /var/log/mysql.log In this log you will find all queries. Maybe your server dies always at the same query.
I restarted mysql several times and it still isn't logging to that file. the logging of mysqld.log shows the following: 071025 23:22:01 mysqld started ^G/usr/libexec/mysqld: File '/var/log/mysql.log' not found (Errcode: 13) 071025 23:22:01 [ERROR] Could not use /var/log/mysql.log for logging (error 13). Turning logging off for the whole duration of$ 071025 23:22:01 InnoDB: Started; log sequence number 0 169982574 /usr/libexec/mysqld: ready for connections. Version: '4.1.20-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution dingle@its:/etc/rc.d/init.d# cat /var/log/mysql.log dingle@its:/etc/rc.d/init.d# ls -lh /var/log/mysql.log -rw-r--r-- 1 root root 0 Oct 25 12:37 /var/log/mysql.log dingle@its:/etc/rc.d/init.d#
