這個外掛並未在最新的 3 個 WordPress 主要版本上進行測試。開發者可能不再對這個外掛進行維護或提供技術支援,並可能會與更新版本的 WordPress 產生使用上的相容性問題。

SpectrOM DB Cleanup

外掛說明

The SpectrOM DB Cleanup tool will remove selected old and unused data in your database tables and then rebuild the MySQL indexes for all of your tables. This helps to ensure that your index files do not get corrupted and that your data can be accessed efficiently.

Support Details: We are happy to provide support and help troubleshoot issues. Users should know however, that we check the WordPress.org support forums once a week on Fridays from 10am to 12pm PST (UTC -8). Daily support and issue reports are handled via our GitHub repository here: https://github.com/spectrom/spectrom-db-cleanup/issues. Please read our support notes here before creating new issues.

The SpectrOM DB Cleanup tool was specifically designed for data-driven sites such as eCommerce, Learning Management Systems and BuddyPress.

The SpectrOM DB Cleanup Features:

  • Removal of selected old and unused data in your database tables
  • Rebuilds the MySQL indexes for all of your tables
  • Configurable so you can indicate what sections to Cleanup
  • eMail a report to indicated recipients
  • Automation at specified day and time

This DB Cleanup helps to ensure that your database index files do not get corrupted and that your data can be accessed efficiently.

Want to help make this tool even better? Participate in GitHub at https://github.com/spectrom/spectrom-db-cleanup. Or Contact SpectrOM for more information on how you can participate.

螢幕擷圖

  • Configuration page, Automation section: select how often and when to perform Cleanup.
  • Configuration page, Customization section: select which cleanup operations to perform.
  • Email report, a Sample Report generated by the SpectrOM DB Cleanup tool.

安裝方式

Installation instructions: To install, do the following:

  1. From the dashboard of your site, navigate to Plugins –> Add New.
  2. Select the “Upload Plugin” button.
  3. Click on the “Choose File” button to upload your file.
  4. When the Open dialog appears select the spectrom-db-cleanup.zip file from your desktop.
  5. Follow the on-screen instructions and wait until the upload is complete.
  6. When finished, activate the plugin via the prompt. A confirmation message will be displayed.

or, you can upload the files directly to your server.

  1. Upload all of the files in spectrom-db-cleanup.zip to your /wp-content/plugins/spectrom-db-cleanup directory.
  2. Activate the plugin through the ‘Plugins’ menu in WordPress.

Once activated, you can configure the plugin via the Settings -> SpectrOM DB Cleanup menu.

常見問題集

How often should I have the Cleanup operation scheduled.

This depends on the size of your site and how often things are being updated. If you are posting new content all the time or have several users making comments, you might want to run the Cleanup every other day. If you have an eCommerce site with several purchases made every day, running the Cleanup every day will keep the session table from becoming corrupted and ensure that users can continue using the shopping cart.

Some recommended settings:

  • Sites with 0-5,000 visitors per day should schedule the Cleanup for every seven days.
  • Sites with 5,000-10,000 visitors per day should schedule the Cleanup for every five days.
  • Sites with 10,000-30,000 visitors per day should schedule the Cleanup for every other day.
  • Sites with over 30,000 visitors per days should schedule the Cleanup for every day.
What time of day should I schedule the Cleanup?

It’s best to run the SpectrOM DB Cleanup at a time when your site has few visitors. The Cleanup can take anywhere from five seconds to as much as a minute or two, depending on the size of the database. Users can view the site during this time, but they might notice some slowness.

To find what time of day has the lowest traffic on your site, you can use Google Analytics. To do this, click on “Customization” in the top bar of your Analytics Dashboard then choose “Custom Report.”

This brings you to the report builder table. Here you can build a basic visitors and eCommerce report so you can view visitor behavior based on day of week and hour of day.

Give your report a name and set up two Metric Groups: one for Visitors and another for eCommerce.

You can add any metrics you like here by just clicking on “+ add metric” and searching for the data you need. Once you have the metrics labeled and selected, you need to choose the “Dimensions.” This is where you set day and time.

Let this report run for a couple of weeks to gather data on your user’s behavior. Then you can adjust the time that the SpectrOM DB Cleanup is run accordingly.

使用者評論

這個外掛目前沒有任何使用者評論。

參與者及開發者

以下人員參與了開源軟體〈SpectrOM DB Cleanup〉的開發相關工作。

參與者

將〈SpectrOM DB Cleanup〉外掛本地化為台灣繁體中文版

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄

變更記錄

1.0.2

  • Fix typo in plugin description.

1.0.1

  • Tested with WordPress 4.4.
  • Some code cleanup and minor optimizations.
  • Fix bug with credentials check – thanks to @jb510 for pointing that out.

1.0

  • First release.