urgent ！How to clean up the large amount of db space left by Spectra

  • Hello everyone,Spectra’s _uag_page_assets takes up a lot of our MySQL storage, our company’s WordPress uses Spectra, which occupies more than 6 million records in the wp_postmeta table of WordPress. How can we clean it up? We have currently disabled the plugin, but it still occupies space.

    select count(*) from wp_postmeta where meta_key in (‘_uag_page_assets’,’_uag_css_file_name’) and post_id>99999
    This SQL query yields more than 6 million records, occupying more than 500G of space.

    | _uag_page_assets | 6148972 |
    | _uag_css_file_name | 140704 |

  • You must be logged in to reply to this topic.