very huge cache in 2 days ! (2 Gigas!!)

[Blackhorse]

Hello,

Is there something wrong in my configuration, as i've noticed two gigas increase in just 36-48 hours!!

I found out it is cache table

mysql> DELETE FROM cache;
Query OK, 482358 rows affected (44.80 sec)

mysql>        DELETE FROM cacheevent;
Query OK, 815983 rows affected (39.69 sec) 

How can I control this, is it normal?

Thanx

[Wayne Luke]

It is normal for the cache tables to grow. They are used heavily by the system. If you're database user had permissions to delete from rows and you're using the INNODB table engine, this shouldn't cause a problem.

[Blackhorse]

Thank you Wayne,

but this was not the case before. It is totally a new behaviour.

[Wayne Luke]

vBulletin 5 is totally new software. it doesn't operate the same way that previous versions did. The code is different. The database structure is different. How the code interacts with the database is different. Caching mechanisms are different.