In under 24 hours, I had a server crash twice. On the console I could see something about MySQL running out of memory, but other than that, I could not do much with the system other than pressing the reset-button. For some reason, the WordPress table “wp_postmeta” was about 46 megabytes (about 550,000 records), and trying to do something with that table resulted in timeouts etc. I could see the table contained a lot of records with meta_key = “_utw_tags_” and meta_key = “_utw_tags_0”. UTW is Ultimate Tag Warrior, but that’s a plugin active when I write a post, not when visitors access my blog.
\nSo I performed the following command:<\/p>\n
\ndelete FROM `wp_postmeta` where `meta_key`= \"_utw_tags_\" or `meta_key`=\"_utw_tags_0\"\n<\/pre>\nThat deleted about 540,000 records, and now the weblog is very responsive again, and the server is a lot less busy. That’s a good thing, right?<\/p>\n","protected":false},"excerpt":{"rendered":"
In under 24 hours, I had a server crash twice. On the console I could see something about MySQL running out of memory, but other than that, I could not do much with the system other than pressing the reset-button. For some reason, the WordPress table “wp_postmeta” was about 46 megabytes (about 550,000 records), and […]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-856","post","type-post","status-publish","format-standard","hentry","category-uncategorized","category-1-id","post-seq-1","post-parity-odd","meta-position-corners","fix"],"_links":{"self":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/856","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/comments?post=856"}],"version-history":[{"count":0,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/856\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/media?parent=856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/categories?post=856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/tags?post=856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}