GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Memory Problem - server always crashes.

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Memory Problem - server always crashes.

    I have a virtual dedicated server with 512MB RAM and 2GB Bursted RAM.

    When my website gets busy, the server crashes and I have to restart the server to get my site back online. However, this is only temporary and happens again every few hours.

    I contacted my host's support department who said it was a memory problem. I checked the "top" command in SSH, and saw that mysql was using the most memory.

    I think it maybe something to do with my my.cnf file configuration. Can someone please take a look: This is the file.

    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    max_connections=700
    max_user_connections=500
    interactive_timeout=20
    wait_timeout=20
    connect_timeout=6
    thread_cache_size=128
    key_buffer=16M
    join_buffer=1M
    max_allowed_packet=64M
    table_cache=1024
    record_buffer=1M
    sort_buffer_size=2M
    read_buffer_size=2M
    max_connect_errors=1000
    # Try number of CPU's*2 for thread_concurrency
    thread_concurrency=4
    myisam_sort_buffer_size=64M
    #log-bin
    server-id=1

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/lib/mysql/mysql.pid
    open_files_limit=8192

    [mysqldump]
    quick
    max_allowed_packet=16M

    [mysql]
    no-auto-rehash
    #safe-updates

    [isamchk]
    key_buffer=32M
    sort_buffer=32M
    read_buffer=16M
    write_buffer=16M

    [myisamchk]
    key_buffer=32M
    sort_buffer=32M
    read_buffer=16M
    write_buffer=16M

    Any help will be greatly appreciated.

    Thanks

  • #2
    I don't see anything wrong with your config. It might be the queries you are running.

    Comment

    Working...
    X