WP-Optimize

Beschreibung

WP-Optimize is an effective tool for automatically cleaning your WordPress database so that it runs at maximum efficiency.

Major Features

  • Removes all unnecessary data (e.g. trashed/unapproved/spam comments, stale data) plus pingbacks, trackbacks and expired transient options
  • Compact/de-fragment MySQL tables with a button-press
  • Detailed control of which optimizations you wish to carry out
  • Carries out automatic weekly (or otherwise) clean-ups
  • Retains a set number of weeks‘ data during clean-ups
  • Führt Optimierungen durch, ohne dass manuelle Abfragen ausgeführt werden müssen
  • Automatically trigger a pre-optimize backup via UpdraftPlus (https://updraftplus.com)
  • Zeigt Datenbankstatistiken und mögliche Einsparungen an
  • Mobil freundlich und einfach zu bedienen
  • Übersetzt in mehrere Sprachen
  • Es ist mehr geplant!

WP-Optimize helps you to:

  • Make space: When you edit a post or page on your website, WordPress automatically saves the new revision to the database. If you edit things a few times (and particularly if the post is long), your database soon gets clogged up with old revisions that just sit there, taking up valuable space. WP-Optimize removes these unnecessary post revisions, freeing up valuable Megabytes of data and increasing speed and efficiency. It also cleans up your comments table, removing all the spam and un-approved comments that have built up with a single click.

  • Take control: WP-Optimize reports on exactly which of your database tables have overhead and wasted space, giving you the insight, control and power to keep your website neat, fast and efficient.

  • Keep it clean: Once enabled, WP-Optimize can run an automatic clean-up on a schedule, keeping a selected number of weeks‘ data, according to your specification.

When you use this plugin for the first time or just updated to major version, make a backup of your database (we recommend UpdraftPlus). Though none of the queries used are dangerous, it is always the best practice to make a database backup before altering your database.

How this could help you?

  • The tables in MySQL (the database that WordPress uses) will, over time, become inefficient as data is added, removed, moved around. Asking MySQL to optimize its tables every now and again will keep your site running as fast as possible. It won’t happen by itself.

  • Every-time you save a new post or pages, WordPress creates a revision of that post or page. If you edit a post 6 times you might have 5 copy of that post as revisions. This quickly adds lots of rarely-used data to your database tables, making them unnecessarily bloated, and slower to access.

  • Ähnlich wie bei dem oben beschriebenen Szenario, gibt es möglicherweise Tausende von Spam und nicht genehmigte Kommentare in deiner Kommentar-Tabelle. WP-Optimize kann dies mit einem einzigen Klick reinigen und entfernen.

  • WP-Optimize reports which database tables have overhead and wasted spaces also it allows you to shrink and get rid of those wasted spaces.

  • Automatically cleans database every week and respects the „Keeps selected number of weeks data“ option.

Entwickler

If you interested in the development of this plugin, join with us at our GitLab: https://source.updraftplus.com/team-updraft/wp-optimize/ (but please file all support questions in the wordpress.org system).

Übersetzungen

Translators are welcome to contribute to the plugin. Please use the WordPress translation website.

Screenshots

  • The main optimizer Screen
  • UpdraftPlus running a backup before an optimization proceeds
  • Tabellenbericht
  • Einstellungen

Installation

There are 3 different ways to install WP-Optimize, as with any other wordpress.org plugin.

Using the WordPress dashboard

  1. Navigate to the ‚Add New‘ in the plugins dashboard
  2. Suche nach ‚WP-Optimize‘
  3. ‚Jetzt installieren‘ anklicken
  4. Das Plugin über das Plugin-Dashboard aktivieren

Uploading in WordPress Dashboard

  1. Download the latest version of this plugin from https://wordpress.org/plugins/wp-optimize/
  2. Navigate to the ‚Add New‘ in the plugins dashboard
  3. Navigate to the ‚Upload‘ area
  4. Select the zip file (from step 1.) from your computer
  5. ‚Jetzt installieren‘ anklicken
  6. Das Plugin über das Plugin-Dashboard aktivieren

Unter Verwendung von FTP

  1. Download the latest version of this plugin from https://wordpress.org/plugins/wp-optimize/
  2. Unzip the zip file, which will extract the wp-optimize directory to your computer
  3. Upload the wp-optimize directory to the /wp-content/plugins/ directory in your web space
  4. Das Plugin über das Plugin-Dashboard aktivieren

FAQ

Installation Instructions

There are 3 different ways to install WP-Optimize, as with any other wordpress.org plugin.

Using the WordPress dashboard

  1. Navigate to the ‚Add New‘ in the plugins dashboard
  2. Suche nach ‚WP-Optimize‘
  3. ‚Jetzt installieren‘ anklicken
  4. Das Plugin über das Plugin-Dashboard aktivieren

Uploading in WordPress Dashboard

  1. Download the latest version of this plugin from https://wordpress.org/plugins/wp-optimize/
  2. Navigate to the ‚Add New‘ in the plugins dashboard
  3. Navigate to the ‚Upload‘ area
  4. Select the zip file (from step 1.) from your computer
  5. ‚Jetzt installieren‘ anklicken
  6. Das Plugin über das Plugin-Dashboard aktivieren

Unter Verwendung von FTP

  1. Download the latest version of this plugin from https://wordpress.org/plugins/wp-optimize/
  2. Unzip the zip file, which will extract the wp-optimize directory to your computer
  3. Upload the wp-optimize directory to the /wp-content/plugins/ directory in your web space
  4. Das Plugin über das Plugin-Dashboard aktivieren
Is optimizing my database safe?

Yes; optimizing does not involve any „tricks“ or poking around in dangerous ways. It involves running routine clean-up operations using well-defined, common MySQL commands. Nevertheless, we always recommend backups, which cover every possibility; not just database malfunctions, but hackers, human errors, etc. We recommend UpdraftPlus.

What savings can I expect to make?

This is a „how long is string?“ sort of question. It depends completely on your site – how big it is, how many users interact on it, how long it has been running, and when you last optimised it. However, the savings and speed-ups can be substantial; it is always worth making sure that your database is optimized.

How do I get support?

In our support forum, here: https://wordpress.org/support/plugin/wp-optimize/

WP-Optimize does not make large savings on my database

This is rare; it’s probably because you’re with a shared web hosting company that doesn’t allow scripts to run an optimize command via SQL statements (SQL „OPTIMIZE“ instruction). Please consult your web hosting company on this matter.

Ist das Plugin ausprobiert und getestet?

Yes – WP-Optimize is WordPress’s #1 most-installed optimization plugin, with over 500,000 users and a pedigree going back over 7 years.

Unterstützt WP-Optimize InnoDB-Tabellen?

WP-Optimize will disable some features if it detects InnoDB tables. Optimization of the database tables on-disk is not available, but other clean up features would work.

Kannst du mir bei der Wiederherstellung meiner Datenbank helfen?

I’m afraid that this is not possible. Please ensure that you make a backup of your entire database before using WP-Optimize for the first time, and when you upgrade to a major new version of it. We recommend UpdraftPlus.

Gibt es in diesem Plugin Fehler?

Das Plugin wird laufend weiterentwickelt, daher ist es unmöglich unvorhergesehene Situationen und Fehler auszuschließen. Also ich würde dir empfehlen, teste es auf deinem lokalen System oder mache eine Sicherungskopie deiner Datenbank (nur um besonders vorsichtig zu sein).

How do I stop transient options from coming back automatically each time I clear them?

When WordPress uses a particular transient, that specific transient is re-created automatically. So, it’s normaly for ones which are in active use to gradually re-appear. The best way to keep things optimal is to clear the transient options on a scheduled basis. For example, WordPress may create 50 transient option in a week. If you schedule WP-Optimize to clear these options on a weekly basis, you’ll have far fewer building up.

Tabellengröße wird falsch angezeigt / Nicht optimiert

Bitte überprüfe deine Datenbank auf korrupte Tabellen. Das kann passieren, in der Regel wenn dein Web-Hosting-Unternehmen einen Reparatur-Befehl auf der Datenbank laufen lässt.

Rezensionen

Works perfectly

It is a bit scary the first time you run it, but I’ve been using this baby for a year, and it works like a charm. Doesn’t hurt to create backups on a regular basis though.

Lies alle 782 Rezensionen

Mitwirkende & Entwickler

„WP-Optimize“ ist Open-Source-Software. Folgende Menschen haben an diesem Plugin mitgewirkt:

Mitwirkende

„WP-Optimize“ wurde in 19 Sprachen übersetzt. Danke an die Übersetzerinnen und Übersetzer für ihre Mitwirkung.

Übersetze „WP-Optimize“ in deine Sprache.

Interessiert an der Entwicklung?

Durchstöbere den Code, sieh dir das SVN Repository an oder abonniere das Entwicklungsprotokoll per RSS.

Changelog

2.1.1 – 28/Feb/2017

  • FEATURE: Added the ability to take a automatic backup with UpdraftPlus (https://updraftplus.com) before an optimization
  • FEATURE: When optimizing from the dashboard, tables are now optimized one by one, to reduce the scope for timeouts
  • FIX: Removal of sitemeta items from main site on multisite install was not proceeding
  • TWEAK: Adding premium bootstrapping to WP-Optimize for adding premium features in the future
  • TWEAK: A few wording tweaks, plus automatically refresh the page if the ‚admin bar menu‘ option is changed
  • TWEAK: Introduce internal logging API

2.1.0 – 28/Dec/2016

  • FOCUS: This release concentrates upon the user-interface, and in particular upon improving the clarity of each part, and making optimizations, saves and other actions possible without page reloads.
  • FEATURE: Any optimisation can now be run individually with a single button press
  • TWEAK: All optimisations run via the dashboard page are now run via AJAX (no page refresh)
  • TWEAK: Settings saving now takes place via AJAX (no page refresh)
  • TWEAK: Navigation between different tabs now takes place without a page refresh
  • TWEAK: The „trackback/comments“ actions section now operates via AJAX (no page refresh needed)
  • TWEAK: „Refresh“ button in the „Status“ widget now refreshes via AJAX (no page refresh needed)
  • TWEAK: When saving settings or running an optimization, the „Status“ widget now automatically refreshes
  • TWEAK: Make the admin bar menu into a drop-down, making it quicker to access individual tabs
  • TWEAK: Call set_time_limit to reduce the chances of PHP self-terminating via reaching max_execution_time
  • TWEAK: Introduce dashboard notice infrastructure
  • TWEAK: The lines showing information on how many spam/trashed posts and comments existed were incomplete

2.0.1 – 12/Dec/2016

  • OWNERSHIP: WP-Optimize is now under the leadership of Team UpdraftPlus – https://updraftplus.com. A big thank you to Ruhani (who remains on-board) for his leadership of WP-Optimize until this point! Layout, branding and links have been altered to reflect this change.
  • RE-FACTOR: Internal code completely re-factored, laying the foundations for future improvements
  • TWEAK: Various filters introduced internally for easier customisation
  • TWEAK: Marked form element labels, so that they can be clicked
  • TWEAK: Various small UI improvements (more to come in future releases)
  • FIX: Previous versions could potentially run OPTIMIZE commands on tables in the same MySQL database (if it was shared) belonging to other sites
  • FIX: Previous versions were not deleting most delete-able transients. This is now fixed, with the modification that we now delete all expired transients.
  • LANGUAGES: Removed language packs and screenshots that are already carried by wordpress.org, reducing the plugin download / install size

1.9.1

  • Ability to clean up Unused Post Meta, Comment Meta and Broken Relationship Data
  • Warning prompts for RED marked items and optimize button
  • Better transient options cleaning.
  • Sprachdateien aktualisiert
  • Various other fixes

1.9

  • 27 Weeks retention option equivalent to 6 month
  • Compatibility update.
  • Sprachdateien aktualisiert
  • Removed email notifications, it doesn’t work on many servers
  • Various other fixes

1.8.9.10

  • Security Patch provided by Dion at WordPress.org and Security report provided by http://planetzuda.com .
  • Sprachdateien aktualisiert

1.8.9.8

  • Daily Schedule Option Added
  • Email notification on automatic optimization, default email is admin email address. You can change this in settings

1.8.9.7

  • BUGFIX for Settings screen
  • Enable/Disable trackbacks / comments buttons removal and use select box instead. Extra button caused the Auto Scheduler to get into reset mode.

1.8.9.6

  • There were few number formatting problem and detection of InnoDB table format. Charles Dee Rice solved the problems that I missed out. Thank you!
  • Duplicate msg fixed
  • Aktivierung / Deaktivierung von Trackbacks in allen veröffentlichten Beiträgen
  • Aktivierung / Deaktivierung von Kommentaren in allen veröffentlichten Beiträgen

1.8.9

  • ONE MILLION+ Downloads. THANK YOU!!
  • Language updates platform – see readme file for details.
  • Mixed type tables optimization supported and in BETA
  • Entfernen der Akismet-Metadaten von Kommentaren
  • Entfernen von anderen veralteten Metadaten von Kommentaren
  • InnoDB-Tabellen werden nicht optimiert.
  • Main screen user selection will be saved. Red items selection will not be saved
  • Scheduled time display will be shown according to WordPress blog local time

1.8.6

  • Sprachdateien aktualisiert
  • Fix issues with total gain number problem
  • InnoDB tables detected and features disabled automatically, tables view will not show Overhead. Main view will not show space saved, or total gain.

1.8.5

  • Version bump + modified translator names

1.8.4

  • Problem with readme file changes

1.8.3

  • kleinere Fehlerkorrekturen

1.8.1

  • Eine ganze Menge mehr Code-Optimierung
  • Slick new interface
  • Responsive mobile interface, supports running from iPhone/Android/Tablets
  • Tabellen verschoben in einen eigenständigen Tab
  • Optimize faster
  • GitHub Updater Unterstützung
  • I do not monitor WP forums, support email at plugins(at)ruhanirabin.com

1.7.4

  • More Translation compatibility.
  • MYSQL- und PHP-Versionen neben dem Optimizer Tab hinzugefügt.

1.7.3

  • Probleme mit wp_Mail behoben.
  • Fixed Problems with wpAdmin menubar.
  • Berechtigungsprobleme auf einigen Webseiten behoben.
  • Sprachdateien aktualisiert

1.7.2

  • All MySQL statements re-factored into native WP database calls – necessary for future versions of MySQL and WordPress.
  • Upgrade to match WordPress 3.9 changes.
  • Sprachdateien aktualisiert
  • Now postmeta cleanup is disabled from code – it will be updated soon with native WordPress postmeta cleaning options.

1.6.2

  • Sprachdateien aktualisiert

1.6.1

  • Fixed – trashed Comments was not clearing out.
  • Sprachdateien aktualisiert

1.5.7

  • Sprachdateien aktualisiert

1.5.6

  • „Unused Tags cleanup“ option made a problem on some WordPress sites that it deletes empty categories. Since I am unable to replicate this problem. I am making this option disabled.
  • Sprachdateien aktualisiert
  • Minor maintenance and fixes.

1.5.5

  • Safe clean up options are selected by default, defaults are not by user preference for now (Optimizer Page).
  • All the potentially dangerous clean up options are MARKED RED.
  • Sprachdateien aktualisiert
  • New features explained – http://j.mp/HBIoVT (read the blog post).

1.5.4

  • More path related fixes for various warnings. Maintenance

1.5.2

  • Fatar error fix, if it disabled your wp admin, please remove the wp-optimize directory and reinstall again.

1.5.1

  • Option to add or remove link on wp admin bar (even enabled – it is visible to admin only).
  • New admin interface.
  • Settings to select items for automatic optimization.
  • Entfernen von WordPress vorübergehenden Optionen
  • Entfernen von verwaisten Post-Meta Schlagwörtern.
  • Entfernen von nicht verwendeten Schlagwörtern.
  • 3 different schedule times added (weekly, bi-weekly and monthly).
  • Sprachdateien aktualisiert
  • Code optimization and translation strings updated.
  • Integrated development log from TRAC

1.1.2

  • removed persistent admin bar menu item
  • Sprachdateien aktualisiert

1.1.1

  • Fix Fatal Error.

1.1.0

  • Added WP-Optimize to admin menu bar on top. Always accessible.
  • Added wp-optimize.pot file for translators (inside ./languages/ folder).
  • Last auto optimization timestamp / display
  • Fix possible scheduler bug as requested at support forum
  • Fix some other codes regarding SQL query parameters
  • Ability to keep last X weeks of data, any junk data before that period will be deleted – this option affects both Auto and Manual process. Appreciate time and help from Mikel King (http://mikelking.com/) about this matter.

1.0.1

  • Removed auto cleanup of trackbacks or pingbacks.. it’s better for people to do it manually.

0.9.8-beta

  • added beta tag

0.9.8

  • Remove all trackbacks and pingbacks (can significantly reduce db size)
  • Remove all Trash Comments and Posts
  • Enable/Disable weekly schedules of optimization. This is an EXPERIMENTAL feature. It may or may not work on all servers.

0.9.4

  • Non Initialized variables fixes as of https://wordpress.org/support/topic/plugin-wp-optimize-errors-in-debug-mode?replies=2

0.9.3

  • Removed security tools.
  • Full database size displayed

0.9.2

  • Now the plugin is visible to site administrators only. Authors, Contributors, Editors won’t be able to see it.

0.9.1

  • Fixed problem with database names containing „-“ .
  • NEW Main Level Menu Item added for WP-Optimize, You might need to scroll down to see it
  • Compatibilty with WordPress 3.1
  • Sprachdateien aktualisiert
  • Added auto draft post removal feature

0.8.0

  • Added Multilanguage capability
  • Sprachdateien aktualisiert

0.7.1

  • Post-Meta Tabelle Bereinigungscode entfernt, Ursache für Probleme mit vielen Hosts

0.7

  • Bereinigung der Post-Meta Tabelle gemeinsam mit den Revisionen hinzugefügt
  • Fixed some minor PHP tags which causes the total numbers to disappear
  • Nun erforderlich MySQL 5.1.x und PHP 5.1.x

0.6.5.1

  • Fix Interface