{"id":2551,"date":"2014-05-22T21:09:14","date_gmt":"2014-05-22T20:09:14","guid":{"rendered":"http:\/\/www.workshop.ch\/openmind\/?p=2551"},"modified":"2014-05-29T07:33:32","modified_gmt":"2014-05-29T06:33:32","slug":"wie-man-eine-wordpress-datenbank-wartet","status":"publish","type":"post","link":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/","title":{"rendered":"Wie man eine WordPress-Datenbank wartet"},"content":{"rendered":"<figure id=\"attachment_2553\" aria-describedby=\"caption-attachment-2553\" style=\"width: 511px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2553\" src=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_1.png\" alt=\"Verursacht unn\u00f6tig grosse WordPress-Datenbanken: der \u00dcberhang\" width=\"521\" height=\"223\" srcset=\"https:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_1.png 521w, https:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_1-300x128.png 300w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><\/a><figcaption id=\"caption-attachment-2553\" class=\"wp-caption-text\">Verursacht unn\u00f6tig grosse WordPress-Datenbanken: der \u00dcberhang<\/figcaption><\/figure>\n<p>Dieses Blog ist beliebt &#8211; nicht zuletzt bei Spammern. W\u00e4hrend ich diese Zeilen schreibe treffen etwa ein halbes Dutzend Spam-Kommentare pro Minute(!) ein. Dank <a href=\"http:\/\/akismet.com\/wordpress\/\">Akismeth<\/a> wandert dieser Wortm\u00fcll zwar direkt ins Spam-Verzeichnis, belastet aber immer noch unn\u00f6tig meine Datenbank. Und obwohl es im WordPress-Backend die M\u00f6glichkeit gibt, Spam-Kommentare dauerhaft zu l\u00f6schen (unter <em>Kommentare &gt; Spam &gt; Spam leeren<\/em>), ist die Datenbank-Tabelle <em>wp_comments<\/em> nach einer solchen S\u00e4uberungsaktion kein Bit kleiner. Warum ist das so &#8211; und was tut man dagegen?<\/p>\n<p><!--more--><\/p>\n<h2>Der \u00dcberhang &#8211; unbenutzter Speicherplatz in MySQL-Datenbanken<\/h2>\n<p>L\u00e4sst man sich in <a href=\"http:\/\/www.phpmyadmin.net\/\">phpMyAdmin<\/a> die Datenbankstruktur anzeigen, dann wird rasch klar, wo das Problem liegt: Den L\u00f6wenanteil des Speicherplatzes belegen nicht die wenigen verbliebenen Datens\u00e4tze, sondern der \u00dcberhang (engl. Overhead) in der letzten Spalte. Dabei handelt es sich um nicht mehr benutzten Speicherplatz, der durch die L\u00f6schung der Spam-Kommentare frei geworden ist. Leider optimiert MySQL die Datenbankdateien nicht selbst\u00e4ndig &#8211; mit phpMyAdmin l\u00e4sst sich dies aber leicht manuell tun.<\/p>\n<p>Zun\u00e4chst klickt man auf die Zahl, welche die Gr\u00f6sse des \u00dcberhangs angibt. Dadurch gelangt man auf die Struktur\u00fcbersicht der entsprechenden Tabelle. Unten an der Seite im Bereich <em>Information<\/em> wird der Speicherplatzverbrauch dieser Tabelle detailliert aufgeschl\u00fcsselt:<\/p>\n<figure id=\"attachment_2554\" aria-describedby=\"caption-attachment-2554\" style=\"width: 615px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2554\" src=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_2.png\" alt=\"Speicherplatzverbrauch einer MySQL-Tabelle\" width=\"625\" height=\"341\" srcset=\"https:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_2.png 625w, https:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_2-300x164.png 300w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/a><figcaption id=\"caption-attachment-2554\" class=\"wp-caption-text\">Speicherplatzverbrauch einer MySQL-Tabelle<\/figcaption><\/figure>\n<p>In unserem Beispiel belegen die eigentlichen Daten also nur gerade 4.4 MiB, w\u00e4hrend sagenhafte 364.6 MiB sinnlos den Server belasten. Aber nicht mehr lange: Ein Klick auf den Link &#171;Optimiere Tabelle&#187; gen\u00fcgt, und phpMyAdmin befreit die Datenbankdatei innert Sekunden von unbenutztem Speicher. Seien Sie \u00fcbrigens nicht \u00fcberrascht, wenn die Datenbanktabelle sogar noch kleiner geworden ist, als Sie erwarten w\u00fcrden &#8211; Ihre Daten sind trotzdem noch da (wie man anhand der Anzahl der Datens\u00e4tze in der rechten Spalte unschwer erkennen kann).<\/p>\n<figure id=\"attachment_2556\" aria-describedby=\"caption-attachment-2556\" style=\"width: 616px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2556 size-full\" src=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_3.png\" alt=\"Speicherplatzbedarf nach der Optimierung mit phpMyAdmin\" width=\"626\" height=\"342\" srcset=\"https:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_3.png 626w, https:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_3-300x164.png 300w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><\/a><figcaption id=\"caption-attachment-2556\" class=\"wp-caption-text\">Speicherplatzbedarf nach der Optimierung mit phpMyAdmin<\/figcaption><\/figure>\n<p>Statt nun aber jede Tabelle mit \u00dcberhang einzeln zu optimieren gibt es auch eine bequeme Abk\u00fcrzung: In der Struktur\u00fcbersicht der gesamten Datenbank klickt man unten zuerst <em>Tabellen mit \u00dcberhang ausw\u00e4hlen<\/em> und ruft dann den Befehl <em>Optimiere Tabelle<\/em> auf.<\/p>\n<figure id=\"attachment_2558\" aria-describedby=\"caption-attachment-2558\" style=\"width: 670px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2558\" src=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_4.png\" alt=\"Alle Tabellen mit \u00dcberhang ausw\u00e4hlen und optimieren\" width=\"680\" height=\"399\" srcset=\"https:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_4.png 703w, https:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_4-300x176.png 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/a><figcaption id=\"caption-attachment-2558\" class=\"wp-caption-text\">Alle Tabellen mit \u00dcberhang ausw\u00e4hlen und optimieren<\/figcaption><\/figure>\n<h2>Plug-ins zur Wartung eines WordPress Blogs<\/h2>\n<p>Auch wenn es technisch nicht besonders anspruchsvoll ist: Es ist wahrscheinlich nicht jedermanns Sache, mit phpMyAdmin die Datenbank manuell aufzur\u00e4umen. Es gibt aber auch Plug-ins, welche solche Dienste anbieten, beispielsweise <a href=\"https:\/\/wordpress.org\/plugins\/wp-optimize\/\">WP-Optimize<\/a> oder <a href=\"http:\/\/wordpress.org\/plugins\/wp-database-optimizer\/\">WP Database Optimizer<\/a>. Der Vorteil solcher Plug-ins besteht darin, dass man lediglich Zugriff auf das WordPress-Backend ben\u00f6tigt, um sie zu nutzen. Ausserdem kann die Datenbank-Optimierung so auch automatisiert werden.<span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:67,&quot;href&quot;:&quot;http:\\\/\\\/akismet.com\\\/wordpress&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20250926030204\\\/https:\\\/\\\/akismet.com\\\/wordpress\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-03 17:18:37&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-15 21:38:58&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-28 19:51:41&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-17 16:41:32&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-31 06:42:47&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-08 19:57:58&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-28 06:05:04&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-09 20:29:28&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-03-14 21:22:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-19 10:36:37&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-03-22 18:24:57&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-27 04:45:54&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-02 13:38:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-06 21:44:12&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-11 14:34:36&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-15 02:12:36&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-04-15 02:12:36&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:68,&quot;href&quot;:&quot;http:\\\/\\\/www.phpmyadmin.net&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251012171531\\\/https:\\\/\\\/www.phpmyadmin.net\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-03 17:18:39&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-08 16:51:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-15 10:34:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-25 16:47:33&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-29 01:34:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-05 14:27:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-13 07:21:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-20 02:18:32&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-23 12:12:57&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-30 09:31:57&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-05 21:10:06&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-02-09 16:02:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-14 09:06:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-18 04:19:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-24 19:59:11&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-28 22:44:11&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-03-06 18:21:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-10 13:00:59&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-18 02:11:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-22 05:01:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-25 09:25:06&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-03-28 09:49:34&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-31 10:52:42&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-04 01:16:17&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-07 10:08:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-11 02:57:58&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-14 20:06:00&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-18 03:50:35&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-21 08:07:43&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-24 09:40:38&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-27 10:40:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-01 04:50:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-04 04:52:34&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-08 07:18:45&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-12 22:19:51&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-05-12 22:19:51&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:69,&quot;href&quot;:&quot;https:\\\/\\\/wordpress.org\\\/plugins\\\/wp-optimize&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251006121351\\\/https:\\\/\\\/wordpress.org\\\/plugins\\\/wp-optimize\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-03 17:18:42&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-22 18:25:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-08 20:25:09&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-15 02:12:37&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-04-15 02:12:37&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:70,&quot;href&quot;:&quot;http:\\\/\\\/wordpress.org\\\/plugins\\\/wp-database-optimizer&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20250613112301\\\/https:\\\/\\\/wordpress.org\\\/plugins\\\/wp-database-optimizer\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-03 17:18:45&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-22 18:25:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-08 20:25:09&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-15 02:12:37&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-04-15 02:12:37&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;}]\"><\/span><\/p>\n<!--CusAds0-->\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Dieses Blog ist beliebt &#8211; nicht zuletzt bei Spammern. W\u00e4hrend ich diese Zeilen schreibe treffen etwa ein halbes Dutzend Spam-Kommentare pro Minute(!) ein. Dank Akismeth wandert dieser Wortm\u00fcll zwar direkt ins Spam-Verzeichnis, belastet aber immer noch unn\u00f6tig meine Datenbank. Und obwohl es im WordPress-Backend die M\u00f6glichkeit gibt, Spam-Kommentare dauerhaft zu l\u00f6schen (unter Kommentare &gt; Spam &#8230; <a title=\"Wie man eine WordPress-Datenbank wartet\" class=\"read-more\" href=\"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/\" aria-label=\"Read more about Wie man eine WordPress-Datenbank wartet\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":""},"categories":[1542,27],"tags":[],"class_list":["post-2551","post","type-post","status-publish","format-standard","hentry","category-datenbanken","category-wordpress"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Wie man eine WordPress-Datenbank wartet - Open Mind<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie man eine WordPress-Datenbank wartet - Open Mind\" \/>\n<meta property=\"og:description\" content=\"Dieses Blog ist beliebt &#8211; nicht zuletzt bei Spammern. W\u00e4hrend ich diese Zeilen schreibe treffen etwa ein halbes Dutzend Spam-Kommentare pro Minute(!) ein. Dank Akismeth wandert dieser Wortm\u00fcll zwar direkt ins Spam-Verzeichnis, belastet aber immer noch unn\u00f6tig meine Datenbank. Und obwohl es im WordPress-Backend die M\u00f6glichkeit gibt, Spam-Kommentare dauerhaft zu l\u00f6schen (unter Kommentare &gt; Spam ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/\" \/>\n<meta property=\"og:site_name\" content=\"Open Mind\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-22T20:09:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-05-29T06:33:32+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_1.png\" \/>\n<meta name=\"author\" content=\"The Open Source Guy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschrieben von\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Open Source Guy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/\"},\"author\":{\"name\":\"The Open Source Guy\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#\\\/schema\\\/person\\\/74ece7dcefab45da1c0cc78b2e48d793\"},\"headline\":\"Wie man eine WordPress-Datenbank wartet\",\"datePublished\":\"2014-05-22T20:09:14+00:00\",\"dateModified\":\"2014-05-29T06:33:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/\"},\"wordCount\":457,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/uploads\\\/2014\\\/05\\\/wordpress_mysql_overhead_1.png\",\"articleSection\":[\"Datenbanken\",\"WordPress\"],\"inLanguage\":\"de-CH\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/\",\"url\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/\",\"name\":\"Wie man eine WordPress-Datenbank wartet - Open Mind\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/uploads\\\/2014\\\/05\\\/wordpress_mysql_overhead_1.png\",\"datePublished\":\"2014-05-22T20:09:14+00:00\",\"dateModified\":\"2014-05-29T06:33:32+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#\\\/schema\\\/person\\\/74ece7dcefab45da1c0cc78b2e48d793\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/#breadcrumb\"},\"inLanguage\":\"de-CH\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de-CH\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/uploads\\\/2014\\\/05\\\/wordpress_mysql_overhead_1.png\",\"contentUrl\":\"http:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/uploads\\\/2014\\\/05\\\/wordpress_mysql_overhead_1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2014\\\/05\\\/22\\\/wie-man-eine-wordpress-datenbank-wartet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie man eine WordPress-Datenbank wartet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#website\",\"url\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/\",\"name\":\"Open Mind\",\"description\":\"Open Source &amp; Open Content\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de-CH\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#\\\/schema\\\/person\\\/74ece7dcefab45da1c0cc78b2e48d793\",\"name\":\"The Open Source Guy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de-CH\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/plugins\\\/avatar-privacy\\\/public\\\/images\\\/mystery.svg\",\"url\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/plugins\\\/avatar-privacy\\\/public\\\/images\\\/mystery.svg\",\"contentUrl\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/plugins\\\/avatar-privacy\\\/public\\\/images\\\/mystery.svg\",\"caption\":\"The Open Source Guy\"},\"url\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie man eine WordPress-Datenbank wartet - Open Mind","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/","og_locale":"de_DE","og_type":"article","og_title":"Wie man eine WordPress-Datenbank wartet - Open Mind","og_description":"Dieses Blog ist beliebt &#8211; nicht zuletzt bei Spammern. W\u00e4hrend ich diese Zeilen schreibe treffen etwa ein halbes Dutzend Spam-Kommentare pro Minute(!) ein. Dank Akismeth wandert dieser Wortm\u00fcll zwar direkt ins Spam-Verzeichnis, belastet aber immer noch unn\u00f6tig meine Datenbank. Und obwohl es im WordPress-Backend die M\u00f6glichkeit gibt, Spam-Kommentare dauerhaft zu l\u00f6schen (unter Kommentare &gt; Spam ... Read more","og_url":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/","og_site_name":"Open Mind","article_published_time":"2014-05-22T20:09:14+00:00","article_modified_time":"2014-05-29T06:33:32+00:00","og_image":[{"url":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_1.png","type":"","width":"","height":""}],"author":"The Open Source Guy","twitter_card":"summary_large_image","twitter_misc":{"Geschrieben von":"The Open Source Guy","Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/#article","isPartOf":{"@id":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/"},"author":{"name":"The Open Source Guy","@id":"https:\/\/www.workshop.ch\/openmind\/#\/schema\/person\/74ece7dcefab45da1c0cc78b2e48d793"},"headline":"Wie man eine WordPress-Datenbank wartet","datePublished":"2014-05-22T20:09:14+00:00","dateModified":"2014-05-29T06:33:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/"},"wordCount":457,"commentCount":0,"image":{"@id":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/#primaryimage"},"thumbnailUrl":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_1.png","articleSection":["Datenbanken","WordPress"],"inLanguage":"de-CH","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/","url":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/","name":"Wie man eine WordPress-Datenbank wartet - Open Mind","isPartOf":{"@id":"https:\/\/www.workshop.ch\/openmind\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/#primaryimage"},"image":{"@id":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/#primaryimage"},"thumbnailUrl":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_1.png","datePublished":"2014-05-22T20:09:14+00:00","dateModified":"2014-05-29T06:33:32+00:00","author":{"@id":"https:\/\/www.workshop.ch\/openmind\/#\/schema\/person\/74ece7dcefab45da1c0cc78b2e48d793"},"breadcrumb":{"@id":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/#breadcrumb"},"inLanguage":"de-CH","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/"]}]},{"@type":"ImageObject","inLanguage":"de-CH","@id":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/#primaryimage","url":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_1.png","contentUrl":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2014\/05\/wordpress_mysql_overhead_1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.workshop.ch\/openmind\/2014\/05\/22\/wie-man-eine-wordpress-datenbank-wartet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.workshop.ch\/openmind\/"},{"@type":"ListItem","position":2,"name":"Wie man eine WordPress-Datenbank wartet"}]},{"@type":"WebSite","@id":"https:\/\/www.workshop.ch\/openmind\/#website","url":"https:\/\/www.workshop.ch\/openmind\/","name":"Open Mind","description":"Open Source &amp; Open Content","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.workshop.ch\/openmind\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de-CH"},{"@type":"Person","@id":"https:\/\/www.workshop.ch\/openmind\/#\/schema\/person\/74ece7dcefab45da1c0cc78b2e48d793","name":"The Open Source Guy","image":{"@type":"ImageObject","inLanguage":"de-CH","@id":"https:\/\/www.workshop.ch\/openmind\/wp-content\/plugins\/avatar-privacy\/public\/images\/mystery.svg","url":"https:\/\/www.workshop.ch\/openmind\/wp-content\/plugins\/avatar-privacy\/public\/images\/mystery.svg","contentUrl":"https:\/\/www.workshop.ch\/openmind\/wp-content\/plugins\/avatar-privacy\/public\/images\/mystery.svg","caption":"The Open Source Guy"},"url":"https:\/\/www.workshop.ch\/openmind"}]}},"_links":{"self":[{"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/posts\/2551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/comments?post=2551"}],"version-history":[{"count":6,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/posts\/2551\/revisions"}],"predecessor-version":[{"id":2569,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/posts\/2551\/revisions\/2569"}],"wp:attachment":[{"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/media?parent=2551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/categories?post=2551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/tags?post=2551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}