Weird TEMP table
 

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 ?

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.