Apache using 100% resources

Hi there,

Let’s start checking if there are errors on the WooCommerce Logs. Kindly provide us the following:

• System Status: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
• Fatal Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available)

Best,

Hi,

Please find the below system status report

### WordPress Environment ###

WordPress address (URL): https://www.pusthakakada.com
Site address (URL): https://www.pusthakakada.com
WC Version: 6.3.1
REST API Version: ? 6.3.1
WC Blocks Version: ? 6.9.0
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.2.1
Log Directory Writable: ?
WP Version: 6.0
WP Multisite: –
WP Memory Limit: 8 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.12
PHP Version: 7.3.12
PHP Post Max Size: 64 MB
PHP Time Limit: 40000
PHP Max Input Vars: 3000
cURL Version: 7.64.0
OpenSSL/1.1.1c

SUHOSIN Installed: –
MySQL Version: 8.0.18
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.3.1
WC Database Prefix: wp_
Total Database Size: 798.71MB
Database Data Size: 494.06MB
Database Index Size: 304.65MB
wp_woocommerce_sessions: Data: 9.17MB + Index: 0.20MB + Engine MyISAM
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_items: Data: 3.87MB + Index: 1.46MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 17.46MB + Index: 12.95MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_mig_wpmdb_alter_statements: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Data: 0.58MB + Index: 0.29MB + Engine MyISAM
wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Data: 0.33MB + Index: 0.25MB + Engine MyISAM
wp_aws_cache: Data: 10.61MB + Index: 0.00MB + Engine MyISAM
wp_aws_index: Data: 78.90MB + Index: 97.28MB + Engine MyISAM
wp_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_comments: Data: 2.87MB + Index: 2.26MB + Engine MyISAM
wp_dokan_announcement: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_dokan_orders: Data: 1.52MB + Index: 1.95MB + Engine InnoDB
wp_dokan_refund: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_dokan_vendor_balance: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_dokan_withdraw: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_dv_assign_awb: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_dv_awb_no_details: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_dv_logs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_dv_my_warehouse: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_dv_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_e_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gla_budget_recommendations: Data: 0.11MB + Index: 0.12MB + Engine MyISAM
wp_gla_merchant_issues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gla_shipping_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gla_shipping_times: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_lecm_rewrite: Data: 3.30MB + Index: 0.51MB + Engine MyISAM
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_custom_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_dynamic_segment_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_feature_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_mapping_to_external_entities: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_option: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_option_fields: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_mailpoet_newsletter_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_templates: Data: 1.05MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_scheduled_task_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_scheduled_tasks: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
wp_mailpoet_segments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_mailpoet_sending_queues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_bounces: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_clicks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_opens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_unsubscribes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_woocommerce_purchases: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_stats_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_subscriber_custom_field: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_subscriber_ips: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_subscriber_segment: Data: 0.84MB + Index: 0.82MB + Engine MyISAM
wp_mailpoet_subscribers: Data: 4.80MB + Index: 3.49MB + Engine MyISAM
wp_mailpoet_user_agents: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_user_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 20.09MB + Index: 1.26MB + Engine MyISAM
wp_postmeta: Data: 132.45MB + Index: 55.06MB + Engine MyISAM
wp_posts: Data: 48.78MB + Index: 7.83MB + Engine MyISAM
wp_smush_dir_images: Data: 17.79MB + Index: 7.91MB + Engine MyISAM
wp_term_relationships: Data: 7.09MB + Index: 23.51MB + Engine MyISAM
wp_term_taxonomy: Data: 10.24MB + Index: 10.70MB + Engine MyISAM
wp_termmeta: Data: 0.40MB + Index: 0.29MB + Engine MyISAM
wp_terms: Data: 12.39MB + Index: 24.62MB + Engine MyISAM
wp_tm_taskmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_usermeta: Data: 19.59MB + Index: 13.62MB + Engine MyISAM
wp_users: Data: 5.58MB + Index: 3.85MB + Engine MyISAM
wp_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_wc_cancel_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_customer_lookup: Data: 3.03MB + Index: 2.14MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_product_lookup: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
wp_wc_order_stats: Data: 0.98MB + Index: 0.79MB + Engine MyISAM
wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_meta_lookup: Data: 1.21MB + Index: 1.47MB + Engine MyISAM
wp_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wdr_order_discounts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp_wdr_rules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woo_shippment_provider: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
wp_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wt_iew_action_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wt_iew_mapping_template: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yoast_indexable: Data: 64.05MB + Index: 20.00MB + Engine MyISAM
wp_yoast_indexable_hierarchy: Data: 2.55MB + Index: 7.48MB + Engine MyISAM
wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_yoast_primary_term: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yoast_seo_links: Data: 12.07MB + Index: 2.40MB + Engine MyISAM

### Post Type Counts ###

attachment: 27318
bwp_footer: 6
bwp_megamenu: 2
bwp_slider: 6
custom_css: 2
customize_changeset: 37
elementor_library: 2
mailpoet_page: 1
nav_menu_item: 125
oembed_cache: 1
ourteam: 3
page: 46
portfolio: 8
post: 13
product: 16551
revision: 1491
shop_order: 15048
testimonial: 4
tt_font_control: 1
wp_global_styles: 1
wpcf7_contact_form: 5
wphb_minify_group: 8

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (29) ###

Template Library and Redux Framework: by Extendify – 4.3.12
Advanced Woo Search: by ILLID – 2.55
Aurobees: by Aurobees – 1.0.0
CCAvenue Payment Gateway for WooCommerce: by Nilesh Chourasia – 2.9
Contact Form 7: by Takayuki Miyoshi – 5.5.6.1
Custom Order Statuses for WooCommerce: by Nuggethon – 1.5.1
Delhivery Logistics Courier: by Delhivery – 1.0.98
Dokan: by weDevs – 3.4.1
Elementor: by Elementor.com – 3.6.2
LitExtension Customer Password Plugin: by LitExtension – 1.0.0
oik weight zone shipping: by bobbingwide – 0.2.4
TaxoPress: by TaxoPress – 3.6.1
Smart WooCommerce Search: by YummyWP – 2.3.1
Variation Swatches for WooCommerce: by Woosuite – 2.1.5
WC Cancel Order: by Vikram S – 3.1.5
WC Hide Shipping Methods: by Rynaldo Stoltz – 1.5
Woocommerce Partial Shipment: by Vikram S – 2.8
Advanced Shipment Tracking for WooCommerce: by zorem – 3.4
Woo Discount Rules: by Flycart – 2.4.1
Razorpay for WooCommerce: by Team Razorpay – 3.8.0
WPC Smart Wishlist for WooCommerce: by WPClever – 3.0.6
WooCommerce: by Automattic – 6.3.1 (update to version 6.6.1 is available)
Yoast SEO: by Team Yoast – 19.0
WP Crontrol: by John Blackbourn & crontributors – 1.12.1
WP Mail SMTP: by WPForms – 3.4.0
WP Migrate Lite: by Delicious Brains – 2.3.1
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.2.3

Wpbingo Core: by TungHV – 1.0
WPS Hide Login: by WPServeur
NicolasKulka
wpformation – 1.9.6

### Inactive Plugins (0) ###

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Must Use Plugins (1) ###

WP Migrate DB Pro Compatibility: by Delicious Brains – 1.2

### Settings ###

API Enabled: –
Force SSL: –
Currency: INR (?)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 0
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #12 - /shop/
Cart: #13 - /cart/
Checkout: #14 - /checkout/
My account: #15 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Bookio
Version: 1.0.4
Author URL: https://wpbingosite.com/
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?

### Templates ###

Overrides: bookio/woocommerce/archive-product.php
bookio/woocommerce/cart\cart-shipping.php
bookio/woocommerce/cart\cart-totals.php
bookio/woocommerce/cart\cart.php
bookio/woocommerce/cart\cross-sells.php
bookio/woocommerce/cart\mini-cart.php
bookio/woocommerce/checkout\form-checkout.php
bookio/woocommerce/checkout\review-order.php
bookio/woocommerce/content-product.php
bookio/woocommerce/content-single-product.php
bookio/woocommerce/loop\add-to-cart.php
bookio/woocommerce/loop\loop-end.php
bookio/woocommerce/loop\loop-start.php
bookio/woocommerce/loop\no-products-found.php
bookio/woocommerce/loop\orderby.php
bookio/woocommerce/loop\pagination.php
bookio/woocommerce/loop\rating.php
bookio/woocommerce/loop\result-count.php
bookio/woocommerce/loop\sale-flash.php
bookio/woocommerce/myaccount\form-login.php
bookio/woocommerce/order\form-tracking.php
bookio/woocommerce/single-product\add-to-cart\external.php
bookio/woocommerce/single-product\add-to-cart\grouped.php
bookio/woocommerce/single-product\add-to-cart\simple.php
bookio/woocommerce/single-product\add-to-cart\variable.php
bookio/woocommerce/single-product\add-to-cart\variation-add-to-cart-button.php
bookio/woocommerce/single-product\price.php
bookio/woocommerce/single-product\product-image.php
bookio/woocommerce/single-product\product-thumbnails.php
bookio/woocommerce/single-product\related.php
bookio/woocommerce/single-product\review.php
bookio/woocommerce/single-product\sale-flash.php
bookio/woocommerce/single-product\short-description.php
bookio/woocommerce/single-product\tabs\additional-information.php
bookio/woocommerce/single-product\tabs\description.php
bookio/woocommerce/single-product\tabs\tabs.php
bookio/woocommerce/single-product\title.php
bookio/woocommerce/single-product\up-sells.php
bookio/woocommerce/single-product-reviews.php
bookio/woocommerce/single-product.php

### Action Scheduler ###

Canceled: 1
Oldest: 2022-05-27 09:29:23 +0530
Newest: 2022-05-27 09:29:23 +0530

Complete: 1,972
Oldest: 2022-06-09 09:26:10 +0530
Newest: 2022-06-22 09:22:18 +0530

Pending: 2
Oldest: 2022-06-22 15:03:10 +0530
Newest: 2022-06-27 19:34:05 +0530

### Status report information ###

Generated at: 2022-06-22 09:23:28 +05:30

Hi @rohini204,

Thanks for this! Looking over the site, it does not have a lot of plugins but the theme does have a lot of overrides. There are a few things that might be the cause:

– Plugin and/or theme issue: sometimes a plugin or the theme can make a lot of calls to the Cron of WP, causing the server to spike if something gets stuck or it has to process a lot. Looking at the Action Scheduler I see that there are just under 2,000 actions in as little as 2 weeks, so the site is rather busy.

You can create a staging site – your Host can help with this – to test out and see if the same thing happens. If it does, try disabling the theme by switching to another like Storefront or Twenty Twenty Two, and see if the same thing happens. If it does, you can disable a few plugins at a time until the CPU / Memory drop. Re-enabling the plugins / theme one at a time and testing can help narrow down what is going on. More on this is covered here.

– Do not discount a potential site attack, as other threads have sometimes pointed to that as an issue. Your Host can assist with making sure the site is secure and there is not something similar happening to it.

Hope this helps! Let us know what happens.

We haven’t heard back from you in a while, so I’m marking this thread closed for now – we’ll be here if and/or when you are ready to continue.