Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
  #1  
Old 26 Jun 2007, 23:48
Ava-Kyrillos Ava-Kyrillos is offline
 
Join Date: Apr 2007
How to solve table locking ??

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
Reply With Quote
Comments
  #2  
Old 04 Jul 2007, 23:16
orban orban is offline
 
Join Date: Jan 2005
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?
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 09:42.

Layout Options | Width: Wide Color: