{"id":1981,"date":"2022-08-30T15:21:03","date_gmt":"2022-08-30T15:21:03","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/12\/08\/magento-nginx-php-fpm-apc-memcached-16gb-ram-centos-spiking-php-fpm-to-100-cpu-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:21:03","modified_gmt":"2022-08-30T15:21:03","slug":"magento-nginx-php-fpm-apc-memcached-16gb-ram-centos-spiking-php-fpm-to-100-cpu-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/magento-nginx-php-fpm-apc-memcached-16gb-ram-centos-spiking-php-fpm-to-100-cpu-collection-of-common-programming-errors\/","title":{"rendered":"Magento, NGINX, PHP-FPM, APC, MEMCACHED, 16gb Ram CentOS, Spiking PHP-FPM to 100% CPU-Collection of common programming errors"},"content":{"rendered":"

I have been trying to resolve my issue of spiking cpu caused by php-fpm processes. I’ve reduced the php-fpm config settings to:<\/p>\n

pm = ondemand\npm.max_children = 12\npm.start_servers = 2\npm.min_spare_servers = 2\npm.max_spare_servers = 10\npm.max_requests = 500\nphp_admin_value[memory_limit] = 128M\n<\/code><\/pre>\n
Problem still exists. I’m running a Joomla main site (which is having no problems) and a Magento store in a sub-directory. My server is a Linux CentOS, running NGINX, APC, Memcached, Full Page Cache and php-fpm. My server has 8 cores and 16gb dedicated ram. My host has shut down my server several times the past week because my php-fpm processes are consuming the entire network. A lot of the individual php-fpm processes are getting over 50% cpu. I’ve hired several “professionals” and none of them was able to help me, so now broke and stumped, I’m turning to you guys for help. So any suggestions would be greatly appreciated. I turned on slow php logs and here are some of the latest results:<\/p>\n
[01-Apr-2012 14:26:12]  [pool magento] pid 21537\nscript_filename = \/home\/flyfish\/www\/flyshop\/index.php\n[0x0000000011a394f8] _renderStraightjoin() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Select.php:397\n[0x0000000011a39158] _renderStraightjoin() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Select.php:705\n[0x0000000011a38f30] assemble() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Select.php:1343\n[0x00007fffbb6d6e50] __toString() unknown:0\n[0x0000000011a38630] _prepareQuery() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Adapter\/Pdo\/Mysql.php:409\n[0x0000000011a38270] _prepareQuery() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Adapter\/Pdo\/Mysql.php:388\n[0x0000000011a38008] query() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Abstract.php:734\n[0x0000000011a375c8] fetchAll() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Product\/Type\/Configurable\/Attribute\/Collection.php:196\n[0x0000000011a370e0] _loadLabels() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Product\/Type\/Configurable\/Attribute\/Collection.php:129\n[0x0000000011a369a0] _afterLoad() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Data\/Collection\/Db.php:536\n[0x0000000011a364a8] load() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product\/Type\/Configurable.php:253\n[0x0000000011a35968] getConfigurableAttributes() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product\/Type\/Configurable.php:330\n[0x0000000011a35590] getUsedProducts() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product\/Type\/Configurable.php:458\n[0x0000000011a35410] isSalable() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product.php:1264\n[0x0000000011a35098] isAvailable() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product.php:1244\n[0x0000000011a34fa8] isSalable() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product.php:1308\n[0x0000000011a33998] isSaleable() \/home\/flyfish\/www\/flyshop\/app\/design\/frontend\/moxy\/default\/template\/rokmagemodules\/rokmage-categoryview\/rokmage-categoryview.phtml:122\n[0x0000000011a331f0] +++ dump failed\n\n[01-Apr-2012 14:26:44]  [pool magento] pid 21531\nscript_filename = \/home\/flyfish\/www\/flyshop\/index.php\n[0x0000000011a37768] _loadPrices() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Product\/Type\/Configurable\/Attribute\/Collection.php:251\n[0x0000000011a37280] _loadPrices() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Product\/Type\/Configurable\/Attribute\/Collection.php:132\n[0x0000000011a36b40] _afterLoad() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Data\/Collection\/Db.php:536\n[0x0000000011a36648] load() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product\/Type\/Configurable.php:253\n[0x0000000011a35b08] getConfigurableAttributes() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product\/Type\/Configurable.php:330\n[0x0000000011a35730] getUsedProducts() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product\/Type\/Configurable.php:458\n[0x0000000011a355b0] isSalable() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product.php:1264\n[0x0000000011a35238] isAvailable() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product.php:1244\n[0x0000000011a35148] isSalable() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product.php:1308\n[0x0000000011a33b38] isSaleable() \/home\/flyfish\/www\/flyshop\/app\/design\/frontend\/moxy\/default\/template\/rokmagemodules\/rokmage-categoryview\/rokmage-categoryview.phtml:122\n[0x0000000011a33390] +++ dump failed\n\n[01-Apr-2012 14:27:01]  [pool magento] pid 21528\nscript_filename = \/home\/flyfish\/www\/flyshop\/index.php\n[0x0000000011ff67a8] execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Statement\/Pdo.php:228\n[0x0000000011ff6518] _execute() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Statement\/Pdo\/Mysql.php:110\n[0x0000000011ff5e90] _execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Statement.php:300\n[0x0000000011ff5a20] execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Abstract.php:479\n[0x0000000011ff5438] query() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Pdo\/Abstract.php:238\n[0x0000000011ff5078] query() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Adapter\/Pdo\/Mysql.php:389\n[0x0000000011ff4e98] query() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Abstract.php:825\n[0x0000000011ff4948] fetchOne() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Category\/Flat.php:1161\n[0x0000000011ff4678] getProductCount() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Category.php:801\n[0x0000000011ff33e0] getProductCount() \/home\/flyfish\/www\/flyshop\/app\/code\/local\/Extendware\/EWLayeredNav\/Model\/Library\/Plugin\/Catalog\/Layer\/Filter\/Category.php:54\n[0x0000000011ff2da0] _initItemsData() \/home\/flyfish\/www\/flyshop\/app\/code\/local\/Extendware\/EWLayeredNav\/Model\/Library\/Plugin\/Catalog\/Layer\/Filter\/Category.php:23\n[0x0000000011ff2818] _getItemsData() \/home\/flyfish\/www\/flyshop\/app\/code\/local\/Extendware\/EWLayeredNav\/Model\/Library\/Plugin\/Catalog\/Layer\/Filter\/Category.php:119\n[0x0000000011ff26b0] _initItems() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Layer\/Filter\/Abstract.php:120\n[0x0000000011ff2598] getItems() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Layer\/Filter\/Abstract.php:109\n[0x0000000011ff2480] getItemsCount() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Block\/Layer\/Filter\/Abstract.php:126\n[0x0000000011ff22b8] getItemsCount() \/home\/flyfish\/www\/flyshop\/var\/cache\/extendware\/ewcore\/overrides\/Mage\/Catalog\/Block\/Layer\/View\/67dcc5dfa9c44bd3a205b75a08193105.php:218\n[0x0000000011ff2088] canShowOptions() \/home\/flyfish\/www\/flyshop\/var\/cache\/extendware\/ewcore\/overrides\/Mage\/Catalog\/Block\/Layer\/View\/67dcc5dfa9c44bd3a205b75a08193105.php:233\n[0x0000000011ff14f8] canShowBlock() \/home\/flyfish\/www\/flyshop\/app\/design\/frontend\/moxy\/default\/template\/extendware\/ewlayerednav\/catalog\/layer\/view.phtml:6\n[0x0000000011ff0d50] +++ dump failed\n\n[01-Apr-2012 14:27:04]  [pool magento] pid 21529\nscript_filename = \/home\/flyfish\/www\/flyshop\/index.php\n[0x0000000012468ff8] execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Statement\/Pdo.php:228\n[0x0000000012468d68] _execute() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Statement\/Pdo\/Mysql.php:110\n[0x00000000124686e0] _execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Statement.php:300\n[0x0000000012468270] execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Abstract.php:479\n[0x0000000012467c88] query() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Pdo\/Abstract.php:238\n[0x00000000124678c8] query() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Adapter\/Pdo\/Mysql.php:389\n[0x0000000012467660] query() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Abstract.php:734\n[0x0000000012467248] fetchAll() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Data\/Collection\/Db.php:687\n[0x00000000124668f0] _fetchAll() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Eav\/Model\/Entity\/Collection\/Abstract.php:1045\n[0x0000000012466288] _loadEntities() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Eav\/Model\/Entity\/Collection\/Abstract.php:869\n[0x0000000012465fb0] load() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Review\/Model\/Observer.php:78\n[0x0000000012465d10] catalogBlockProductCollectionBeforeToHtml() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Core\/Model\/App.php:1303\n[0x0000000012464c28] _callObserverMethod() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Core\/Model\/App.php:1278\n[0x00000000124649e0] dispatchEvent() \/home\/flyfish\/www\/flyshop\/app\/Mage.php:416\n[0x0000000012464290] dispatchEvent() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Block\/Product\/List.php:163\n[0x0000000012463760] _beforeToHtml() \/home\/flyfish\/www\/flyshop\/var\/ait_rewrite\/6bfe16ca572eea47db567910902c6209.php:864\n[0x00000000124633b0] toHtml() \/home\/flyfish\/www\/flyshop\/var\/ait_rewrite\/6bfe16ca572eea47db567910902c6209.php:584\n[0x0000000012462e30] _getChildHtml() \/home\/flyfish\/www\/flyshop\/var\/ait_rewrite\/6bfe16ca572eea47db567910902c6209.php:528\n[0x0000000012462d38] getChildHtml() \/home\/flyfish\/www\/flyshop\/var\/cache\/extendware\/ewcore\/overrides\/Mage\/Catalog\/Block\/Category\/View\/6362e7526f5dcb27e7f8b0b414b59004.php:85\n[0x00000000124629f0] getProductListHtml() \/home\/flyfish\/www\/flyshop\/app\/code\/local\/Extendware\/EWLayeredNav\/Block\/Override\/Mage\/Catalog\/Category\/View.php:20\n\n[01-Apr-2012 14:27:55]  [pool magento] pid 21536\nscript_filename = \/home\/flyfish\/www\/flyshop\/index.php\n[0x0000000011a35010] execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Statement\/Pdo.php:228\n[0x0000000011a34d80] _execute() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Statement\/Pdo\/Mysql.php:110\n[0x0000000011a346f8] _execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Statement.php:300\n[0x0000000011a34288] execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Abstract.php:479\n[0x0000000011a33ca0] query() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Pdo\/Abstract.php:238\n[0x0000000011a338e0] query() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Adapter\/Pdo\/Mysql.php:389\n[0x0000000011a33700] query() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Abstract.php:825\n[0x0000000011a33368] fetchOne() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Eav\/Model\/Resource\/Entity\/Type.php:71\n[0x0000000011a33238] getAdditionalAttributeTable() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Eav\/Model\/Resource\/Entity\/Attribute.php:483\n[0x0000000011a32be8] getAdditionalAttributeTable() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Eav\/Model\/Resource\/Entity\/Attribute.php:500\n[0x0000000011a32860] _afterLoad() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Eav\/Model\/Resource\/Entity\/Attribute.php:108\n[0x0000000011a32330] loadByCode() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Eav\/Model\/Entity\/Attribute\/Abstract.php:118\n[0x0000000011a31350] loadByCode() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Eav\/Model\/Config.php:423\n[0x0000000011a30ce8] getAttribute() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Helper\/Output.php:156\n[0x0000000011a30208] categoryAttribute() \/home\/flyfish\/www\/flyshop\/app\/design\/frontend\/base\/default\/template\/catalog\/category\/view.phtml:47\n[0x0000000011a2fa60] +++ dump failed\n\n[01-Apr-2012 14:27:56]  [pool magento] pid 21530\nscript_filename = \/home\/flyfish\/www\/flyshop\/index.php\n[0x0000000011a35b10] updateParamDefaults() \/home\/flyfish\/www\/flyshop\/var\/ait_rewrite\/78778b0d1ad4bf93e846365bd2fbf33f.php:276\n[0x0000000011a35750] updateParamDefaults() \/home\/flyfish\/www\/flyshop\/var\/ait_rewrite\/78778b0d1ad4bf93e846365bd2fbf33f.php:326\n[0x0000000011a351f0] getSkinBaseUrl() \/home\/flyfish\/www\/flyshop\/var\/ait_rewrite\/78778b0d1ad4bf93e846365bd2fbf33f.php:482\n[0x0000000011a350a8] getSkinUrl() \/home\/flyfish\/www\/flyshop\/var\/ait_rewrite\/6bfe16ca572eea47db567910902c6209.php:981\n[0x0000000011a32468] getSkinUrl() \/home\/flyfish\/www\/flyshop\/app\/code\/local\/Extendware\/EWMinify\/Block\/Override\/Mage\/Page\/Html\/Head.php:126\n[0x0000000011a30ca8] getCssJsHtml() \/home\/flyfish\/www\/flyshop\/app\/code\/local\/Extendware\/EWCore\/Block\/Override\/Mage\/Page\/Html\/Head.php:55\n[0x0000000011a30978] getCssJsHtml() \/home\/flyfish\/www\/flyshop\/app\/code\/local\/MageWorx\/SeoSuite\/Block\/Page\/Html\/Head.php:41\n[0x0000000011a2fd10] getCssJsHtml() \/home\/flyfish\/www\/flyshop\/app\/design\/frontend\/moxy\/default\/template\/rokmagemodules\/rokmage-modalheader\/rokmage-head.phtml:26\n[0x0000000011a2f568] +++ dump failed\n\n[01-Apr-2012 14:28:28]  [pool magento] pid 21527\nscript_filename = \/home\/flyfish\/www\/flyshop\/index.php\n[0x0000000010c7bba0] execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Statement\/Pdo.php:228\n[0x0000000010c7b910] _execute() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Statement\/Pdo\/Mysql.php:110\n[0x0000000010c7b288] _execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Statement.php:300\n[0x0000000010c7ae18] execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Abstract.php:479\n[0x0000000010c7a830] query() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Pdo\/Abstract.php:238\n[0x0000000010c7a470] query() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Adapter\/Pdo\/Mysql.php:389\n[0x0000000010c7a168] query() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Abstract.php:808\n[0x0000000010c79558] fetchPairs() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Product\/Collection.php:840\n[0x0000000010c79240] addCountToCategories() \/home\/flyfish\/www\/flyshop\/app\/code\/community\/Mage\/Catalog\/Block\/Navigation.php:133\n[0x0000000010c71d48] getCurrentChildCategories() \/home\/flyfish\/www\/flyshop\/app\/design\/frontend\/base\/default\/template\/rokmagemodules\/rokmage-magemenus\/rokmage-magemenu-left.phtml:139\n[0x0000000010c715a0] +++ dump failed\n\n[01-Apr-2012 14:28:28]  [pool magento] pid 21577\nscript_filename = \/home\/flyfish\/www\/flyshop\/index.php\n[0x0000000011a3a8d8] execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Statement\/Pdo.php:228\n[0x0000000011a3a648] _execute() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Statement\/Pdo\/Mysql.php:110\n[0x0000000011a39fc0] _execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Statement.php:300\n[0x0000000011a39b50] execute() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Abstract.php:479\n[0x0000000011a39568] query() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Pdo\/Abstract.php:238\n[0x0000000011a391a8] query() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Db\/Adapter\/Pdo\/Mysql.php:389\n[0x0000000011a38f40] query() \/home\/flyfish\/www\/flyshop\/lib\/Zend\/Db\/Adapter\/Abstract.php:734\n[0x0000000011a37cc0] fetchAll() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Category\/Flat.php:276\n[0x0000000011a37b20] _loadNodes() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Category\/Flat.php:1229\n[0x0000000011a379a0] getChildrenCategories() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Category.php:841\n[0x0000000011a37690] getChildrenCategories() \/home\/flyfish\/www\/flyshop\/app\/code\/community\/Mage\/Catalog\/Block\/Navigation.php:130\n[0x0000000011a30198] getCurrentChildCategories() \/home\/flyfish\/www\/flyshop\/app\/design\/frontend\/base\/default\/template\/rokmagemodules\/rokmage-magemenus\/rokmage-magemenu-left.phtml:139\n[0x0000000011a2f9f0] +++ dump failed\n\n[01-Apr-2012 14:28:48]  [pool magento] pid 21629\nscript_filename = \/home\/flyfish\/www\/flyshop\/index.php\n[0x00002ac987e2cb48] _loadPrices() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Product\/Type\/Configurable\/Attribute\/Collection.php:252\n[0x00002ac987e2c660] _loadPrices() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Resource\/Product\/Type\/Configurable\/Attribute\/Collection.php:132\n[0x00002ac987e2bf20] _afterLoad() \/home\/flyfish\/www\/flyshop\/lib\/Varien\/Data\/Collection\/Db.php:536\n[0x00002ac987e2ba28] load() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product\/Type\/Configurable.php:253\n[0x00002ac987e2aee8] getConfigurableAttributes() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product\/Type\/Configurable.php:330\n[0x00002ac987e2ab10] getUsedProducts() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product\/Type\/Configurable.php:458\n[0x00002ac987e2a990] isSalable() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product.php:1264\n[0x00002ac987e2a618] isAvailable() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product.php:1244\n[0x00002ac987e2a528] isSalable() \/home\/flyfish\/www\/flyshop\/app\/code\/core\/Mage\/Catalog\/Model\/Product.php:1308\n[0x00002ac987e28f18] isSaleable() \/home\/flyfish\/www\/flyshop\/app\/design\/frontend\/moxy\/default\/template\/rokmagemodules\/rokmage-categoryview\/rokmage-categoryview.phtml:122\n[0x00002ac987e28770] +++ dump failed\n___________________________________________\n\nA snippet of the Latest php-fpm error log:\n[01-Apr-2012 14:26:12] WARNING: [pool magento] child 21537, script '\/home\/flyfish\/www\/flyshop\/index.php' (request: \"GET \/flyshop\/index.php\") executing too slow (5.265105 sec), logging\n[01-Apr-2012 14:26:12] ERROR: failed to ptrace(PEEKDATA) pid 21537: Input\/output error (5)\n[01-Apr-2012 14:26:44] WARNING: [pool magento] child 21531, script '\/home\/flyfish\/www\/flyshop\/index.php' (request: \"GET \/flyshop\/index.php\") executing too slow (5.268434 sec), logging\n[01-Apr-2012 14:26:44] ERROR: failed to ptrace(PEEKDATA) pid 21531: Input\/output error (5)\n[01-Apr-2012 14:27:01] WARNING: [pool magento] child 21528, script '\/home\/flyfish\/www\/flyshop\/index.php' (request: \"GET \/flyshop\/index.php\") executing too slow (6.656633 sec), logging\n[01-Apr-2012 14:27:01] ERROR: failed to ptrace(PEEKDATA) pid 21528: Input\/output error (5)\n[01-Apr-2012 14:27:04] WARNING: [pool magento] child 21529, script '\/home\/flyfish\/www\/flyshop\/index.php' (request: \"GET \/flyshop\/index.php\") executing too slow (5.211136 sec), logging\n[01-Apr-2012 14:27:55] WARNING: [pool magento] child 21536, script '\/home\/flyfish\/www\/flyshop\/index.php' (request: \"GET \/flyshop\/index.php\") executing too slow (5.207001 sec), logging\n[01-Apr-2012 14:27:55] ERROR: failed to ptrace(PEEKDATA) pid 21536: Input\/output error (5)\n[01-Apr-2012 14:27:56] WARNING: [pool magento] child 21530, script '\/home\/flyfish\/www\/flyshop\/index.php' (request: \"GET \/flyshop\/index.php\") executing too slow (5.503186 sec), logging\n[01-Apr-2012 14:27:56] ERROR: failed to ptrace(PEEKDATA) pid 21530: Input\/output error (5)\n[01-Apr-2012 14:28:28] WARNING: [pool magento] child 21577, script '\/home\/flyfish\/www\/flyshop\/index.php' (request: \"GET \/flyshop\/index.php\") executing too slow (5.722625 sec), logging\n[01-Apr-2012 14:28:28] WARNING: [pool magento] child 21527, script '\/home\/flyfish\/www\/flyshop\/index.php' (request: \"GET \/flyshop\/index.php\") executing too slow (5.122326 sec), logging\n[01-Apr-2012 14:28:28] ERROR: failed to ptrace(PEEKDATA) pid 21527: Input\/output error (5)\n[01-Apr-2012 14:28:28] ERROR: failed to ptrace(PEEKDATA) pid 21577: Input\/output error (5)\n[01-Apr-2012 14:28:48] WARNING: [pool magento] child 21629, script '\/home\/flyfish\/www\/flyshop\/index.php' (request: \"GET \/flyshop\/index.php\") executing too slow (5.446961 sec), logging\n[01-Apr-2012 14:28:48] ERROR: failed to ptrace(PEEKDATA) pid 21629: Input\/output error (5)\n_____________________________________________\n<\/code><\/pre>\n
I also noticed that the server is not using much memory:<\/p>\n
Mem:  16777216k total,  1204040k used, 15573176k free\n<\/code><\/pre>\n
My.conf settings:<\/p>\n
query_cache_size = 128M\ninnodb_buffer_pool_size = 512M\nopen-files-limit = 8192\ntable_cache=4096\n<\/code><\/pre>\n
I just noticed that someone changed my innodb_buffer_pool_size to 512M. Shouldn’t this be set to 80% of available ram? So I have 16gb ram so it should be set at 12G; however, I set it at 10G. What do you think? I made that change and restart everything. Php-fpm is still spiking cpu. Here is just 1 php-fpm process:<\/p>\n
23942 user   17   0  507m  99m  27m R   90.9%CPU   0.6   0:03.46 php-fpm\n<\/code><\/pre>\n
I’m sure there may be more information you will need to help, so just let me know what you guys need to help me figure this out. Thank you.<\/p>\n
    \n
  1. \n
    Try to adjust settings in your magento\/app\/etc\/local.xml<\/code><\/p>\n
    \n    \n        \n        \n        \n        \n            memcached\n            \n                \n                    \n                        \n                        \n                        \n                        \n                        \n                        \n                        \n                    \n                \n                \n                \n                \n                \n                \n            \n        \n        \n            HTTP_X_REAL_IP\n            HTTP_X_FORWARDED_FOR\n        \n    \n\n<\/code><\/pre>\n<\/li>\n
  2. \n
    You have this:<\/p>\n
    php_admin_value[memory_limit] = 128M\n<\/code><\/pre>\n
    Magento’s current System Requirements are “Memory_limit no less than 256Mb (preferably 512)”.<\/p>\n<\/li>\n
  3. \n
    Dis you install munin yet?<\/p>\n
    What do you mean by “consuming the entire network”? Are you implying that you have that much traffic on one magento server?<\/p>\n
    How many php req\/s do you have in averege and peak?<\/p>\n
    Dis you run http:\/\/mysqltuner.pl?<\/p>\n<\/li>\n<\/ol>\n
    Originally posted 2013-12-08 05:32:28. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
    I have been trying to resolve my issue of spiking cpu caused by php-fpm processes. I’ve reduced the php-fpm config settings to: pm = ondemand pm.max_children = 12 pm.start_servers = 2 pm.min_spare_servers = 2 pm.max_spare_servers = 10 pm.max_requests = 500 php_admin_value[memory_limit] = 128M Problem still exists. I’m running a Joomla main site (which is having […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,9,1],"tags":[],"class_list":["post-1981","post","type-post","status-publish","format-standard","hentry","category-magento","category-php-memcached","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1981"}],"version-history":[{"count":1,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1981\/revisions"}],"predecessor-version":[{"id":8988,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1981\/revisions\/8988"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}