Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 29 May 2014, 23:25
Ghostt Ghostt is offline
 
Join Date: Oct 2009
vb_taggregate_temp_... table grow!

i checked my mysql db, its still has over 70 temp tables like this:

vb_taggregate_temp_1400969880

this temp tables are not deleted automatically. sever manager says its because of cron job, but which one?
Reply With Quote
  #2  
Old 29 May 2014, 23:46
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
You can just delete them, make sure your MySQL user has full permissions to the database.
__________________
Looking for ImpEx?
Reply With Quote
  #3  
Old 29 May 2014, 23:54
Ghostt Ghostt is offline
 
Join Date: Oct 2009
thisproblem is allready long time. i dont want delete them everytime manuelly.
i need a solution.
Reply With Quote
  #4  
Old 29 May 2014, 23:56
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
The solution is to make sure your MySQL user has been granted ALL permissions to the database. If they don't have all permissions, like delete, then you will see the problem you are seeing.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #5  
Old 30 May 2014, 01:55
Ghostt Ghostt is offline
 
Join Date: Oct 2009
thanks ive told this to the server manager.
also found here similar idea: http://www.cutehits.com/2011/12/why-...gregate_temp_/

i ll report if its fixed.


---
what does this query mean, its all the time running.:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Last edited by Ghostt; 30 May 2014 at 15:58.
Reply With Quote
  #6  
Old 01 Jun 2014, 20:25
Ghostt Ghostt is offline
 
Join Date: Oct 2009
They dont fixed it... and i got 50 more of this tables:
vb_taggregate_temp_1401475080
what does this table create?

we dont even use TAGs for posts.


/edit maybe the solution. lets see after threadviews table repair if its ok.
http://www.vbulletin.com/forum/forum...-being-created


--------------- Added 02 Jun 2014 at 19:48 ---------------

ive set the cron for update THREAD HITS to every 10 min maybe this causing it.


it could be caused due overload timeout sometimes... ive tested run cron manuelly and sometimes this error:

Database error in vBulletin 3.8.4:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Last edited by Ghostt; 02 Jun 2014 at 20:27.
Reply With Quote
  #7  
Old 22 Jun 2014, 13:15
Ghostt Ghostt is offline
 
Join Date: Oct 2009
this "sorting result" query.
why no one can explain why this query often slow and apear all the time?

| Query | 1 | Sorting result | SELECT thread.threadid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount |

-i found this line in /tags.php

-ive set to update thread views every 20 min with cron.
sometimes this cron get timeout error tested to run manuelly .

also i used googled very long and dont find any result.


i think everytime this task crashes it created a temp table...
and this all also the query are connected.
Reply With Quote
  #8  
Old 22 Jun 2014, 13:35
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
How busy is your forum and how many posts does it have? I'm not an expert on these things but I'm curious because I'm wondering if there is some problem or if it could just be that the database is too busy.
Reply With Quote
  #9  
Old 22 Jun 2014, 13:46
Ghostt Ghostt is offline
 
Join Date: Oct 2009
The server load isnt high atm its at 7 avareage load.
and it loocks like this

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

if server is overloaded this query goes up to 200
Reply With Quote
  #10  
Old 22 Jun 2014, 13:46
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Originally Posted by Ghostt View Post
this "sorting result" query.
why no one can explain why this query often slow and apear all the time?

| Query | 1 | Sorting result | SELECT thread.threadid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount |

-i found this line in /tags.php
That looks like it might be a search for threads with a given tag. I don't know why that would happen often. I suppose you could check your web server logs and see if someone is actually doing a search, or if it's a spider or something.
Reply With Quote
  #11  
Old 22 Jun 2014, 13:53
Ghostt Ghostt is offline
 
Join Date: Oct 2009
we have many links like this as buttons:

forumdisplay.php?f=621&prefixid=example


but prefixes arent tags or? we dont even use tags,

i just want to know if this is normal this query what it does and why it comes so often?..



ps. this is ticket answer from server manager coz overload:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

but its also possible the load caused by something else and this querys hang up ?
Reply With Quote
  #12  
Old 22 Jun 2014, 13:59
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
I'm not sure, but if you're sure that the query is the one from tags.php, then I don't see how that would happen unless someone was actually requesting tags.php. You should be able to see that in the web server logs.

Or maybe there is a similar query somewhere and it's not from tags.php? If you don't use tags.php, maybe try removing that file from your server and see what happens (save a copy of course so you can put it back).
Reply With Quote
  #13  
Old 22 Jun 2014, 14:15
Ghostt Ghostt is offline
 
Join Date: Oct 2009
i allready tested renaming the tags.php. yes maybe this query is also in some other file.
whats the command to check web server query log in detail?
except this one: mysqladmin -u root -p proc stat

maybe its about thread views counter?

/Edit
its also not search.php. tested and renamed this file, query still apear

answer from support:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Last edited by Ghostt; 22 Jun 2014 at 14:56.
Reply With Quote
  #14  
Old 22 Jun 2014, 16:12
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Im not entirely sure what you are asking.

Your mysql user needs full permissions to create and delete TEMPORARY tables.

I have no idea why you are talking about tags, since they dont seem to have anything to do with the original issue.

The query (in post#6) is the cron based thread view counts update, which should be running once per hour.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #15  
Old 22 Jun 2014, 16:16
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by Ghostt View Post
The server load isnt high atm its at 7 avareage load.
On the face of it, 7 looks a high load.
How many CPU's does this server have ?
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
Reply



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

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 07:27.

Layout Options | Width: Wide Color: