Probelm Load chart database

Discussion regarding Joomla! 3.x Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
User avatar
marvaysCZ
Joomla! Intern
Joomla! Intern
Posts: 75
Joined: Thu Jan 13, 2011 7:06 pm
Location: Czech Republic
Contact:

Probelm Load chart database

Post by marvaysCZ » Wed Apr 10, 2019 4:38 am

Hi. A few days I have problem with database. Load in database jump up and down. I will exceed 100% a few times a day and the hosting will turn off for 20 minutes.
Where can the problem be? Joomla 3.9.5 and VM 3.4.2

Image

Code: Select all

Databaze: 23045_j39
Trvání dotazu: 0.479687 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` , 
		vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
		concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
		v.`created_by` ,
		vendor.`name` AS vendorname ,
		vos.`order_status_name` 
		FROM `j39_virtuemart_orders` vo 
		LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT'  
		LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id` 
		LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by` 
		LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status` 
		ORDER BY vo.`created_on` DESC
		LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.424651 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` , 
		vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
		concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
		v.`created_by` ,
		vendor.`name` AS vendorname ,
		vos.`order_status_name` 
		FROM `j39_virtuemart_orders` vo 
		LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT'  
		LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id` 
		LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by` 
		LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status` 
		ORDER BY vo.`created_on` DESC
		LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.419245 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` , 
		vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
		concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
		v.`created_by` ,
		vendor.`name` AS vendorname ,
		vos.`order_status_name` 
		FROM `j39_virtuemart_orders` vo 
		LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT'  
		LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id` 
		LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by` 
		LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status` 
		ORDER BY vo.`created_on` DESC
		LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.389323 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` , 
		vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
		concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
		v.`created_by` ,
		vendor.`name` AS vendorname ,
		vos.`order_status_name` 
		FROM `j39_virtuemart_orders` vo 
		LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT'  
		LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id` 
		LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by` 
		LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status` 
		ORDER BY vo.`created_on` DESC
		LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.374936 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` , 
		vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
		concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
		v.`created_by` ,
		vendor.`name` AS vendorname ,
		vos.`order_status_name` 
		FROM `j39_virtuemart_orders` vo 
		LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT'  
		LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id` 
		LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by` 
		LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status` 
		ORDER BY vo.`created_on` DESC
		LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.371587 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` , 
		vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
		concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
		v.`created_by` ,
		vendor.`name` AS vendorname ,
		vos.`order_status_name` 
		FROM `j39_virtuemart_orders` vo 
		LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT'  
		LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id` 
		LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by` 
		LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status` 
		ORDER BY vo.`created_on` DESC
		LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.357397 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` , 
		vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
		concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
		v.`created_by` ,
		vendor.`name` AS vendorname ,
		vos.`order_status_name` 
		FROM `j39_virtuemart_orders` vo 
		LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT'  
		LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id` 
		LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by` 
		LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status` 
		ORDER BY vo.`created_on` DESC
		LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.349409 s
Dotaz: # Rows_affected: 0
SELECT vo.`virtuemart_order_id` , vo.`virtuemart_user_id` , vo.`virtuemart_vendor_id` , 
		vo.`order_number` , vo.`order_total` , vo.`order_currency` , vo.`order_status` , vo.`created_on` , vo.`created_by` ,
		concat_ws(' ',vu.`first_name`,vu.`last_name`) AS custname , vu.`company` ,
		v.`created_by` ,
		vendor.`name` AS vendorname ,
		vos.`order_status_name` 
		FROM `j39_virtuemart_orders` vo 
		LEFT JOIN `j39_virtuemart_order_userinfos` vu ON vu.`virtuemart_order_id` = vo.`virtuemart_order_id` AND vu.`address_type`='BT'  
		LEFT JOIN `j39_virtuemart_vendors` v ON v.`virtuemart_vendor_id` = vo.`virtuemart_vendor_id` 
		LEFT JOIN `j39_users` AS vendor ON vendor.`id` = v.`created_by` 
		LEFT JOIN `j39_virtuemart_orderstates` vos ON vos.`order_status_code` = vo.`order_status` 
		ORDER BY vo.`created_on` DESC
		LIMIT 50;

--------------------------------------------------------------------

Databaze: 23045_j39
Trvání dotazu: 0.268222 s
Dotaz: # Rows_affected: 1
UPDATE `j39_sh404sef_urls` SET `cpt`=176, `last_hit`='2019-04-08 08:46:59' WHERE `id`='64160' AND `rank`=0;

--------------------------------------------------------------------
Today I make copy of page on link: luky.andree-andree.cz and turn od debug.

Can anyone help me find problem, please?

Locked

Return to “Performance - Joomla! 3.x”