0
SET timestamp=1708087305;
UPDATE `theme` SET `parent_id` = NULL, `theme_path` = 'Magento/blank', `theme_title` = 'Magento Blank', `preview_image` = 'preview_image_5d490e5c15226.jpeg', `is_featured` = '0', `area` = 'frontend', `type` = '0', `code` = 'Magento/blank' WHERE (theme_id='1');
# Time: 2024-02-16T12:43:01.426876Z

use database_name;
SET timestamp=1708088126;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `customer_visitor`;
# Time: 2024-02-16T12:57:56.894749Z

How to Fix this error..

6
  • Add more details about this. Feb 20 at 11:18
  • The above queries are run daily and log are generate and the load on the server increases. we getting error like... i.imgur.com/vqJ89az.png Feb 20 at 11:29
  • what is the value of query_cache_type and query_cache_size of MySQL? Feb 20 at 13:01
  • @MagecompProductTeam Do you mean there are entries in Slow Query Log for the url you posted? Please post TEXT result of A) SHOW CREATE TABLE theme; and B) SHOW TABLE STATUS WHERE name LIKE "theme"; for analysis. Feb 29 at 14:26
  • Please also post TEXT results of SHOW TABLE STATUS WHERE name LIKE "customer_visitor"; Feb 29 at 14:39

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.