DELETE FROM wp_comments WHERE comment_approved = 0;
list junk entries:
SELECT * FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments)
Delete junk entries:
DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments)
Disable comments for old blog entires:
UPDATE wp_posts SET comment_status = 'closed' WHERE post_date < '2019-01-01' AND post_status = 'publish';
Disable comments in whole Wordpress:
WP-Admin: Ustawienia → Dyskusja: Zezwól na komentowanie nowych artykułów
UPDATE wp_options SET option_value = 'closed' WHERE option_name = 'default_comment_status';