The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Weird TEMP table
Hi,
I found a new table in the database that named taggregate_temp_1291546560, and it's type is MEMORY. Is this normal ? or it's somehow a problem ? And what should I do exactly ? Thanks. |
#2
|
|||
|
|||
That's created by the threadviews cron process (includes/cron/threadviews.php) that runs once an hour to update the thread view counts (if you have that option selected in the acp). It's supposed to be dropped when the process is done with it. I don't really know much about mysql admin, but if it's been there for a while (like more than an hour) then I don't see why you couldn't drop it.
|
#3
|
|||
|
|||
Quote:
Thanks kh99, I guess that the number 1291546560 at the end of the table's name is a UNIX-Time-Stamp, and if it's true then that seems like the table is here for more than a month but I didn't notice it ! I think I have to remove it, but I'm somehow afraid of doing this. What's your opinion ? |
#4
|
|||
|
|||
I think you can safely remove it. The very worst case would be that you'd lose an hour's worth of thread view counts, but that would only happen if a process is currently running that's trying to use it, and I don't see how that's possible. And like I said, I don't know mysql that well, but being a temp memory table, I'm guessing it would go away if you restarted mysql.
|
#5
|
|||
|
|||
Thanks kh99 a lot for your help .
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|