Server Load ! Mysql

2025-04-21

Hello

I have encountered a very serious problem

The server load accelarates and below is the show mysql process,and even when I restart the mysql the server load comes down and then accelarates again,I checkd whaether the tables are out of work or not and there were no problem with them,I have almost about 500 sites on my server ,

Main >> SQL Services >> Show MySQL Processes

+------+------------------+-----------+------------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User
| Host | db | Command | Time | State | Info |
+------+------------------+-----------+------------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 4915 | parstaz_pars | localhost | parstaz_pars | Sleep | 218 | | |
| 4919 | atirann_adveruse | localhost | atirann_adver | Sleep | 216 | | |
| 4942 | atirann_adveruse | localhost | atirann_adver | Sleep | 208 | | |
| 5074 | ms_msdating
| localhost | ms_dating | Sleep | 137 | | |
| 5222 | barname_db1 | localhost | barname_forumvb | Query | 119 | Sorting result | SELECT postid
FROM post AS post
INNER JOIN thread AS thread ON(thread.threadid = post.threadid) |
| 5297 | barname_db1 | localhost | barname_forumvb | Query | 59 | Locked | SELECT threadid

FROM thread AS thread

WHERE forumid = 21
AND sticky = 0
AND visib |
| 5298 | barname_db1 | localhost | barname_forumvb | Query | 58 | Locked | SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / |
| 5301 | barname_db1 | localhost | barname_forumvb | Query | 59 | Locked | SELECT threadid

FROM thread AS thread

WHERE forumid = 21
AND
sticky = 0
AND visib |
| 5302 | barname_db1 | localhost | barname_forumvb | Query | 59 | Locked | SELECT threadid

FROM thread AS thread

WHERE forumid = 21
AND sticky = 0
AND visib |
| 5307 | barname_db1 | localhost | barname_forumvb | Query | 59 | Locked | UPDATE thread SET
replycount = replycount + 1,
lastpost = 1142245226,
lastposter = 'ali_kolahd |
| 5313 | isforum_isuser | localhost | isforum_isdb | Query | 96 | Locked | SELECT s.member_id, s.member_name, s.member_group, s.id, s.login_type, s.location, s.running_time
|
| 5314 | afshin_blog | localhost | afshin_wordpress | Sleep | 34 | | |
| 5323 | boursen_ubn14mb | localhost | boursen_bmbnd5 | Query | 105 | Sorting result | SELECT a.id
FROM mos_content AS a
INNER
JOIN mos_categories AS b ON b.id = a.catid
WHERE a.state |
| 5334 | barname_db1 | localhost | barname_forumvb | Query | 54 | Locked | SELECT threadid

FROM thread AS thread

WHERE forumid = 21
AND sticky = 0
AND visib |
| 5339 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT threadid

FROM thread AS thread

WHERE forumid = 21
AND sticky = 0
AND visib |
| 5343 | pitco_pars | localhost | pitco_eshop | Sleep | 90 | | |
| 5350 | barname_db1 | localhost | barname_forumvb | Query | 59 | Locked | SELECT threadid

FROM thread AS thread

WHERE forumid = 21
AND sticky = 0
AND visib |
| 5377 | barname_db1 | localhost | barname_forumvb | Query | 42 |
Locked | SELECT user.username, user.usergroupid, user.membergroupids,
session.userid, session.inthread, se |
| 5386 | khorasan_kiec | localhost | khorasan_kiec | Sleep | 103 | | |
| 5390 | ms_ms | localhost | ms_ | Query | 103 | Sending data | SELECT user,ip,last_seen from nuke_blocked_iplist where ip='130.130.1.106, 217.66.221.34' and user=' |
| 5405 | isforum_isuser | localhost | isforum_isdb | Query | 102 | updating | DELETE FROM ibf_sessions WHERE ip_address='217.219.158.131' |
| 5406 | boursen_ubn14mb | localhost | boursen_bmbnd5 | Query | 99 | Sorting result | SELECT a.id
FROM mos_content AS a
INNER JOIN mos_categories AS b ON b.id = a.catid
WHERE a.state |
| 5407 | pitco_pars | localhost | pitco_eshop | Sleep
| 79 | | |
| 5415 | ms_ms | localhost | ms_ | Query | 91 | Sending data | SELECT user,ip,last_seen from nuke_blocked_iplist where ip='130.130.1.106, 217.66.221.34' and user=' |
| 5417 | ms_ms | localhost | ms_ | Query | 86 | Sending data | SELECT user,ip,last_seen from nuke_blocked_iplist where ip='130.130.1.106, 217.66.221.34' and user=' |
| 5421 | barname_db1 | localhost | barname_forumvb | Query | 47 | Locked | UPDATE user
SET
lastvisit = lastactivity,
lastactivity = 1142245249
WHERE |
| 5437 | barname_db1 | localhost | barname_forumvb | Query | 86 | Sorting result | SELECT searchid, dateline
FROM search AS search
WHERE ipaddress ='217.219.226.28'
ORDER BY dat |
| 5442 | barname_db1 | localhost |
barname_forumvb | Query | 87 | Sorting result | SELECT searchid, dateline
FROM search AS search
WHERE ipaddress ='217.219.226.28'
ORDER BY dat |
| 5444 | barname_db1 | localhost | barname_forumvb | Query | 83 | Sorting result | SELECT searchid, dateline
FROM search AS search
WHERE ipaddress ='217.219.226.28'
ORDER BY dat |
| 5448 | mokhtar_mokhtar | localhost | mokhtar_mokhtar | Sleep | 56 | | |
| 5450 | barname_db1 | localhost | barname_forumvb | Query | 89 | Sorting result | SELECT searchid, dateline
FROM search AS search
WHERE ipaddress ='217.219.226.28'
ORDER BY dat |
| 5461 | barname_db1 | localhost | barname_forumvb | Query | 47 | Locked | UPDATE user
SET lastactivity = 1142245259
WHERE userid = 7984 |
| 5463 |
barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142225747 AND open <> 10, 1, 0)) AS newthre |
| 5465 | barname_db1 | localhost | barname_forumvb | Query | 58 | Sorting result | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5466 | barname_db1 | localhost | barname_forumvb | Query | 78 | Sorting result | SELECT searchid, dateline
FROM search AS search
WHERE ipaddress ='217.219.226.28'
ORDER BY dat |
| 5470 | barname_db1 | localhost | barname_forumvb | Query | 78 | Sorting result | SELECT searchid, dateline
FROM search AS search
WHERE ipaddress ='217.219.226.28'
ORDER BY dat |
| 5475 | barname_db1 | localhost | barname_forumvb | Query | 46 | Locked | UPDATE user
SET lastactivity = 1142245261
WHERE userid = 16425
|
| 5476 | barname_db1 | localhost | barname_forumvb | Query | 78 | Sorting result | SELECT searchid, dateline
FROM search AS search
WHERE ipaddress ='217.219.226.28'
ORDER BY dat |
| 5478 | barname_db1 | localhost | barname_forumvb | Query | 78 | Sorting result | SELECT searchid, dateline
FROM search AS search
WHERE ipaddress ='217.219.226.28'
ORDER BY dat |
| 5481 | boursen_ubn14mb | localhost | boursen_bmbnd5 | Query | 74 | Sorting result | SELECT a.id
FROM mos_content AS a
INNER JOIN mos_categories AS b ON b.id = a.catid
WHERE a.state |
| 5484 | barname_db1 | localhost | barname_forumvb | Query | 45 | Locked | SELECT user.*, usertextfield.*
FROM user AS user
LEFT JOIN usertextfield AS usertextfield ON(u |
| 5497 | barname_db1 | localhost | barname_forumvb | Query | 60 | Sorting result | SELECT searchid, dateline
FROM search AS
search
WHERE ipaddress ='217.219.226.28'
ORDER BY dat |
| 5502 | barname_db1 | localhost | barname_forumvb | Query | 42 | Locked | SELECT user.username, user.usergroupid, user.membergroupids,
session.userid, session.inthread, se |
| 5503 | barname_db1 | localhost | barname_forumvb | Query | 42 | Locked | SELECT user.username, user.usergroupid, user.membergroupids,
session.userid, session.inthread, se |
| 5505 | barname_db1 | localhost | barname_forumvb | Query | 42 | Locked | SELECT user.username, user.usergroupid, user.membergroupids,
session.userid, session.inthread, se |
| 5508 | barname_db1 | localhost | barname_forumvb | Query | 42 | Locked | UPDATE session
SET lastactivity = 1142245273, location = '/forum/showpost.php?p=201623&post |
| 5512 | barname_db1 | localhost | barname_forumvb | Query | 60 | Sorting result | SELECT threadid
FROM
thread AS thread
WHERE forumid = 21
AND lastpost < 1142159533
AND |
| 5513 | barname_db1 | localhost | barname_forumvb | Sleep | 48 | | |
| 5516 | barname_db1 | localhost | barname_forumvb | Query | 48 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142244972 AND open <> 10, 1, 0)) AS newthre |
| 5518 | barname_db1 | localhost | barname_forumvb | Sleep | 49 | | |
| 5519 | barname_db1 | localhost | barname_forumvb | Query | 50 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5522 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked
| SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5523 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5524 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5527 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5530 | barname_db1 | localhost | barname_forumvb | Query | 47 | Locked | UPDATE user SET
lastactivity = 1142244377,
lastvisit = 1142245277
WHERE userid = 8641 |
| 5531 | barname_db1 | localhost
| barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142244344 AND open <> 10, 1, 0)) AS newthre |
| 5532 | barname_db1 | localhost | barname_forumvb | Query | 48 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5534 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5535 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5540 | barname_db1 | localhost | barname_forumvb | Query | 47 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1,
0)) AS newthre |
| 5541 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5542 | barname_db1 | localhost | barname_forumvb | Query | 47 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5543 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5545 | barname_db1 | localhost | barname_forumvb | Query | 48 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5546 | barname_db1 | localhost | barname_forumvb | Query | 47 | Locked | SELECT COUNT(*) AS threads,

SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5547 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5549 | barname_db1 | localhost | barname_forumvb | Query | 48 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5550 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5552 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142244516 AND open <> 10, 1, 0)) AS newthre |
| 5553 | barname_db1 | localhost | barname_forumvb | Query |
49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5555 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5556 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5557 | barname_db1 | localhost | barname_forumvb | Query | 48 | Locked | SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1142235476 AND open <> 10, 1, 0)) AS newthre |
| 5560 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT IF(visible = 2, 1, 0) AS isdeleted,

thread.*
FROM thread AS thread

|
| 5561 | barname_db1 | localhost | barname_forumvb | Query | 39 | Locked | UPDATE session
SET lastactivity = 1142245290, location = '/forum/private.php?', inforum = 0, in |
| 5562 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT IF(visible = 2, 1, 0) AS isdeleted,

NOT ISNULL(subscribethread.subscribethreadid) AS |
| 5564 | barname_db1 | localhost | barname_forumvb | Query | 49 | Locked | SELECT IF(visible = 2, 1, 0) AS isdeleted,

NOT ISNULL(subscribethread.subscribethreadid) AS |
| 5567 | barname_db1 | localhost | barname_forumvb | Query | 47 | Locked | SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF |
| 5571 | barname_db1 | localhost | barname_forumvb | Query | 44 | Locked | SELECT
userfield.*, usertextfield.*, user.*,
UNIX_TIMESTAMP(passworddate) AS passworddate,
IF |
| 5572 | barname_db1 | localhost | barname_forumvb | Query | 47 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5573 | barname_db1 | localhost | barname_forumvb | Query | 46 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5574 | barname_db1 | localhost | barname_forumvb | Query | 47 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5575 | barname_db1 | localhost | barname_forumvb | Query | 45 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5579 | barname_db1 | localhost | barname_forumvb | Query | 44 | Locked | SELECT

announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5578 | barname_db1 | localhost | barname_forumvb | Query | 44 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5580 | barname_db1 | localhost | barname_forumvb | Query | 45 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5581 | barname_db1 | localhost | barname_forumvb | Query | 45 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5582 | barname_db1 | localhost | barname_forumvb | Query | 45 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5583 | barname_db1 | localhost | barname_forumvb | Query | 45 |
Locked | SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF |
| 5584 | barname_db1 | localhost | barname_forumvb | Query | 45 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5587 | barname_db1 | localhost | barname_forumvb | Query | 43 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5588 | mokhtar_mokhtar | localhost | mokhtar_mokhtar | Sleep | 45 | | |
| 5590 | barname_db1 | localhost | barname_forumvb | Query | 45 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5593 | barname_db1 | localhost |
barname_forumvb | Query | 43 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5594 | barname_db1 | localhost | barname_forumvb | Query | 41 | Locked | SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user. |
| 5595 | barname_db1 | localhost | barname_forumvb | Query | 42 | Locked | SELECT user.*, usertextfield.*
FROM user AS user
LEFT JOIN usertextfield AS usertextfield ON(u |
| 5596 | barname_db1 | localhost | barname_forumvb | Query | 39 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5597 | barname_db1 | localhost | barname_forumvb | Query | 39 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5598
| barname_db1 | localhost | barname_forumvb | Query | 39 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5600 | barname_db1 | localhost | barname_forumvb | Query | 38 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5604 | barname_db1 | localhost | barname_forumvb | Query | 36 | Locked | SELECT *
FROM session
WHERE sessionhash = '118605ec9d9eb6c6acd96ada059a3c02'
AND lastac |
| 5607 | barname_db1 | localhost | barname_forumvb | Query | 33 | Locked | SELECT *
FROM session
WHERE sessionhash = '3f7ab6e558520806d043897a6a2bc473'
AND lastac |
| 5611 | barname_db1 | localhost | barname_forumvb | Query | 23 | Locked | SELECT *
FROM session
WHERE sessionhash =
'cbd70df72fc7de711cb620743aa21e6e'
AND lastac |
| 5614 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5613 | boursen_ubn14mb | localhost | boursen_bmbnd5 | Query | 13 | Locked | UPDATE mos_content SET hits=(hits+1) WHERE id='5819' |
| 5612 | parstaz_pars | localhost | parstaz_pars | Sleep | 15 | | |
| 5616 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5615 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM
session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5617 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5618 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5619 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = 'cbd70df72fc7de711cb620743aa21e6e'
AND lastac |
| 5620 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5621 | barname_db1 | localhost | barname_forumvb | Query | 15
| Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5623 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5622 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5624 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5625 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5626 | barname_db1 |
localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5627 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5628 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5629 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5630 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'

AND lastac |
| 5631 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5632 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5634 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5635 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5633 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash =
'8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5636 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = 'ccee5af643be3f12f0a20a4ee6e24875'
AND lastac |
| 5640 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5641 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5639 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5638 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *

FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5642 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5643 | barname_db1 | localhost | barname_forumvb | Query | 15 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5644 | barname_db1 | localhost | barname_forumvb | Query | 14 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5645 | barname_db1 | localhost | barname_forumvb | Query | 14 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5646 | barname_db1 | localhost | barname_forumvb | Query
| 14 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5647 | barname_db1 | localhost | barname_forumvb | Query | 14 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5648 | barname_db1 | localhost | barname_forumvb | Query | 14 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5649 | barname_db1 | localhost | barname_forumvb | Query | 14 | Locked | SELECT *
FROM session
WHERE sessionhash = '528a83ac98bf4904bf44c1078e9538f8'
AND lastac |
| 5650 | barname_db1 | localhost | barname_forumvb | Query | 14 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5651 | barname_db1
| localhost | barname_forumvb | Query | 14 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5652 | barname_db1 | localhost | barname_forumvb | Query | 14 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5653 | barname_db1 | localhost | barname_forumvb | Query | 13 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5655 | barname_db1 | localhost | barname_forumvb | Query | 12 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5657 | barname_db1 | localhost | barname_forumvb | Query | 11 | Locked | SELECT *
FROM session
WHERE sessionhash = '7f01a594aad471a2595966a476c24756'

AND lastac |
| 5658 | barname_db1 | localhost | barname_forumvb | Query | 7 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5659 | ps_dbuser | localhost | ps_db | Sleep | 9 | | |
| 5661 | ms_ms | localhost | ms_ | Query | 9 | Sending data | SELECT user,ip,last_seen from nuke_blocked_iplist where ip='130.130.1.106, 217.66.221.34' and user=' |
| 5664 | barname_db1 | localhost | barname_forumvb | Query | 9 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5665 | barname_db1 | localhost | barname_forumvb | Query | 9 | Locked | SELECT *
FROM session
WHERE sessionhash =
'6b5f362d8c03393841b479c0bad78469'
AND lastac |
| 5668 | isforum_isuser | localhost | isforum_isdb | Query | 5 | Locked | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='bd7af5bf1ae223e4603374f02c5 |
| 5669 | ms_msdating | localhost | ms_dating | Sleep | 3 | | |
| 5670 | ms_ms | localhost | ms_ | Query | 7 | Sending data | SELECT user,ip,last_seen from nuke_blocked_iplist where ip='130.130.1.106, 217.66.221.34' and user=' |
| 5671 | barname_db1 | localhost | barname_forumvb | Query | 8 | Locked | SELECT *
FROM session
WHERE sessionhash = '7f01a594aad471a2595966a476c24756'
AND lastac |
| 5672 | barname_db1 | localhost | barname_forumvb | Query | 8 | Locked | SELECT
userfield.*,
usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF |
| 5675 | barname_db1 | localhost | barname_forumvb | Query | 6 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5677 | barname_db1 | localhost | barname_forumvb | Query | 5 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5679 | barname_db1 | localhost | barname_forumvb | Query | 5 | Locked | SELECT *
FROM session
WHERE sessionhash = '8f79ffa069c84a2e6cf4af882145e05d'
AND lastac |
| 5681 | isforum_isuser | localhost | isforum_isdb | Query | 2 | Locked | DELETE FROM ibf_sessions WHERE member_id=354 |
| 5682 | barname_db1 | localhost | barname_forumvb | Query | 1 | Locked
| SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5683 | barname_db1 | localhost | barname_forumvb | Query | 0 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5684 | barname_db1 | localhost | barname_forumvb | Query | 0 | Locked | SELECT *
FROM session
WHERE sessionhash = '8507a4923b402826f139e3a36bfdecb5'
AND lastac |
| 5685 | barname_db1 | localhost | barname_forumvb | Query | 0 | Locked | SELECT *
FROM session
WHERE sessionhash = '122be76655427642d47357b1e3d1665b'
AND lastac |
| 5686 | root | localhost | | Query | 0 | | show processlist
|
+------+------------------+-----------+------------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+