[wp-trac] [WordPress Trac] #33970: Huge inflation of post_meta for oEmbed caches

WordPress Trac noreply at wordpress.org
Tue Sep 22 23:27:20 UTC 2015


#33970: Huge inflation of post_meta for oEmbed caches
--------------------------+------------------------------
 Reporter:  whyisjake     |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Embeds        |     Version:  trunk
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by whyisjake):

 What @markjaiquith [notes
 here](https://core.trac.wordpress.org/ticket/14759#comment:49) is that
 What this doesn't address: that if you never update the post, the cache
 stays indefinitely. Which is definitely the case that we are seeing. The
 problem tho, is that we see the post has a bunch of seemingly unrelated
 {{unknown}} cached oembeds.

 || 212813662    || XXXXXXX ||   _oembed_019482445bf6f815c668416775e9dcfd
 || {{unknown}} ||
 || 212813563    || XXXXXXX ||   _oembed_05b733c148b07e2d3f839a31a05ffd03
 || {{unknown}} ||
 || 212813551    || XXXXXXX ||   _oembed_06333e71ec55ee07dd85d5dab47e9584
 || {{unknown}} ||
 || 212813565    || XXXXXXX ||   _oembed_067fadb5312b1d7caaafb4cd3b1f40ad
 || {{unknown}} ||
 || 212813626    || XXXXXXX ||   _oembed_08e7890c32bc5f0d9616f5c5cbd13488
 || {{unknown}} ||
 || 212813628    || XXXXXXX ||   _oembed_0f2fea88d5bc5965b3200003d12c1414
 || {{unknown}} ||
 || 212813621    || XXXXXXX ||   _oembed_0fbba40c78a857cdde757499e842ac1b
 || {{unknown}} ||
 || 212813574    || XXXXXXX ||   _oembed_11c042cc437db317b3b3af8148d85ba5
 || {{unknown}} ||
 || 212813653    || XXXXXXX ||   _oembed_11e89cd4ab6fb62368338cc9cdf4066a
 || {{unknown}} ||
 || 212813624    || XXXXXXX ||   _oembed_13a1c19c94d507117adb625fcce37f30
 || {{unknown}} ||
 || 212813595    || XXXXXXX ||   _oembed_18e7578c7f1583cddef54aeaac503859
 || {{unknown}} ||
 || 212813594    || XXXXXXX ||   _oembed_1a8fab22feac3da3e3aadbb238871943
 || {{unknown}} ||
 || 212813655    || XXXXXXX ||   _oembed_1b39ee4c38d0683d5b90426cf1f711ba
 || {{unknown}} ||
 || 212813647    || XXXXXXX ||   _oembed_1d0743e42f2e5a7529898583b292f28f
 || {{unknown}} ||
 || 212813631    || XXXXXXX ||   _oembed_226f418793ee619cdd629328afa439aa
 || {{unknown}} ||
 || 212813567    || XXXXXXX ||   _oembed_25135b6200504f88346ad5a26e9addf6
 || {{unknown}} ||
 || 212813636    || XXXXXXX ||   _oembed_25532f9c9a7911aa2324b2bd2734398d
 || {{unknown}} ||
 || 212813583    || XXXXXXX ||   _oembed_262652332f0e21d3a2e64d2aded1abd0
 || {{unknown}} ||
 || 212813552    || XXXXXXX ||   _oembed_278a581de54f4fb3be04ba297ac03a8c
 || {{unknown}} ||
 || 212813660    || XXXXXXX ||   _oembed_2b14eca6e4d3837249ca8d1f0cc941cf
 || {{unknown}} ||
 || 212813599    || XXXXXXX ||   _oembed_2ca17fa661747ddb2c132867d9a5f0de
 || {{unknown}} ||
 || 212813570    || XXXXXXX ||   _oembed_2d2fff709e96cacc388b9a039fd359e6
 || {{unknown}} ||
 || 212813613    || XXXXXXX ||   _oembed_2d419ac7ba5bf21c66acf356b33ebb73
 || {{unknown}} ||
 || 212813557    || XXXXXXX ||   _oembed_2d46e3b3c383d8589b77907f57337d13
 || {{unknown}} ||
 || 212813577    || XXXXXXX ||   _oembed_2d8cb422cc7510e48bb2401bcff06577
 || {{unknown}} ||
 || 212813510    || XXXXXXX ||   _oembed_2fd986240c681e44bd9c5629eb3c6d42
 || <iframe width="500" height="281" src="https://www.youtube.com/embed
 /pKcJ-0bAHB4?feature=oembed" frameborder="0" allowfullscreen></iframe> ||
 ||| 212813569|  || XXXXXXX ||   _oembed_315d0449f8a3d2dedb44dac06abf0a4f
 || {{unknown}} ||
 || 212813654    || XXXXXXX ||   _oembed_3171236843b169f9868f21f22fffd369
 || {{unknown}} ||
 || 212813607    || XXXXXXX ||   _oembed_345bca2898ff898e1c3824bf4713f556
 || {{unknown}} ||
 || 212813566    || XXXXXXX ||   _oembed_3736276c9b1bb5e4fcadfc60e8cceef3
 || {{unknown}} ||
 || 212813560    || XXXXXXX ||   _oembed_3b32c739ed5a71e15e8b18e9c570bce6
 || {{unknown}} ||
 || 212813629    || XXXXXXX ||   _oembed_3c8d27f4596238c4b3c07655b9fc5e0e
 || {{unknown}} ||
 || 212813620    || XXXXXXX ||   _oembed_3f4b49fe0a26d22e977dd82f7e12319f
 || {{unknown}} ||
 || 212813601    || XXXXXXX ||   _oembed_409b1a5ffd3e5776a4bbc72ba0efa5a3
 || {{unknown}} ||
 || 212813641    || XXXXXXX ||   _oembed_4500e22a64a5db5664a882f6fde6a923
 || {{unknown}} ||
 || 212813575    || XXXXXXX ||   _oembed_49cb1728eb01181528a5d829a5a9cab6
 || {{unknown}} ||
 || 212813571    || XXXXXXX ||   _oembed_4bb292aeca1d6c5c8096e2b69231647c
 || {{unknown}} ||
 || 212813588    || XXXXXXX ||   _oembed_4be491bba71069499ae68488fc7ad90d
 || {{unknown}} ||
 || 212813614    || XXXXXXX ||   _oembed_4e9fe148b1e732a279d401f94bb3daa7
 || {{unknown}} ||
 || 212813596    || XXXXXXX ||   _oembed_55c635268acff81868cfc8b656a0fdb5
 || {{unknown}} ||
 || 212813561    || XXXXXXX ||   _oembed_56aad46b19331d5ae91509c9b0ed0363
 || {{unknown}} ||
 || 212813658    || XXXXXXX ||   _oembed_578850480ce954b8237c4a3001e10ac7
 || {{unknown}} ||
 || 212813648    || XXXXXXX ||   _oembed_58d33a64abc80113d04cfb0aa2bb4599
 || {{unknown}} ||
 || 212813559    || XXXXXXX ||   _oembed_5b76b33d1e0b4fb98c4f091c52bd1be4
 || {{unknown}} ||
 || 212813649    || XXXXXXX ||   _oembed_5c8fc9cb618ac15b09dd5c5149229b08
 || {{unknown}} ||
 || 212813615    || XXXXXXX ||   _oembed_6100f4da315e13b5077c436f9f16b6f3
 || {{unknown}} ||
 || 212813652    || XXXXXXX ||   _oembed_65c4cc9bcaa6266d82b30dd2f517dd3f
 || {{unknown}} ||
 || 212813598    || XXXXXXX ||   _oembed_66f9e465b433fe989f9e2336b32cd2d9
 || {{unknown}} ||
 || 212813622    || XXXXXXX ||   _oembed_68bc0d65c322ed094100f9da6a23d314
 || {{unknown}} ||
 || 212813637    || XXXXXXX ||   _oembed_69f1ea06d08322e7f24e92f9d2b06948
 || {{unknown}} ||
 || 212813640    || XXXXXXX ||   _oembed_6a43c9f6104e4bb06877297b9807cbdf
 || {{unknown}} ||
 || 212813572    || XXXXXXX ||   _oembed_6ab05d30680db2f8f2736306a6c60060
 || {{unknown}} ||
 || 212813656    || XXXXXXX ||   _oembed_6b2fdd193936b03e61eeafe2a4776b8e
 || {{unknown}} ||
 || 212813554    || XXXXXXX ||   _oembed_6d4d9e8bee033cdebc4522f2db95eb76
 || {{unknown}} ||
 || 212813568    || XXXXXXX ||   _oembed_726b879693a20c0a1faf17191be8f501
 || {{unknown}} ||
 || 212813553    || XXXXXXX ||   _oembed_733d8db1e82bab273a464d0b329f9e5e
 || {{unknown}} ||
 || 212813650    || XXXXXXX ||   _oembed_747a754752d537e20bcf7f137043b8a0
 || {{unknown}} ||
 || 212813603    || XXXXXXX ||   _oembed_75276fe25fa16591203b1664bceb23e8
 || {{unknown}} ||
 || 212813590    || XXXXXXX ||   _oembed_754c24bd8f161ddfed16e48dc188d165
 || {{unknown}} ||
 || 212813602    || XXXXXXX ||   _oembed_767251d09e1b0c1adb8299fa079f5be8
 || {{unknown}} ||
 || 212813645    || XXXXXXX ||   _oembed_7ac21b99e774772a72962615255c99bf
 || {{unknown}} ||
 || 212813623    || XXXXXXX ||   _oembed_7d67911292af54d1ffbef10628d37607
 || {{unknown}} ||
 || 212813663    || XXXXXXX ||   _oembed_804e6fddb6b8161e90ae41340e0cf3d2
 || <a data-flickr-embed="true"
 href="https://www.flickr.com/photos/59179465@n03/sets/72157625859691347/"
 title="Shanghai by 80m, on Flickr"><img
 src="https://farm6.staticflickr.com/5299/5420131532_0f66732cf6_n.jpg"
 width="320" height="240" alt="IMG_1864"></a><script async
 src="https://embedr.flickr.com/assets/client-code.js"
 charset="utf-8"></script> ||
 || 212813633    || XXXXXXX ||   _oembed_810a78ebb34b2a43d2a2bdea04d37ec0
 || {{unknown}} ||
 || 212813564    || XXXXXXX ||   _oembed_832a487bd385e982a45a35bd750ee77f
 || {{unknown}} ||
 || 212813556    || XXXXXXX ||   _oembed_8445df49d2f06ebe2cb17186e7ba5856
 || {{unknown}} ||
 || 212813495    || XXXXXXX ||   _oembed_86d69d9afb69aa33130e9ebd9a7dd5c7
 || {{unknown}} ||
 || 212813635    || XXXXXXX ||   _oembed_889614a734a7bd809c3c04c9dc2d5d37
 || {{unknown}} ||
 || 212813597    || XXXXXXX ||   _oembed_91b420166abca23dafd0ec33b016aaf7
 || {{unknown}} ||
 || 212813582    || XXXXXXX ||   _oembed_962b51118d7cda2cf255da3ed04041f3
 || {{unknown}} ||
 || 212813646    || XXXXXXX ||   _oembed_99f136ae5b6b645d076e04b539a84e29
 || {{unknown}} ||
 || 212813634    || XXXXXXX ||   _oembed_9c50cd161943413afe5527471fbfaed7
 || {{unknown}} ||
 || 212813600    || XXXXXXX ||   _oembed_9e2ed787b6c53a9d116123a8cfb172c3
 || {{unknown}} ||
 || 212813608    || XXXXXXX ||   _oembed_a162ce5fb22a4116aa40b0485e0d274d
 || {{unknown}} ||
 || 212813578    || XXXXXXX ||   _oembed_a21e006acbbb598e27b9f0b4dafd4fae
 || {{unknown}} ||
 || 212813617    || XXXXXXX ||   _oembed_a317a6ffcdde99bfd22cbdccff2ab433
 || {{unknown}} ||
 || 212813591    || XXXXXXX ||   _oembed_a5f822d484fc010ca0a4ff5cb63f8c63
 || {{unknown}} ||
 || 212813555    || XXXXXXX ||   _oembed_a996edc9dcda39b8e4b5186ff4626372
 || {{unknown}} ||
 || 212813589    || XXXXXXX ||   _oembed_ab155330e11c75dee0495ad6ffa34e1f
 || {{unknown}} ||
 || 212813558    || XXXXXXX ||   _oembed_ac7cd3b324e594bcffc32b609ce72274
 || {{unknown}} ||
 || 212813661    || XXXXXXX ||   _oembed_ad5604aee32ef5e7dd5935a793d00a65
 || {{unknown}} ||
 || 212813593    || XXXXXXX ||   _oembed_b0eebf28b478cb3bec32f2c3ee86e417
 || {{unknown}} ||
 || 212813579    || XXXXXXX ||   _oembed_b274dc0fda0114189c52192dfd763705
 || {{unknown}} ||
 || 212813618    || XXXXXXX ||   _oembed_b474c6d5f583b3c649b0d66b6cc9c34d
 || {{unknown}} ||
 || 212813619    || XXXXXXX ||   _oembed_b5101c0c5c509875f9eeaa4ace6fd56e
 || {{unknown}} ||
 || 212813639    || XXXXXXX ||   _oembed_be319bd077ea34f52fede0f9cdc72543
 || {{unknown}} ||
 || 212813632    || XXXXXXX ||   _oembed_c379af75555049e509cecd9225704cde
 || {{unknown}} ||
 || 212813627    || XXXXXXX ||   _oembed_cc10f88168d5b509105c5350ed249059
 || {{unknown}} ||
 || 212813585    || XXXXXXX ||   _oembed_d2702a437bd8b305fc1b37e0322dd363
 || {{unknown}} ||
 || 212813592    || XXXXXXX ||   _oembed_d2d1f1ef241851ad3f5c9c32df178b99
 || {{unknown}} ||
 || 212813576    || XXXXXXX ||   _oembed_d41b548a1d0b7a685fb72a66056e403f
 || {{unknown}} ||
 || 212813562    || XXXXXXX ||   _oembed_d4adce7ecce0c5a44bfdc20e409d1eb0
 || {{unknown}} ||
 || 212813609    || XXXXXXX ||   _oembed_d6981e1b821bf60f8fa19608ee5f77e6
 || <iframe src="https://player.vimeo.com/video/82404988" width="480"
 height="270" frameborder="0" title="Rudy Rucker interviewed by V. Vale for
 RESearch, Aug 29, 2013" webkitallowfullscreen mozallowfullscreen
 allowfullscreen></iframe> ||
 || 212813581    || XXXXXXX ||   _oembed_d71bd7d82e514a645480092c4702ae8c
 || {{unknown}} ||
 || 212813584    || XXXXXXX ||   _oembed_d84ea344937ad54b43411362b815568a
 || {{unknown}} ||
 || 212813498    || XXXXXXX ||   _oembed_dc7ec700d3c5d8f542a75396c48483ba
 || {{unknown}} ||
 || 212813665    || XXXXXXX ||   _oembed_ddb8110a45f8abe4f0d3f52fdde2df8f
 || {{unknown}} ||
 || 212813651    || XXXXXXX ||   _oembed_de1e7a17b097b36017f7564636988b7f
 || {{unknown}} ||
 || 212813659    || XXXXXXX ||   _oembed_e09f12bea7018607c92d2a1a57d18797
 || {{unknown}} ||
 || 212813630    || XXXXXXX ||   _oembed_e0eacbc1fd42db8d9930ccf5220ec5c3
 || {{unknown}} ||
 || 212813638    || XXXXXXX ||   _oembed_e42372a87ac019fc1bf0cb1c53135ee5
 || {{unknown}} ||
 || 212813606    || XXXXXXX ||   _oembed_e67c54e7522cf9d3c2ebda1797ddb155
 || {{unknown}} ||
 || 212813573    || XXXXXXX ||   _oembed_e75c46e8175f417103f000dc9b2f483e
 || {{unknown}} ||
 || 212813657    || XXXXXXX ||   _oembed_e92a3736fbeed20d30a2cd29bac63dc7
 || {{unknown}} ||
 || 212813587    || XXXXXXX ||   _oembed_eaa55a35087c3ca3a78795db6d4cb32c
 || {{unknown}} ||
 || 212813642    || XXXXXXX ||   _oembed_eb5e8a11b1900e5a73838bffe653650a
 || {{unknown}} ||
 || 212813644    || XXXXXXX ||   _oembed_ec339f70068a10e5f020aec3c91c0f8a
 || {{unknown}} ||
 || 212813612    || XXXXXXX ||   _oembed_f1552b43d58c4813bf7a92917698cba7
 || {{unknown}} ||
 || 212813625    || XXXXXXX ||   _oembed_f19ad404e779f2810a51d25e23217734
 || {{unknown}} ||
 || 212813580    || XXXXXXX ||   _oembed_f4fae2c2b68478b151ee643f4a06b162
 || {{unknown}} ||
 || 212813643    || XXXXXXX ||   _oembed_f6bc9531d3417efb149ccd2e6a3daae8
 || {{unknown}} ||
 || 212813611    || XXXXXXX ||   _oembed_f729439c520992349930b46da355e87b
 || {{unknown}} ||
 || 212813605    || XXXXXXX ||   _oembed_f895c18f48460ef5f70fafbf2db43a53
 || {{unknown}} ||
 || 212813616    || XXXXXXX ||   _oembed_fbe4ba0d27296353981ef57b63943528
 || {{unknown}} ||
 || 212813586    || XXXXXXX ||   _oembed_fc6a9cf9956076faafb731b8eafd1c65
 || {{unknown}} ||
 || 212813511    || XXXXXXX ||
 _oembed_time_2fd986240c681e44bd9c5629eb3c6d42 || 1442602924 ||
 || 212813664    || XXXXXXX ||
 _oembed_time_804e6fddb6b8161e90ae41340e0cf3d2 || 1442603203 ||
 || 212813610    || XXXXXXX ||
 _oembed_time_d6981e1b821bf60f8fa19608ee5f77e6 || 1442603194 ||

--
Ticket URL: <https://core.trac.wordpress.org/ticket/33970#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform


More information about the wp-trac mailing list