Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
litespeed_wiki:cache:lscwp:management:db-optimizer [2019/04/12 18:46]
Lisa Clarke [LiteSpeed Cache for WordPress Management: DB Optimizer] 		litespeed_wiki:cache:lscwp:management:db-optimizer [2020/11/14 15:18] (current)
Lisa Clarke Redirect to new Documentation Site
Line 1: Line 1:
-====== LiteSpeed Cache for WordPress Management: DB Optimizer ====== +~~REDIRECT>​https://docs.litespeedtech.com/​lscache/​lscwp/​database/​~~
- +
-Database optimization is a useful tool when it comes to speeding up your site. LSCWP'​s DB Optimizer (available as of v1.2.1) gives you an easy way to execute some of these tasks in your WordPress database. [[https://blog.litespeedtech.com/​2017/09/​20/​wpw-database-optimization/​|Learn more on our blog.]] +
- +
-{{:​litespeed_wiki:​cache:​lscwp:​lscwp-management-dboptimizer.png?​nolink|}} +
- +
-You'll notice that some of the buttons have teal check-marks while others have red X's. The check marks indicate that the area has already been cleaned-up. If you see a red X, that is your opportunity to do some optimization. +
- +
-===== Clean All ===== +
- +
-Press this button to clean up everything at once. It executes all of the listed cleanups, except for **Optimize Tables** and **Clean CSS/JS Optimizer**. +
- +
-===== Post Revisions ===== +
- +
-Removes all old post revisions from the database. You will sacrifice your ability to go into any of your post and restore previous versions of them. Only the currently-published version of each post will be saved. +
- +
-===== Auto Drafts ===== +
- +
-When you edit a post, WordPress automatically saves drafts now and then. This is to protect you in case you unexpectedly lose your connection, or your computer crashes. If you know that all of your posts are either published or saved correctly as drafts, then it is safe to remove the automatic drafts. +
- +
-===== Trashed Posts ===== +
- +
-This option permanently deletes any posts or pages that have been placed in the Trash. +
- +
-===== Spam Comments ===== +
- +
-There should be no need to keep comments that have been marked as spam. This option erases them permanently. +
- +
-===== Trashed Comments ===== +
- +
-This option permanently deletes any comments that have been placed in the Trash. +
- +
-===== Trackbacks & Pingbacks ===== +
- +
-When other blogs link to you, it can create trackbacks or pingbacks. Some WordPress themes display these in the comments section. If displaying these external links is not important to you, press this button to clear them from the database. +
- +
-===== Expired Transients ===== +
- +
-Transients are the result of a form of caching that can happen in the WordPress database with the results of remote API calls. This option clears all of the expired transients from the database. +
- +
-===== All Transients ===== +
- +
-This option clears all of the transients in the database, whether expired or not. NOTE: It is normal for there to still be some transients left after cleaning. Transients are caused by plugins, and are regenerated every time you reload a page. +
- +
-===== Optimize Tables ===== +
- +
-Use this button to optimize the database tables. NOTE: This function is not included in a **Clean All**. +
- +
-===== Clean CSS/JS Optimizer ===== +
- +
-If you use the Minification and/or Combination functions for CSS and/or Javascript, you can clean up the related data with this button. NOTE: This function is not included in a **Clean All**.+
  • Admin
  • Last modified: 2020/11/14 15:18
  • by Lisa Clarke