We have had slow query threshold set to 5 seconds and over years this table has grown up to be very large and I see slow_log.CSV size to be 120GB in mysql data directory.
I planning to run a truncate slow_log to clear this table but concern is this table is huge would there be any issue doing so ?
is it safe to do so?
has any one tried this before ?
any other alternate option ?
I am using MySQL 5.1.52