vb_taggregate_temp_... table grow!

[Ghostt]

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?

[Zachery]

You can just delete them, make sure your MySQL user has full permissions to the database.

[Ghostt]

thisproblem is allready long time. i dont want delete them everytime manuelly.
i need a solution.

[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.

[Ghostt]

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.:

SELECT thread.threadid, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount

[Ghostt]

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 [DATE]1401738524[/DATE] at [TIME]1401738524[/TIME] ---------------

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:

Invalid SQL:
UPDATE vbthread AS thread,vbtaggregate_temp_1401739680 AS aggregate
	SET thread.views = thread.views + aggregate.views
	WHERE thread.threadid = aggregate.threadid;

MySQL Error   : Lock wait timeout exceeded; try restarting transaction
Error Number  : 1205
Script        : /admincp/cronadmin.php?do=runcron&cronid=2
Referrer      : /admincp/cronadmin.php?do=modify
Classname     : vB_Database
MySQL Version : 5.5.34

[Ghostt]

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.

[kh99]

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.

[Ghostt]

The server load isnt high atm its at 7 avareage load.
and it loocks like this

| 40481 | db_example | localhost | db_example | Query   | 8    | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount |
| 40489 | db_example | localhost | db_example | Query   | 8    | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount |
| 40537 | db_example | localhost | db_example | Query   | 5    | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount |
| 40555 | db_example | localhost | db_example | Query   | 4    | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount |
| 40610 | db_example | localhost | db_example | Query   | 0    | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount |
| 40621 | root       | localhost |            | Query   | 0    |                | show processlist

if server is overloaded this query goes up to 200

[kh99]

Originally Posted by Ghostt

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.