The cache tables get very large very quick.
How can I automatically Clear Cache. Via cronjob?
Anyone can help me with this?
How can I automatically Clear Cache. Via cronjob?
Anyone can help me with this?
Welcome to the vBulletin support forums! In our community forums you can receive professional support and assistance with any issues you might have with your vBulletin Products.
Useful Links for Guests:
If you are having problems posting in the relevant areas for your software, please see this topic.
SET @DATABASE_NAME = '%%YOURDATABASENAME%%'; SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements FROM information_schema.tables AS tb WHERE table_schema = @DATABASE_NAME AND `ENGINE` = 'MyISAM' AND `TABLE_TYPE` = 'BASE TABLE' AND `TABLE_NAME` NOT IN ('userfield','phrase','language') ORDER BY table_name DESC;
Comment