PDA

View Full Version : 100 taggregate_temp_12xxxxxxxxx tables?


Idlewilder
Fri 4th Apr '08, 11:48am
I just looked in my database and there's at least 100, maybe 100-200 of these tables, all with different time stamps:

taggregate_temp_1200416160
taggregate_temp_1200419760
taggregate_temp_1200423360
taggregate_temp_1200426960
taggregate_temp_1200430560

etc etc

What's this all about? This doesn't right as vB is usually so efficient?

I'm running 370rc2 now, but I can't be sure when these tables first started to appear.
Any advice or information would be super :)

mlx
Fri 4th Apr '08, 12:22pm
Well, that timestamp is when they first appeared ;)

These temporary tables are usually deleted after the vB cron script is finished. There were some bugs like the following in the past though: http://www.vbulletin.com/forum/project.php?issueid=22003

You can safely delete these taggregate_temp_* tables.

Wayne Luke
Fri 4th Apr '08, 12:50pm
These were not deleted due to a bug in an earlier version of 3.6.X. You can safely delete these tables from your database. If they reoccur, then you need to make sure that your database user has permission to delete tables properly.

Idlewilder
Fri 4th Apr '08, 12:50pm
Thanks! They seem to be from mid jan to late jan. Didn't think of looking up the timestamps lol

Eventually deleted them all, seems fine. Thank you :)