Excessive CPU Usage

[AlexT]

The shop is 1.3.7 with the following contributions:

advanced_search_results_fix__optimization_1-0
ask_a_question_1.7
backup_mysql_plugin_v1.3
bettercategoriesezinfo_v1.3.5
blank_sidebox_2.0a
column_layout_grid_for_product_listing_1.3.61.3.7
direct_bank_deposit_0.1
encrypted_master_password_1.1
EP_v1.2.5.4
export_shipping_information_1-2-3
ezpages_on_sitemap_v_1.01
google_adsense_sidebox_1.3.0.2
google_sitemap_1-3-19
image-handler_2.0-zc13
Links_manager
optional_shipping_insurance_module_3.10
order_steps__tableless_2-2
paymate_v2.2
paypal_verified_logo_1.0.6
PPEC-137-patches-March21-2007
printable_pricelist_pricelist_v1.3pre2
privacy__condition_statements_1.1
Quick_Price_Search_with_Multi-currency_Support
recover_cart_sales_3.00
rss_feed_2-1-4
sales_report_rev104
search_log_2-0
security_patch_v138_20080919.php
shopmaniacom_automated_datafeed_generator_1.04
shopping_cart_with_image_sidebox_1.1
short_description_for_categories_1.0
simple_google_analytics_1.1.1
social_bookmarking_1.4
testimonial_manager_v1-4-6
ultimate_seo_urls_2-105
usercurrency_2-13
whats_new__products_v1.2
wlps_feeder_v1.04
ypsf_v1.05
zencart_HoverBox3_rc2

Does this make much difference?

These are the offending processes:
Top Process %CPU 27.6 httpd [matryoshkastore.com] [/index.php?main_pageproduct_info&cPath49&products_id1006]
Top Process %CPU 18.3 httpd [matryoshkastore.com] [/bmz_cache/a/a62c741a1133ee4fc7efa6a5a66d16b8.image.100x80.]

Thanks,
Alex

[kobra]

The shop is 1.3.7 with the following contributions:

With a list like this it really bears asking if you have made sure that each and every file that is a "replicate" or stated differently - If more than one module changes the same file - - If these have been merged properly to contain the alterations for each module?

To reiterate others comments: We also have several shops with many nested attributes generating 4,000+ querries and these run fine at about 1 sec parse time.

[Merlinpa1969]

Top Process %CPU 27.6 httpd [matryoshkastore.com] [/index.php?main_pageproduct_info&cPath49&products_id1006] isnt a valid link

Top Process %CPU 27.6 httpd [matryoshkastore.com] [/index.php?main_page=product_info&cPath49&products_id1006]

and this shows a page not found.

[DrByte]

http://matryoshkastore.com/index.php?main_page=product_info&cPath49&products_id=1006

That page does take forever to load, and when it does load, it's immediately redirected to an SEO-reformatted URL: http://matryoshkastore.com/christmas...pc-p-1006.html


I recommend turning off your SEO addon and your image-handler addon, as a start, and see if the pages load any differently.
The image-handler addon is quite cpu-intensive when it's rendering images.

However, I suspect the problem is likely with something else that's doing database-intensive things, such as cross-sell tools, rss feeds, extra displays of customized product information, etc.

Given that that particular product has no attributes, and only one additional image, there is no good reason for it to take forever to load, unless you've got addons that are going off and doing something very inefficiently.

[Website Rob]

rss_feed_2-1-4 << there's your problem

From experience I know that any currently available RSS mods for Zen Cart are going to cause high CPU load and/or other problems as well.

I advise Clients I work with to only use RSS mods if they know for a fact, it will be used and there is a high expectation of a good ROI. Because there is a good chance, if their eCommerce script has 100 or more Products with or without Attributes, a Shared Hosting account will no longer be suitable for them; or for their Hoster.

[Stuff4Toys]

rss_feed_2-1-4 << there's your problem

From experience I know that any currently available RSS mods for Zen Cart are going to cause high CPU load and/or other problems as well.

I advise Clients I work with to only use RSS mods if they know for a fact, it will be used and there is a high expectation of a good ROI. Because there is a good chance, if their eCommerce script has 100 or more Products with or without Attributes, a Shared Hosting account will no longer be suitable for them; or for their Hoster.

I use that rss feed module on two stores and have had no complaints from my hosting partners.
www.nativitydisplays.com is on GoDaddy shared hosting
www.jmkerusso.com is on BlueHost shared hosting

Granted the BlueHost server with localhost MySQL server is much faster, but both sites are fine.
JOhn ><>

[AlexT]

Thank you so much for all your replies!

It appears that there was a problem with the server rather than with my store. I received the following email from the host:

We have suspended a few users and as you can see the server load has come down a lot. I suspect the fact that others were abusing the CPU may have spiked everyones CPU usage. We will leave it at this for now, and give you updates should your CPU usage continue to be high.

It all seems to be OK now.

The addons I listed were added one by one over a period of time, they never caused any problems. I will probably remove the rss mod just to save a bit of CPU time as there are not too many subscribers.

Many thanks,
Alex

[kuroi]

Hats off to you actually keeping track of what you have installed. Although it sounds obvious, my impression is that most people don't and I often end up doing forensic examination of sites presented for upgrade to try to work out as accurately as I can what mods might cause problems. So although i wouldn't recommend this many add-ons (upgrader's nightmare) you deserve credit for being able to be so specific about the history of your site.

[AlexT]

Hats off to you actually keeping track of what you have installed. Although it sounds obvious, my impression is that most people don't and I often end up doing forensic examination of sites presented for upgrade to try to work out as accurately as I can what mods might cause problems. So although i wouldn't recommend this many add-ons (upgrader's nightmare) you deserve credit for being able to be so specific about the history of your site.

Thanks, but I do not think I will be able to upgrade. When the time comes, I will built a new site, this seems to be so much easier. The only hope is that some of the more popular addons are integrated into the new release.

Cheers,
Alex

[colemanpa]

The only hope is that some of the more popular addons are integrated into the new release.

Cheers,
Alex

you can read all about what's included here http://www.zen-cart.com/forum/showthread.php?t=116018

pete