René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Heavy update query for wp_options key wordpress-https_path_cache causes high SQL transaction log growth","articleBody":"Hi,\r\n\r\nI have a very active WP running WordPress 4.9.4 with WordPress HTTPS 3.4.0. Yesterday we started seeing the MySQL transaction log on our server grow rapidly due to a number of extremely heavy update queries to the wp_options table (queries in excess of 3 million characters). We did not notice any increase in hit count or change in pattern to the hit count.\r\n\r\nHere is an example of the query (highly truncated because of extreme length).\r\n\r\n`UPDATE wp_options SET option_value = a:63889:{s:19:\\\"/category/featured/\\\";i:0\r\n{truncated}\r\nWHERE option_key = 'wordpress-https_path_cache'`\r\n\r\nIt looks like this might be caused by the update in lib/WordPressHTTPS.php:install():\r\n\r\n`$this-\u003esetSetting('path_cache', $this-\u003e_settings['path_cache'], $blog_id);`\r\n\r\nI can clear the cache from the admin panel, but the size of the database entry continues to grow drastically. \r\n\r\nI am looking to determine exactly what this function is doing, and why it seems to be causing such heavy update queries. I have disabled the plugin until I am able to find out more information\r\n\r\nThanks,\r\nJory\r\n\r\n\r\n","author":{"url":"https://github.com/jormaster3k","@type":"Person","name":"jormaster3k"},"datePublished":"2018-03-08T16:12:34.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":9},"url":"https://github.com/64/wordpress-https/issues/64"}