Hello,
I just received from my hosting provider a warning about an high consuming of server resource, especially slowly queries on the database that takes a lot of resources.
How can I fix these:
1. Executed 3h 5m 52s ago for 3.412979 sec on Database –> dbxee9kuwiqysu
Date: 2024-03-11 11:35:47 Query_time: 3.412979 Rows_examined: 73542: Rows_sent 73542 Lock_time: 0.000016 Query_chars: 70
SELECT /*!40001 SQL_NO_CACHE */ * FROM LVdILn_woocommerce_sessions;
——————————————————————————————————————-
2. Executed 3h 5m 55s ago for 3.009597 sec on Database –> dbxee9kuwiqysu
Date: 2024-03-11 11:35:44 Query_time: 3.009597 Rows_examined: 618769: Rows_sent 618769 Lock_time: 0.000018 Query_chars: 64
SELECT /*!40001 SQL_NO_CACHE */ * FROM LVdILn_sgs_log_events;
——————————————————————————————————————-
3. Executed 3h 5m 46s ago for 1.902697 sec on Database –> dbh7iv8gmgckwg
Date: 2024-03-11 11:35:53 Query_time: 1.902697 Rows_examined: 379820: Rows_sent 379820 Lock_time: 0.000018 Query_chars: 64
SELECT /*!40001 SQL_NO_CACHE */ * FROM LVdILn_sgs_log_events;
——————————————————————————————————————-
4. Executed 11h 59m 37s ago for 1.724412 sec on Database –> dbxee9kuwiqysu
Date: 2024-03-11 02:42:02 Query_time: 1.724412 Rows_examined: 565795: Rows_sent 1 Lock_time: 0.000032 Query_chars: 166
SELECT COUNT(*) FROM LVdILn_sgs_log_events WHERE action = “visit” AND visitor_type = “Human” AND type = “unknown” AND ts BETWEEN 1709510400 AND 1710124920;
——————————————————————————————————————-
5. Executed 3h 5m 44s ago for 1.389101 sec on Database –> dbh7iv8gmgckwg
Date: 2024-03-11 11:35:55 Query_time: 1.389101 Rows_examined: 26915: Rows_sent 26915 Lock_time: 0.000017 Query_chars: 70
SELECT /*!40001 SQL_NO_CACHE */ * FROM LVdILn_woocommerce_sessions;
Thanks for your kind support
Andrea
.
