mysql stops responding
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???
|
Recent comments
9 hours 43 min ago
19 hours 11 min ago
20 hours 1 min ago
23 hours 34 min ago
1 day 3 hours ago
1 day 4 hours ago
1 day 6 hours ago
1 day 16 hours ago
1 day 21 hours ago
1 day 22 hours ago