b2evolution b2evolution

  • Sign in
  • Sign up
  • About
  • Downloads
  • Hosting
  • Docs
  • Support
  • Sign in
  • Sign up
  • Manuals Home
  • Latest Updates
 
  1. b2evolution CMS User Manual
  2. Developer Reference
  3. Scheduled Tasks Reference
  4. Heavy DB maintenance (CHECK & OPTIMIZE)

Heavy DB maintenance (CHECK & OPTIMIZE)

This job will perform heavy maintenance on your b2evolution database tables (equivalent to the MySQL CHECK & OPTIMIZE commands).

This may put some serious strain on your server. Don’t schedule this to run too frequently. Once per week at a low traffic time is reasonable. Maybe in the night from saturday to sunday? It all depends on your personal traffic patterns.

Created by fplanque • Last edit by fplanque on 2020-06-09 00:20 • •

No feedback yet

Search the Manual

Content Hierarchy

  • b2evolution CMS User Manual
  • User's Guide
  • Installation / Upgrade
  • Front-office Reference
  • Back-office Reference
  • Developer Reference
    • Website Skins/Themes
    • Email Skins/Themes
    • b2evolution Files
    • Website Integration
    • Plugins
    • Debugging
    • Technical Reference
    • Hacks
    • Credits
    • Development
    • How to... (Customize)
    • Scheduled Tasks Reference
      • Poll the antispam blacklist
      • Process the return path inbox
      • Manage email address statuses
      • Send reminders about non-activated accounts
      • Send reminders about inactive accounts
      • Execute automations
      • Create posts by email
      • Send notifications about new comment on «item title»
      • Send notifications for «item title»
      • Send a chunk of emails for the campaign "email campaign name"
      • Send reminders about comments awaiting moderation
      • Send reminders about posts awaiting moderation
      • Monthly alert on stale contents
      • Extract info from hit log ("Process hit log")
      • Prune old hits & sessions (includes OPTIMIZE)
      • Send reminders about unread messages
      • Basic test job
      • Error test job
      • Clean up scheduled jobs older than a threshold
      • Clean up email logs older than a threshold
      • Heavy DB maintenance (CHECK & OPTIMIZE)
      • Light DB maintenance (ANALYZE)
      • Prune old files from page cache
      • Prune recycled comments
  • Operations Reference
  • Advanced Topics
  • Glossary
  • Archives
RWD CMS

This online manual is powered by b2evolution CMS – A complete engine for your website.

About b2evolution

  • What is it?
  • Features
  • Getting Started
  • Screenshots
  • Online demo
  • Testimonials
  • Design philosophy
  • Free & open source
  • Terms of service

Downloads

  • Latest releases
  • Skins
  • Plugins
  • Language packs

About us

  • About us
  • Contact

Webhosting Guide

  • Web hosting blog
  • Best web hosting
  • Cheap web hosting
  • Green web hosting
  • Hosting with SSH
  • VPS hosting
  • Dedicated servers
  • Reseller hosting
  • Int'l: UK / France

Docs & Support

  • Online manual
  • Forums
  • Hire a pro !

Other

  • Adsense
  • Press room
  • Privacy policy

Stay in touch

  • GitHub
  • Twitter
  • Facebook
  • LinkedIn
  • News blog
  • RSS feed
  • Atom feed

Founded & Maintained by François Planque