How to solve table locking ??

[Ava-Kyrillos]

Hello

when I asked the support about this load in mysql
they answer me

==================================================
One your modules is locking up the tables. Please check :

| 55273 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 39 | Sending data | SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1182773738 AND open 10, 1, 0)) AS newthread
|
| 55272 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 0 | Locked | SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, use |
| 55277 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 6 | Locked | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 55280 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 0 | Locked | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las |
| 55284 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 13 | Locked | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 55286 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 9 | Locked | SELECT showcybstats FROM user AS user WHERE userid = 14997 |
| 55285 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 10 | Locked | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 55290 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 22 | Locked | SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, use |
| 55293 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 4 | Locked | SELECT showcybstats FROM user AS user WHERE userid = 1461 |
| 55302 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 22 | Sending data | SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache |
| 55300 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 20 | Locked | SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF |
| 55304 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 12 | Locked | SELECT
announcement.announcementid, startdate, title, announcement.views,
user.username, user. |
| 55307 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 10 | Locked | UPDATE user
SET lastactivity = 1182776124
WHERE userid = 11979 |
| 55306 | almase7_avaforum | localhost | almase7_jesuhelpmeforgiveme | Query | 3 | Locked | REPLACE INTO datastore
(title, data, unserialize)
VALUES
('cron', '1182776400', 0) |

Do you need us to disable tables locks to prevent the issue ?

==================================================

I asked in vB forum and they told me to ask you here...
So what I can do now???

Thanks a lot
George

[orban]

SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1182773738 AND open 10, 1, 0)) AS newthread

Where is this query coming from? Are you sure it's from vB itself and not from an addon?