XenForo Cleaning MySql (xf_data_registry,xf_template_compiled,xf_admin_log)

[BamBam]

FYI for others... the reported numbers were wrong. Running an optimize on the tables fixed it.

Could you please tell me, whats the command to optimize the Tables? I have Direct Admin, and there is Optimize MYSQL Command, dont know if this is the same. Because my xf_template_compiled has a size of 27 MB, with only 2 Styles installed. Is this normal?

 

[vinhtq]

Ihave the same problem too, could you plz @Jake Bunce tell me hoqw to optimze it, or if you are free, i will give you my database like @justadam .

Thank you.

 

[Jake Bunce]

Here is a guide for optimizing tables using phpmyadmin:

http://www.siteground.com/tutorials/phpmyadmin/phpmyadmin_optimize_database.htm