mysql out of memory when php is mod fastcgi

cosmin

• October 14, 2015 01:49

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:
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" Status Out of Memory ? Memory Information Used 6.93 GB Available 8.55 GB Installed 15.48 GB Load Information 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!

• 

  cPanelMichael

  • October 14, 2015 16:01

  Hello :) Have you considered using Mod_Ruid2 with DSO instead of FCGI? There's a thread here where the performance differences are discussed: My experience, suExec + FastCGI + opcache VS mod_ruid2 + DSO + opcache Thank you.

  0

Please sign in to leave a comment.