The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql out of memory when php is mod fastcgi

Discussion in 'Database Discussions' started by cosmin, Oct 14, 2015.

  1. cosmin

    cosmin Well-Known Member

    Joined:
    Feb 6, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bucuresti
    I switch a server from suPHP to fcgi and mysql crash frequently. I switch back to suPHP and everything is OK.
    My server have dual Xeon E5640, 16GB RAM, raid controller. When mysql crash I receive from cPanel monitoring:

    Code:
    Out of memory: The process “mysqld” was terminated because the system is low on memory.
    [33436.701806] Out of memory: OOM killed process 281539 (mysqld) score 0 vm:2995072kB, rss:293452kB, swap:0kB"
    [B]
    Status[/B] Out of Memory ⚠
    [B]Memory Information[/B]
    Used 6.93 GB
    Available 8.55 GB
    Installed 15.48 GB
    [B]Load Information[/B] 2.24 1.82 1.54
    
    my.cnf:
    [mysqld_safe]
    pid-file="/var/run/mysqld/mysqld.pid"
    log-error="/var/lib/mysql/mysqld.log"
    
    [mysqld]
    innodb_buffer_pool_size=134217728
    open_files_limit=50000
    max_allowed_packet=1073741824
    thread_cache_size=4
    thread_cache=16
    wait_timeout=10
    
    join_buffer_size=8M
    max_connections=250
    interactive_timeout=10
    
    table_open_cache=64
    
    tmpdir="/home/_mysqltmp"
    thread_concurrency=4
    max_heap_table_size=256M
    tmp_table_size=256M
    key_buffer_size=256M
    low_priority_updates=1
    #socket="/var/lib/mysql/mysql.sock"
    
    query_cache_type=1
    query_cache_size=128M
    
    default-storage-engine=MyISAM
    innodb_file_per_table=1
    
    
    Any ideea how can I switch to fcgi again without this problem?

    Many thanks!
     
    #1 cosmin, Oct 14, 2015
    Last edited: Oct 14, 2015
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page