mysql stops responding

Discussion in 'General' started by crypted, Oct 25, 2007.

  1. crypted

    crypted New Member

    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???
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  3. crypted

    crypted New Member

    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#
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Please run:

    chown mysql /var/log/mysql.log

    and then try to restart mysql again.
     

Share This Page