|
Hi everyone. I did an update to one of our Magento stores a week ago from 1.4 to 1.6 and it is working great. I started the update (following the same steps) on another separate store on the same server today. It took about 10 minutes to reindex the data, much longer than the first update. I figured this was normal because this store is much more active and has a larger product database (over 2000 SKUs).
When I visited the store for the first time, it showed the Magento error screen. Looking at the server, MySQL was using a lot of CPU. Now, almost 7 hours later, the store will still sometimes load (to the error screen only), and sometimes not at all, but MySQL is very active.
These errors are listed over and over in the Magento system.log:
2011-12-05T20:46:42+00:00 ERR (3): Warning: include(Mage/Core/Model/Mysql4/Helper/Mysql4.php): failed to open stream: No such file or directory in /var/www/techsupportsps.com/htdocs/store/lib/Varien/Autoload.php on line 93
2011-12-05T20:46:42+00:00 ERR (3): Warning: include(Mage/Core/Model/Mysql4/Helper/Mysql4.php): failed to open stream: No such file or directory in /var/www/techsupportsps.com/htdocs/store/lib/Varien/Autoload.php on line 93
2011-12-05T20:46:42+00:00 ERR (3): Warning: include(): Failed opening 'Mage/Core/Model/Mysql4/Helper/Mysql4.php' for inclusion (include_path='/var/www/techsupportsps.com/htdocs/store/app/code/local:/var/www/techsupportsps.com/htdocs/store/app/code/community:/var/www/techsupportsps.com/htdocs/store/app/code/core:/var/www/techsupportsps.com/htdocs/store/lib:.:/usr/share/php:/usr/share/pear') in /var/www/techsupportsps.com/htdocs/store/lib/Varien/Autoload.php on line 93
2011-12-05T20:46:42+00:00 ERR (3): Warning: include(Mage/Core/Model/Mysql4/Helper/Mysql4.php): failed to open stream: No such file or directory in /var/www/techsupportsps.com/htdocs/store/lib/Varien/Autoload.php on line 93
2011-12-05T20:46:42+00:00 ERR (3): Warning: include(Mage/Core/Model/Mysql4/Helper/Mysql4.php): failed to open stream: No such file or directory in /var/www/techsupportsps.com/htdocs/store/lib/Varien/Autoload.php on line 93
2011-12-05T20:46:42+00:00 ERR (3): Warning: include(): Failed opening 'Mage/Core/Model/Mysql4/Helper/Mysql4.php' for inclusion (include_path='/var/www/techsupportsps.com/htdocs/store/app/code/local:/var/www/techsupportsps.com/htdocs/store/app/code/community:/var/www/techsupportsps.com/htdocs/store/app/code/core:/var/www/techsupportsps.com/htdocs/store/lib:.:/usr/share/php:/usr/share/pear') in /var/www/techsupportsps.com/htdocs/store/lib/Varien/Autoload.php on line 93
Here is an example of the process list in MySQL:
mysql> show processlist;
+--------+------------------+-----------+------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------------------+-----------+------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 799849 | root | localhost | techsupportstore | Query | 0 | NULL | show processlist |
| 799923 | techsupport | localhost | techsupportstore | Query | 0 | rename result table | ALTER TABLE `catalog_category_anc_products_index_tmp` ENGINE=InnoDB |
| 799938 | techsupport | localhost | techsupportstore | Query | 0 | Opening tables | DESCRIBE `catalog_product_index_price_tmp` |
| 799961 | techsupport | localhost | techsupportstore | Query | 0 | Opening tables | ALTER TABLE `catalog_product_index_price_final_idx` MODIFY COLUMN `min_price` decimal(12,4) NULL COM |
| 799962 | techsupport | localhost | techsupportstore | Query | 0 | Opening tables | DESCRIBE `catalog_product_index_price_final_idx` |
| 799970 | techsupport | localhost | techsupportstore | Query | 1 | checking permissions | DESCRIBE `catalog_product_index_price_cfg_opt_idx` |
| 799973 | techsupport | localhost | techsupportstore | Query | 0 | Opening tables | DESCRIBE `catalog_product_index_price_cfg_opt_agr_tmp` |
| 799978 | techsupport | localhost | techsupportstore | Query | 1 | Opening tables | DESCRIBE `catalog_product_index_eav_decimal` |
| 800003 | techsupport | localhost | techsupportstore | Query | 0 | Opening tables | DESCRIBE `catalog_product_link` |
| 800011 | techsupport | localhost | techsupportstore | Query | 2 | copy to tmp table | ALTER TABLE `core_url_rewrite` MODIFY COLUMN `category_id` int UNSIGNED NOT NULL COMMENT '' |
| 800018 | techsupport | localhost | techsupportstore | Query | 14 | copy to tmp table | ALTER TABLE `report_viewed_product_index` ADD CONSTRAINT `FK_REPORT_VIEWED_PRODUCT_INDEX_PRODUCT` FO |
| 800023 | techsupport | localhost | techsupportstore | Query | 0 | closing tables | SHOW CREATE TABLE `paygate_authorizenet_debug` |
| 800041 | techsupport | localhost | techsupportstore | Query | 0 | Opening tables | SHOW CREATE TABLE `catalog_product_entity_varchar` |
| 800042 | techsupport | localhost | techsupportstore | Query | 0 | Opening tables | SHOW CREATE TABLE `catalog_product_super_attribute_label` |
+--------+------------------+-----------+------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
Over the last 7 hours, this list varies from 5 processes to 30, all for the same Magento instance. It sure looks like it is doing something and I hate to kill MySQL.
I don’t think server resources are the problem here - the server is fairly new with a Quad-core Xeon processor and 8GB of RAM. MySQL is using about 10% of the CPU max.
Has anyone else run into this problem? Do you have any insight into what the heck is going on? Thanks!
|
