Clear older recent log messages in Drupal 10, retaining only the last 500

clear-older-recent-log-messages-in-drupal.sql

-- Remove all watchdog's records from a MySQL table except for the last 500.

DELETE FROM `watchdog`
WHERE wid NOT IN (
    SELECT wid
    FROM (
        SELECT wid
        FROM `watchdog`
        ORDER BY wid DESC
        LIMIT 500
    ) AS t
);