Hi I have this report from shared hosting tells that the system runing slow query How can i handle this
Time: 2025-03-19T16:02:47.709039Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 968440
Query_time: 7.556462 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 6832
use tjpsjorg_tjpsdb;
SET timestamp=1742400160;
DELETE FROM sessions WHERE (last_used < 1742313760 AND remember = 0) OR (last_used < 1739808160 AND remember = 1);
Time: 2025-03-19T16:02:47.709039Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 972207
Query_time: 3.141389 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 1
use tjpsjorg_tjpsdb;
SET timestamp=1742400396;
UPDATE sessions
SET
user_id = NULL,
ip_address = ‘51.8.102.103’,
user_agent = ‘Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36; compatible; OAI-SearchBot/1.0; +https://openai.com/searchbot’,
created = 1742400395,
last_used = 1742400395,
remember = 0,
data = ‘’,
domain = ‘www.tjpsj.org’
WHERE session_id = ‘65a576a6d138cb212da1f4fd809288a9’;
Time: 2025-03-19T16:08:35.016244Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 976011
Query_time: 6.034365 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 0
use tjpsjorg_tjpsdb;
SET timestamp=1742400643;
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(‘6626abb510709c9789661aea0b6f748c’, ‘43.159.128.237’, ‘Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1’, 1742400643, 1742400643, 0, ‘’, ‘www.tjpsj.org’);
Time: 2025-03-19T16:10:49.464038Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 976183
Query_time: 4.371100 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 0
use tjpsjorg_tjpsdb;
SET timestamp=1742400654;
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(‘ed93b3db52d71894aa927b20fea8a4a5’, ‘216.244.66.232’, ‘Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)’, 1742400654, 1742400654, 0, ‘’, ‘www.tjpsj.org’);
Time: 2025-03-19T16:10:58.375327Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 976546
Query_time: 5.545695 Lock_time: 0.000002 Rows_sent: 0 Rows_examined: 1
use tjpsjorg_tjpsdb;
SET timestamp=1742400674;
UPDATE sessions
SET
user_id = NULL,
ip_address = ‘107.20.236.150’,
user_agent = ‘Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; PerplexityBot/1.0; +https://perplexity.ai/perplexitybot)’,
created = 1742400673,
last_used = 1742400673,
remember = 0,
data = ‘’,
domain = ‘www.tjpsj.org’
WHERE session_id = ‘565693ec943267abe5b9507071fa20b8’;
Time: 2025-03-19T16:11:19.943556Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 976551
Query_time: 5.360851 Lock_time: 0.000002 Rows_sent: 0 Rows_examined: 1
SET timestamp=1742400674;
UPDATE sessions
SET
user_id = NULL,
ip_address = ‘107.20.236.150’,
user_agent = ‘Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; PerplexityBot/1.0; +https://perplexity.ai/perplexitybot)’,
created = 1742400673,
last_used = 1742400673,
remember = 0,
data = ‘’,
domain = ‘www.tjpsj.org’
WHERE session_id = ‘43198316b3bd8b158da165f7d9cf3853’;
Time: 2025-03-19T16:11:19.943557Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 976557
Query_time: 5.523535 Lock_time: 0.000002 Rows_sent: 0 Rows_examined: 1
SET timestamp=1742400674;
UPDATE sessions
SET
user_id = NULL,
ip_address = ‘3.222.232.239’,
user_agent = ‘Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; PerplexityBot/1.0; +https://perplexity.ai/perplexitybot)’,
created = 1742400673,
last_used = 1742400673,
remember = 0,
data = ‘’,
domain = ‘www.tjpsj.org’
WHERE session_id = ‘ad952c15a5e96cc14b766e56342cf598’;
Time: 2025-03-19T16:11:19.943569Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 976602
Query_time: 3.333730 Lock_time: 0.000002 Rows_sent: 0 Rows_examined: 0
use tjpsjorg_tjpsdb;
SET timestamp=1742400676;
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(‘3ceab458511d5118a4eca08156a31a0e’, ‘18.97.9.96’, ‘Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; PerplexityBot/1.0; +https://perplexity.ai/perplexitybot)’, 1742400676, 1742400676, 0, ‘’, ‘www.tjpsj.org’);
Time: 2025-03-19T16:11:19.949635Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 976603
Query_time: 3.353787 Lock_time: 0.000002 Rows_sent: 0 Rows_examined: 0
use tjpsjorg_tjpsdb;
SET timestamp=1742400676;
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(‘cb0ce2bdcaecf3bcafe58f5b8d427ef7’, ‘18.97.9.98’, ‘Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; PerplexityBot/1.0; +https://perplexity.ai/perplexitybot)’, 1742400676, 1742400676, 0, ‘’, ‘www.tjpsj.org’);
Time: 2025-03-19T16:11:19.981719Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 976549
Query_time: 5.265826 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 1
use tjpsjorg_tjpsdb;
SET timestamp=1742400674;
UPDATE sessions
SET
user_id = NULL,
ip_address = ‘107.20.236.150’,
user_agent = ‘Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; PerplexityBot/1.0; +https://perplexity.ai/perplexitybot)’,
created = 1742400673,
last_used = 1742400673,
remember = 0,
data = ‘’,
domain = ‘www.tjpsj.org’
WHERE session_id = ‘b078fb20fa8d1a56944fa2dc55af72a8’;
Time: 2025-03-19T16:12:40.975361Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 980642
Query_time: 5.927133 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 0
use tjpsjorg_tjpsdb;
SET timestamp=1742400944;
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(‘a8ffc3174ef20745311c0d7cea4fabf4’, ‘52.167.144.172’, ‘Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36’, 1742400944, 1742400944, 0, ‘’, ‘tjpsj.org’);
Time: 2025-03-19T16:15:51.298719Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 982894
Query_time: 4.236953 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 6817
use tjpsjorg_tjpsdb;
SET timestamp=1742401083;
DELETE FROM sessions WHERE (last_used < 1742314683 AND remember = 0) OR (last_used < 1739809083 AND remember = 1);
Time: 2025-03-19T16:18:07.406318Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 1241902
Query_time: 6.596558 Lock_time: 0.000012 Rows_sent: 0 Rows_examined: 0
use tjpsjorg_tjpsdb;
SET timestamp=1742417301;
administrator command: Prepare;
Time: 2025-03-19T20:48:28.327222Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 1241902
Query_time: 3.485304 Lock_time: 0.000007 Rows_sent: 0 Rows_examined: 0
use tjpsjorg_tjpsdb;
SET timestamp=1742417310;
administrator command: Prepare;
Time: 2025-03-19T20:48:33.923909Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 1403116
Query_time: 12.593083 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 2613
use tjpsjorg_tjpsdb;
SET timestamp=1742428913;
DELETE FROM sessions WHERE (last_used < 1742342513 AND remember = 0) OR (last_used < 1739836913 AND remember = 1);
Time: 2025-03-20T00:02:06.038040Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 1415351
Query_time: 15.141566 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 2506
use tjpsjorg_tjpsdb;
SET timestamp=1742430011;
DELETE FROM sessions WHERE (last_used < 1742343611 AND remember = 0) OR (last_used < 1739838011 AND remember = 1);
Time: 2025-03-20T00:20:26.159805Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 1425564
Query_time: 4.810855 Lock_time: 0.000002 Rows_sent: 0 Rows_examined: 2457
use tjpsjorg_tjpsdb;
SET timestamp=1742430838;
DELETE FROM sessions WHERE (last_used < 1742344438 AND remember = 0) OR (last_used < 1739838838 AND remember = 1);
Time: 2025-03-20T00:34:03.345094Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 1435700
Query_time: 8.309848 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 2453
use tjpsjorg_tjpsdb;
SET timestamp=1742431613;
DELETE FROM sessions WHERE (last_used < 1742345213 AND remember = 0) OR (last_used < 1739839613 AND remember = 1);
Time: 2025-03-20T00:47:01.950135Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 1435898
Query_time: 4.459025 Lock_time: 0.000006 Rows_sent: 0 Rows_examined: 0
use tjpsjorg_tjpsdb;
SET timestamp=1742431634;
administrator command: Prepare;
Time: 2025-03-20T00:47:19.418634Z
User@Host: tjpsjorg_ojsuser[tjpsjorg_ojsuser] @ localhost Id: 1465143
Query_time: 3.735691 Lock_time: 0.000002 Rows_sent: 0 Rows_examine
also can i drop the data in session table from database???