webimpian
4/16/2018 - 4:24 AM

Check wp_postmeta keys, rows, and data size

Reference from https://github.com/davidegreenwald/How-to-Deep-Clean-Your-WordPress-MySQL-Database

wp-postmeta
content_copyfile_download
SELECT meta_key, 
COUNT(*) AS `Rows`,  
  ROUND(
    SUM(
      LENGTH(
        CONCAT(meta_id, post_id, meta_key, meta_value)
      )
    )/1048567, 2
  )
AS `Size_in_MB`

-- Refer $table_prefix
FROM wp_postmeta
GROUP BY meta_key
ORDER BY `Size_in_MB` DESC;