Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

mysql out of memory when php is mod fastcgi

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

  1. cosmin

    cosmin Well-Known Member

    Joined:
    Feb 6, 2002
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    316
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice