Database stops responding

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Lior M

    Database stops responding

    Hello everyone

    I'm having a little problem where my mysql 4.0.21 for some reason
    stops "responding " until I do a flush-hosts. This is happening almost
    every day.
    It's a pretty heavy loaded server with at aprox 130 querys per second
    (it might not be that loaded for some of you :) ).

    I'm using the my-huge.cnf config, and allowing 350 max-connections.

    Actually, here's the config:

    [mysqld]
    port = 4306
    datadir = /usr/local/mysql-4/var
    basedir = /usr/local/mysql-4
    socket = /tmp/mysql-4.sock
    skip-locking
    set-variable = key_buffer=256M
    set-variable = max_allowed_pac ket=1M
    set-variable = table_cache=256
    set-variable = sort_buffer=1M
    set-variable = record_buffer=1 M
    set-variable = myisam_sort_buf fer_size=64M
    set-variable = thread_cache=8
    set-variable = max_connections =666666
    set-variable = max_user_connec tions=66666

    # Try number of CPU's*2 for thread_concurre ncy
    set-variable = thread_concurre ncy=8
    log-bin
    server-id = 1

    [isamchk]
    set-variable = key_buffer=128M
    set-variable = sort_buffer=128 M
    set-variable = read_buffer=2M
    set-variable = write_buffer=2M

    [myisamchk]
    set-variable = key_buffer=128M
    set-variable = sort_buffer=128 M
    set-variable = read_buffer=2M
    set-variable = write_buffer=2M

    [mysqlhotcopy]
    interactive-timeout

    If anyone knows what could be done to stop having to use the
    flush-hosts every day, I'd appreciate the hint.

    Thanks!

    Lior
Working...