Weird TEMP table

[modyyy55]

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.

[kh99]

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.

[modyyy55]

Originally Posted by kh99

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.

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 ?

[kh99]

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.

[modyyy55]

Thanks kh99 a lot for your help .