Unwanted tables getting created at mysql.

[donal]

I dont know why unwanted tables get created at mysql. These make my site slow and I have to remove them from time to time.

Sometimes there have been more then 1000 such tables which took me whole day to delete.

How can I get rid of this problem.

[Farcaster]

No, those are tables that he is talking about. And I would imagine that they are probably making his site slow because they are being stored in memory (HEAP). I've never noticed vBulletin creating any temp tables like that. Out of curiosity, does the mySQL login you are using for vBulletin have DROP TABLE permissions? Perhaps these aren't getting cleaned up because vBulletin cannot drop the tables.

[Opserty]

Ah yeah your right.

Anyway I found some info:

http://www.vbulletin.com/forum/showthread.php?t=259558
http://www.vbulletin.com/forum/showthread.php?p=1506511

Check your MySQL login permissions basically.

[donal]

I checked and found that I have drop table permission.

[Dismounted]

Are your vBulletin scheduled tasks running?

[donal]

Are your vBulletin scheduled tasks running?

Yes they are running fine. I tried to run them manually and found no problem.