I have a log_url table that is close to a million rows. I have run log cleaning but it doesn't seem to put a dent into it (confirmed that the cron is running).
After some investigation, I see that the query to get rows to clean from log_url is this (in Mage_Log_Model_Resource_Log::_cleanUrls()):
SELECT `url_info_table`.`url_id` FROM `log_url_info` AS `url_info_table` LEFT JOIN `log_url` AS `url_table` ON url_info_table.url_id = url_table.url_id WHERE (url_table.url_id IS NULL) LIMIT 100;
The method that calls this does not take into account the number of days you specify in the system config at all.
Can anyone tell me why that's the case for the log_url table only? All of the other log tables will take into account the system config settings. I want to clear this table out but I'm a bit nervous as to what may happen when I do. I understand that it could affect customers compared products history, but I have entries going back to 2012.